Comments by Member 9196002 (Top 23 by date)

userManager user = Global.sessions.getUser(Request.UserHostName);
ArrayList reports = (ArrayList)Session["reportSelect"];
foreach (GridViewRow row in reportTable.Rows)
{
CheckBox cb = (CheckBox)row.Cells[8].FindControl("cb");

if (cb.Checked)
{
testBench bench = new testBench();


and then the rest of the code follows

yes..but even when i select the checkbox where the value is 123 it doesn't meet that condition.

Well.this is what i have been trying to do but it doesnt seem to be meeting the first condition itself.
int value;
int.TryParse(bench.costPos, out value);
if (value == 123)
{
MailMessage message = new MailMessage("no-reply@gmail.com",
"tony.romo@gmail.com", "Kostenstelle : 123",
"Kostenstelle : 123");
/* create SMTP Client and add credentials */
SmtpClient smtpClient = new SmtpClient("SERVER");
smtpClient.UseDefaultCredentials = true;
/*Send the message */
smtpClient.Send(message);
}
else
{
MailMessage message = new MailMessage("no-reply@gmail.com",
"victoria.ray@gmail.com", "Kostenstelle : 456",
"Kostenstelle : 456");
/* create SMTP Client and add credentials */
SmtpClient smtpClient = new SmtpClient("SERVER");
smtpClient.UseDefaultCredentials = true;
/*Send the message */
smtpClient.Send(message);

ok!! :)thanks again!!

i figured out what the issue was..Costpos is of the type String but the value in the document i was referring to which was 123 is of int..is there a workaround for this comparision?

ok!!i shall check that..i guess it should work!! thanks a lot!! :)

Oh ok.Does it make a difference if you are referencing b.costPos to a value from a datatable? 123 is the value stored in the document.
and cb is not null..i made sure its checked

the problem is that the condition is not meeting

you were right..the condition is not met.

this is the one without the hyperlink..with the option of a check box to select the record

namespace Website.user
{
public partial class reportSelect : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
userManager user = Global.sessions.getUser(Request.UserHostName);
ArrayList reports;
ArrayList cmd = new ArrayList(), value = new ArrayList();
testBench bench;
int i;

if (user.getPrivilege() < 0)
Response.Redirect("~/privilege.aspx");

if (Session["reportSelect"] == null)
Response.Redirect("~/invalid.aspx");

//write the table with the reports
if (!IsPostBack)
{
reports = (ArrayList)Session["reportSelect"];

reportTable.DataSource = reports;
reportTable.DataBind();

i = 0;
cmd.Add("ID=");
value.Add("");
foreach (dbTypes.report report in reports)
{
value[0] = "'" + report.benchId + "'";
while (!Global.sessions.requestDatabaseAccess(Request.UserHostName, new string[] { "TEST_BENCH" }, databaseAccess.ACCESS_READ)) ;
try
{
bench = (testBench)Global.benchRead.getTestBenches((string[])cmd.ToArray(typeof(string)), (string[])value.ToArray(typeof(string)))[0];
}
catch (Exception ex)
{
Global.sessions.writeLog("Unable to get the bench!", "reportSelect.apsx", ex);
ErrorMsg.Text = "Fehler: Bitte wenden Sie sich an den Administrator!";
return;
}
finally
{
Global.sessions.releaseDatabases(Request.UserHostName, databaseAccess.ACCESS_READ);
}
reportTable.Rows[i].Cells[1].Text = report.reportId.ToString();
reportTable.Rows[i].Cells[2].Text = bench.mechId;
reportTable.Rows[i].Cells[3].Text = bench.elecId;
reportTable.Rows[i].Cells[4].Text = bench.name;
if(report.reportType == 1)
reportTable.Rows[i].Cells[5].Text = "Wartung";
else
reportTable.Rows[i].Cells[5].Text = "Reparatur";

reportTable.Rows[i].Cells[5].ForeColor = System.Drawing.Color.Black;

reportTable.Rows[i].Cells[6].Text = report.wishRepairDate;

if (report.assembler != "")
{
DataTable dt = helper.ldap.userAttributs(report.assembler, new List<string>(new string[] { "givenName", "sn" }), true);

foreach (DataRow aRow in dt.Rows)
{
foreach (DataColumn aColumn in dt.Columns)
{
if (aColumn.Caption == "givenName")
reportTable.Rows[i].Cells[7].Text = aRow[aColumn].ToString();
else if(aColumn.Caption == "sn")
reportTable.Rows[i].Cells[7].Text += " " + aRow[aColumn].ToString();
}
}
}
reportTable.Rows[i].Cells[8].Text = report.priority.ToString();

if (report.timeOutput != "01.01.1970 00:00:00")
{
reportTable.Rows[i].Cells[5].BackColor = System.Drawing.Color.LightGreen;
}
else
{
if (report.wishRepairDate == "")
{
reportTable.Rows[i].Cells[5].BackColor = System.Drawing.Color.Red;
i++;

hey christian,
I just made some changes to the program,rather than attaching a datasource, there was a piece of logic available with for a different page to fetch the records, i tried modifying that but again i seem to be facing the same issue.I'm not at all able to figure out to what the issue is

ohh ok!!i will try that.. :) thanks a lot!!

yes..its a datatable

the thing is i already tried this way and also adding a hyperlink through the edit column on the design page..it just doesnt seem to take the data text field.keeps on giving me an error saying "report_id" or any other variant i use does not exist in the data source.However in the database table..it is found under report_id itself

so it will be like

<asp:hyperlinkfield xmlns:asp="#unknown">
DataNavigateUrlFields="?/manage.aspx"
DataTextField="Report_id"
HeaderText="Auftragsnummer"
/>

Hi i have another question, I'm able to generate data as needed but is there a way to generate the same data in form of a sql script..its a lot easier for me to import the data in that way.

Thanks a lot.That was very helpful :)