protected void AddCheckOutContractor(object sender, EventArgs e) { AddNewCheckOutRequest objAddCheckOutRequest = new AddNewCheckOutRequest(); checkout objchickout = new checkout(); objchickout.checkin_id = "12345"; objchickout.checkout_id = "345"; objchickout.user_id = txtNricID3.Text; objchickout.user_name = txtName3.Text; objchickout.telephone = txtTeleNo3.Text; objchickout.user_address = txtAddress3.Text; objchickout.company_from = txtCompanyfrom3.Text; objchickout.vehicle_no = txtVehicleNo3.Text; objchickout.key_no = txtKeyNo3.Text; objchickout.user_image = "hdgsd"; objchickout.remarks = txtRemarks3.Text; objchickout.pass_no = txtPassType3.Text; objchickout.to_visit = txtServingAt1.Text; AdminBLL ws = new AdminBLL(); ws.AddCheckOutContractor(objchickout); HttpContext.Current.Items.Add("COMPLETE", "INSERT"); Server.Transfer("..//SMSADMIN//AddNewUserComplete.aspx"); }
protected void AddCheckOutSaleman(object sender, EventArgs e) { SpaMaster SM = (SpaMaster)Page.Master; log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { Boolean ok = false; String ZipRegex = "^[a-z A-Z 0-9]+$"; if (Regex.IsMatch(txtNricID3.Text, ZipRegex)) { SqlParameter[] para = new SqlParameter[2]; para[0] = new SqlParameter("@NRICno", SqlDbType.VarChar, 100); para[0].Value = txtNricID3.Text.Trim(); para[1] = new SqlParameter("@Role", SqlDbType.VarChar, 100); para[1].Value = txtrole.Text.Trim(); DataTable dt1 = dal.executeprocedure("SP_GetCheckInDetailByNRICrole", para, false); if (dt1.Rows.Count > 0) { objchickout.NRICno = dt1.Rows[0]["NRICno"].ToString(); objchickout.user_name = dt1.Rows[0]["user_name"].ToString(); objchickout.user_address = dt1.Rows[0]["user_address"].ToString(); objchickout.company_from = dt1.Rows[0]["company_from"].ToString(); objchickout.telephone = dt1.Rows[0]["telephone"].ToString(); objchickout.remarks = dt1.Rows[0]["remarks"].ToString(); objchickout.vehicle_no = dt1.Rows[0]["Vehicle_No"].ToString(); objchickout.key_no = dt1.Rows[0]["Key_no"].ToString(); objchickout.pass_no = dt1.Rows[0]["Pass_No"].ToString(); objchickout.PassType = dt1.Rows[0]["pass_type"].ToString(); objchickout.to_visit = dt1.Rows[0]["to_visit"].ToString(); objchickout.purpose = dt1.Rows[0]["purpose"].ToString(); objchickout.Item_Declear = dt1.Rows[0]["Item_Declear"].ToString(); objchickout.Checkin_DateTime = Convert.ToDateTime(dt1.Rows[0]["Checkin_DateTime"].ToString()); objchickout.user_image = dt1.Rows[0]["ImagePath"].ToString(); objchickout.Role = dt1.Rows[0]["Role"].ToString(); objchickout.checkin_id = dt1.Rows[0]["checkin_id"].ToString(); objchickout.Location_id = Session["LCID"].ToString(); /*string time = string.Empty; * time = ConfigurationManager.AppSettings.Get("SPATime"); * double newtime = Convert.ToDouble(time); * objchickout.Checkout_DateTime = DateTime.Now.AddHours(newtime);*/ objchickout.Checkout_DateTime = DateTime.Now; AdminBLL ws = new AdminBLL(); ws.AddCheckOutContractor(objchickout); ok = true; if (ok == true) { removedata(); UpdateKeyStatus(); UpdatePassStatus(); } HttpContext.Current.Items.Add("COMPLETE", "INSERT"); SM.ShowErrorMessage("Check Out Successfully"); // Server.Transfer("..//SMSADMIN//AlertUpdateComplete.aspx"); } else { SM.ShowErrorMessage("NRIC/FIN No. Already Checked Out ..!"); } } else if (txtPassno.Text != "") { SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@PassNo", SqlDbType.VarChar, 100); para[0].Value = txtPassno.Text.Trim(); DataTable dt1 = dal.executeprocedure("SP_GetCheckInDetailByPassNo", para, false); if (dt1.Rows.Count > 0) { objchickout.NRICno = dt1.Rows[0]["NRICno"].ToString(); objchickout.user_name = dt1.Rows[0]["user_name"].ToString(); objchickout.user_address = dt1.Rows[0]["user_address"].ToString(); objchickout.company_from = dt1.Rows[0]["company_from"].ToString(); objchickout.telephone = dt1.Rows[0]["telephone"].ToString(); objchickout.remarks = dt1.Rows[0]["remarks"].ToString(); objchickout.vehicle_no = dt1.Rows[0]["Vehicle_No"].ToString(); objchickout.key_no = dt1.Rows[0]["Key_no"].ToString(); objchickout.pass_no = dt1.Rows[0]["Pass_No"].ToString(); objchickout.PassType = dt1.Rows[0]["pass_type"].ToString(); objchickout.to_visit = dt1.Rows[0]["to_visit"].ToString(); objchickout.purpose = dt1.Rows[0]["purpose"].ToString(); objchickout.Item_Declear = dt1.Rows[0]["Item_Declear"].ToString(); objchickout.Checkin_DateTime = Convert.ToDateTime(dt1.Rows[0]["Checkin_DateTime"].ToString()); objchickout.user_image = dt1.Rows[0]["ImagePath"].ToString(); objchickout.Role = dt1.Rows[0]["Role"].ToString(); objchickout.checkin_id = dt1.Rows[0]["checkin_id"].ToString(); objchickout.Location_id = Session["LCID"].ToString(); /*string time = string.Empty; * time = ConfigurationManager.AppSettings.Get("SPATime"); * double newtime = Convert.ToDouble(time); * objchickout.Checkout_DateTime = DateTime.Now.AddHours(newtime);*/ objchickout.Checkout_DateTime = DateTime.Now; AdminBLL ws = new AdminBLL(); ws.AddCheckOutContractor(objchickout); ok = true; if (ok == true) { removedataByPassNo(); UpdateKeyStatus(); UpdatePassStatus(); } HttpContext.Current.Items.Add("COMPLETE", "INSERT"); // Server.Transfer("..//SMSADMIN//AlertUpdateComplete.aspx"); SM.ShowErrorMessage("Check Out Successfully"); } } else { //lblerror.Visible = true; //lblerror.Text = "Invalid passNo. ..!"; SM.ShowErrorMessage("Invalid passNo. ..!"); // lblerr1.Visible = true; } } catch (Exception ex) { logger.Info(ex.Message); } }