void login()
{
String ZipRegex = "^[0-9]+$";
GetItemData objadditemdata = new GetItemData();
ItemData Objitemdata = new ItemData();
// DateTime datetime;
cn = a.getconnection();
String q = txtItemNo.Text;
//String x = "select Item_no from Item_Manager";
//SqlCommand cmd3 = new SqlCommand(x, cn);
// SqlDataAdapter adp = new SqlDataAdapter(cmd3);
DataSet ds = dal.getdataset("select Item_no from Item_Manager");
// adp.Fill(ds);
int count = ds.Tables[0].Rows.Count;
for (i = 0; i < count; i++)
{
String z = ds.Tables[0].Rows[i].ItemArray[0].ToString();
if (string.Equals(q, z, StringComparison.CurrentCultureIgnoreCase))
{
lblerror.Visible = true;
lblerror.Text = "Item No. Already Exist ..!";
lblerr2.Visible = true;
throw new Exception();
}
}
String q1 = txtlogednric.Text;
// String x1 = "select NRICno from UserInformation";
// SqlCommand cmd4 = new SqlCommand(x1, cn);
// SqlDataAdapter adp4 = new SqlDataAdapter(cmd4);
DataSet ds4 = dal.getdataset("select NRICno from UserInformation");
//adp4.Fill(ds4);
int count1 = ds4.Tables[0].Rows.Count;
for (i = 0; i < count1; i++)
{
String z1 = ds4.Tables[0].Rows[i].ItemArray[0].ToString();
if (string.Equals(q1, z1, StringComparison.CurrentCultureIgnoreCase))
{
//Objitemdata.Item_no = txtItemNo.Text;
//Objitemdata.Item_Description = txtItemdescription.Text;
//Objitemdata.Item_quantity = txtItemquantity.Text;
//Objitemdata.loged_Nric = txtlogednric.Text;
//Objitemdata.loged_Name = txtlogedname.Text;
//Objitemdata.loged_CompName = txtlogedcompname.Text;
//Objitemdata.loged_Time =DateTime.Now;
//Objitemdata.Found_Nric = txtfoundnric.Text;
//Objitemdata.Status = cmbstatus.Text;
//Objitemdata.Found_Time = DateTime.Now;
AdminBLL ws = new AdminBLL();
ws.AddItem(Objitemdata);
UpdateAutogenCode();
HttpContext.Current.Items.Add("COMPLETE", "INSERT");
Server.Transfer("..//SMSADMIN//AlertUpdateComplete.aspx");
}
}
lblerror.Visible = true;
lblerror.Text = "Invalid NRIC/FIN No. ..!";
lblerr1.Visible = true;
}
