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);
}
}
