protected void imgUpdate_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{ SpaMaster MyMasterPage = (SpaMaster)Page.Master;
DataTable dtViewItems = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "97");
if (dtViewItems.Rows.Count > 0)
{
if (ViewState["AddItem_ID"] != null)
{
string _BTId = ViewState["AddItem_ID"].ToString();
PopulatePageCntrls(_BTId);
ModalPopupupdate.Show();
}
}
else
{
MyMasterPage.ShowErrorMessage("You Do not Have Permission..!");
} }
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
String tovisit()
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
String zipRegex = "^[a-z A-Z]+$";
if (txtToVisit2.Text != "")
{
if (Regex.IsMatch(txtToVisit2.Text, zipRegex))
{
return(txtToVisit2.Text);
}
else
{
MyMasterPage.ShowErrorMessage("Please Fill String Values ..!");
//lblerror.Visible = true;
//lblerror.Text = "Please Fill String Values ..!";
//lblerr6.Visible = true;
//throw new Exception();
return("");
}
}
else
{
MyMasterPage.ShowErrorMessage("Please Fill To Visit Values ..!");
//lblerror.Visible = true;
//lblerror.Text = "Please Fill To Visit Values ..!";
//lblerr6.Visible = true;
//throw new Exception();
return("");
}
return("");
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string argitemid = hdnitmID.Value.ToString();
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
if (!string.IsNullOrEmpty(argitemid))
{
DataAccessLayer dal = new DataAccessLayer();
dal.executesql("delete from Shift_Master where shift_ID=" + argitemid);
BindGridTelerik();
ModalPopupDelete.Hide();
MyMasterPage.ShowErrorMessage("Record Deleted Successfully");
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Deletd Submitted..!');", true);
//HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "DELETE");
//Server.Transfer("CompleteForm.aspx");
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void checkTime()
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
DBConnectionHandler1 db = new DBConnectionHandler1();
SqlConnection cn = db.getconnection();
cn.Open();
SqlCommand cmd = new SqlCommand("select checkin_DateTime,user_name from checkin_manager where NRICno=@NRICno", cn);
cmd.Parameters.AddWithValue("@NRICno", txtNricID2.Text);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime currentTime = DateTime.Now;
DateTime DbTime = dr.GetDateTime(0);
double diff = (currentTime - DbTime).TotalHours;
if (diff > 6)
{
Label1.Visible = true;
MyMasterPage.ShowErrorMessage("Your Time is Over...");
////Label1.Text = "Your Time is Over...";
//string Msg = "<script>confirm('Time Over');</script>";
//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "confirm", Msg, false);
}
}
//========================//
dr.Close();
dr.Dispose();
cn.Close();
//========================//
}
protected void ImgUpdate_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
DataTable dtViewEvents = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "23");
if (dtViewEvents.Rows.Count > 0)
{
if (ViewState["Event_ID"] != null)
{
Fill();
this.ModalPopupUpdate.Show();
}
}
else
{
MyMasterPage.ShowErrorMessage("You Do Not Have permission..!");
}
}
catch (Exception ex)
{
logger.Info("AdminCappAsset(AssertImgUpdate_Click):" + ex.Message);
}
}
protected void Deletepopup_Yes_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
if (ViewState["Event_ID"] != null)
{
DeleteItem(ViewState["Event_ID"].ToString());
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Delete SuccessFully');", true);
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
MyMasterPage.ShowErrorMessage("Record Deleted SuccessFully..!");
BindGridWithFilter();
ViewState["Event_ID"] = null;
ModalPopupDelete.Hide();
}
}
catch (Exception ex)
{
logger.Info("AdminCappAsset(AssertImgUpdate_Click):" + ex.Message);
}
}
protected void txtNricID3_TextChanged(object sender, EventArgs e)
{
SpaMaster SM = (SpaMaster)Page.Master;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SqlDataReader rd = dal.getDataReader("select Top 1 NRICno,FirstName,Staff_TelPhone,ImagePathName from UserInformation where NRICno='" + txtNricID3.Text + "' and Role='" + txtrole.Text + "' and Staff_ID='" + Session["StaffID1"].ToString() + "'");
if (rd.HasRows)
{
if (rd.Read())
{
txtNricID3.Text = rd.GetValue(0).ToString();
txtName3.Text = rd.GetValue(1).ToString();
txtTeleNo3.Text = rd.GetValue(2).ToString();
Image3.ImageUrl = rd.GetValue(3).ToString();
}
rd.Close();
gvContractorTable.Visible = true;
BindGridWithFilterStaff();
}
else
{
//lblerror.Visible = true;
//lblerror.Text = "Invalid NRIC/FIN No. ..!";
//lblerr1.Visible = true;
SM.ShowErrorMessage("Invalid NRIC/FIN No. ..!");
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "MenuShow", "ShowManualPortion();", true);
}
protected void btnAssignmentAdd_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
SqlParameter[] para = new SqlParameter[9];
para[0] = new SqlParameter("@Location", ddlLocationAdd.Text.Trim());
para[1] = new SqlParameter("@CompletedBy", txtCompletedByAdd.Text.Trim());
para[2] = new SqlParameter("@Date", txtdatefromAdd.Text.Trim());
para[3] = new SqlParameter("@ClientName", txtClientName.Text.Trim());
para[4] = new SqlParameter("@Complaints", txtcomplaints.Text.Trim());
para[5] = new SqlParameter("@PositiveComment", txtpositivecomments.Text.Trim());
para[6] = new SqlParameter("@Deployment", txtdeployment.Text.Trim());
para[7] = new SqlParameter("@UpcomingEvent", txtupcomingevent.Text.Trim());
para[8] = new SqlParameter("@Remarks", txtremarks.Text.Trim());
dal.executeprocedure("SP_AddClientVisitMinutes", para);
HttpContext.Current.Items.Add("COMPLETE", "INSERT");
// Server.Transfer("CompleteForm.aspx");
MyMasterPage.ShowErrorMessage("Record Insert SuccessFully");
//dal.executesql("Update PreRegisteredVisits set FromDate='" + txtFromDate.Text.Trim() + "',ToDate='" + txtToDate.Text.Trim() + "',ExpectedTime='" + newtime + "',Name='" + txtName.Text.Trim() + "',Company='" + txtCompany.Text.Trim() + "',Position='" + txtPosition.Text.Trim() + "',Invited_By='" + txtInvitedBy.Text.Trim() + "',LocationID='" + Searchid.Text + "',VechicleNo='" + txtVechicle.Text + "',Purpose='" + txtpurpose.Text + "',Telephoe='"+txttelephone.Text+"' where PRVID ='" + hdnCSID.Value + "' ");
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Insert SuccessFully');", true);
BindGrid();
ClearAdd();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void imdAdd_Click(object sender, EventArgs e)
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
DataTable dtAddNewPass = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "93");
if (dtAddNewPass.Rows.Count > 0)
{
getPassTypeAdd("passtype");
if (Session["ManagementRole"].ToString().ToLower() == "superuser")
{
getLocationName();
}
else
{
getLocationNameById(Session["LCID"].ToString());
}
ModalPopupAdd.Show();
}
else
{
MyMasterPage.ShowErrorMessage("You Don not Have Permission ..!");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
dal.executesql("delete from RoleMenuMap where RoleID=" + tvRoleHierarchy.SelectedValue);
foreach (TreeNode tn in tvFunctions.Nodes)
{
if (tn.ChildNodes.Count > 0)
{
AssignCheckedMenus(tn);
}
else
{
if (tn.Checked)
{
dal.executesql("insert into RoleMenuMap (RoleID,MenuID) values (" + tvRoleHierarchy.SelectedNode.Value + "," + tn.Value + ")");
}
}
}
MyMasterPage.ShowErrorMessage("Permission has been Successfully assigned!!");
//lblerror.Text = "Permission has been Successfully assigned!!";
// Server.Transfer("~//SMSADMIN//AlertUpdateComplete.aspx");
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void DeleteItem()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
if (!string.IsNullOrEmpty(ViewState["Alert_ID"].ToString().Trim()))
{
//AdminBLL ws = new AdminBLL();
//DeleteAlertRequest _req = new DeleteAlertRequest();
//_req.Alert_ID = ViewState["Alert_ID"].ToString().Trim();
//ws.DeleteAlert(_req);
string argId1 = ViewState["Alert_ID"].ToString().Trim();
dal.executesql("Delete From Alert_Handling Where Alert_ID='" + argId1 + "' ");
// HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "DELETE");
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
MyMasterPage.ShowErrorMessage("Record Delete sucessfully ..!");
ModalPopupDelete.Hide();
ModalPopupDelete.Hide();
BindGridWithFilter();
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void BtnUpload_Click1(object sender, EventArgs e)
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
if (FileUpload1.PostedFile.FileName != "")
{
ImgUpload.Visible = true;
string file = FileUpload1.PostedFile.FileName;
string filename = Path.GetFileName(FileUpload1.FileName);
thubpath = ("/Images" + "/" + filename);//Chnages According to Requirement Logic
//thubpathMaster=("master/Images"+"/"+filename);//According to Requirement
FileUpload1.PostedFile.SaveAs(Server.MapPath("Images/") + filename);
//FileUpload1.PostedFile.SaveAs(Server.MapPath("master/Images/") + filename);//According to Requirement
ImgUpload.ImageUrl = thubpath;
TextBox1.Text = thubpath;
TextBox2.Text = Server.MapPath(thubpath).Trim();
BtnSave.Visible = true;
}
else
{
ImgUpload.Visible = false;
MyMasterPage.ShowErrorMessage("Please choose a file.");
//lblErr.Visible = true;
//lblErr.Text = "Please choose a file!!!";
}
}
protected void lnkViewKey_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
DataTable dtAddNewKey = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "89");
DataTable dtViewKey = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "90");
if (dtAddNewKey.Rows.Count > 0)
{
Response.Redirect("../SMSAdmin/AddNewKey.aspx");
}
else if (dtViewKey.Rows.Count > 0)
{
Response.Redirect("../SMSAdmin/AddNewKey.aspx");
}
else
{
MyMasterPage.ShowErrorMessage("You Don not Have Permission..!");
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
String PassOccupied()
{
SpaMaster SM = (SpaMaster)Page.Master;
string passvalue = txtPassNo3.Text.Trim();
if (txtPassNo3.Text.Trim() != "")
{
//string passvalue = Addpass();
column = "Pass_No";
table = "checkin_manager";
where = "Where Pass_No = '" + passvalue + "' ";
if (b.isexistBLL(column, table, where))
{
//lblerror.Visible = true;
//lblerror.Text = "Pass No. is Occupied ..!";
//lblerr2.Visible = true;
SM.ShowErrorMessage("Pass No. is Occupied ..!");
throw new Exception();
}
return(passvalue);
}
return(passvalue);
}
//private void fillAlertType()
//{
// ddlAlertType.Items.Clear();
// ddlAlertType.Items.Add(" ");
// string ID = "alerttype";
// SqlParameter[] para1 = new SqlParameter[1];
// para1[0] = new SqlParameter("@ID", ID);
// DataTable dt = dal.executeprocedure("sp_getLogvaluebyID", para1, true);
// if (dt.Rows.Count > 0)
// {
// for (int k = 0; k < dt.Rows.Count; k++)
// {
// ddlAlertType.Items.Add(dt.Rows[k][0].ToString());
// }
// }
//}
private void DeleteItem(string argalertid)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
if (!string.IsNullOrEmpty(argalertid))
{
AdminBLL ws = new AdminBLL();
DeleteAlertRequest _req = new DeleteAlertRequest();
_req.Alert_ID = argalertid.ToString();
ws.DeleteAlert(_req);
MyMasterPage.ShowErrorMessage("Record Deleted Successfully..!");
ModalPopupDelete.Hide();
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
if (!string.IsNullOrEmpty(hdnitmID.Value.ToString()))
{
AdminBLL ws = new AdminBLL();
DeleteInventoryRequest _req = new DeleteInventoryRequest();
_req.InventoryItemId = hdnitmID.Value.ToString();
ws.DeleteInventory(_req);
ModalPopupDelete.Hide();
BindGridTelerik();
MyMasterPage.ShowErrorMessage("Record Deleted Successfully..!");
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Deleted Successfully..!');", true);
//HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "DELETE");
//Server.Transfer("CompleteForm.aspx");
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void txtnric_TextChanged(object sender, EventArgs e)
{
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
if (txtnric.Text.Trim() != "")
{
SqlParameter[] para2 = new SqlParameter[1];
para2[0] = new SqlParameter("@NRICno", txtnric.Text.Trim());
DataTable dsuserinfo = dal.executeprocedure("sp_FillNameByStaffId", para2, true);
if (dsuserinfo.Rows.Count > 0)
{
txtname.Text = dsuserinfo.Rows[0]["FirstName"].ToString();
txtname.Text += " ";
txtname.Text += dsuserinfo.Rows[0]["MiddleName"].ToString();
txtname.Text += " ";
txtname.Text += dsuserinfo.Rows[0]["LastName"].ToString();
txtposition.Text = dsuserinfo.Rows[0]["Role"].ToString();
//txtstffid.Text = dsuserinfo.Rows[0]["Staff_ID"].ToString();
}
else
{
txtnric.Text = "";
MyMasterPage.ShowErrorMessage("Invalid NRICno....!");
//lblerror.Visible = true;
//lblerror.Text = "Invalid NRICno....!";
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Invalid NRICno....!');", true);
}
}
}
catch (Exception ex)
{
}
}
String addimage()
{
SpaMaster SM = (SpaMaster)Page.Master;
Boolean ok = false;
String imageloc = string.Empty;
string ext = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
string[] ar = { ".jpg", ".gif", ".jpeg", ".png" };
for (int i = 0; i < ar.Length; i++)
{
if (ext == ar[i])
{
ok = true;
break;
}
}
if (ok)
{
string path = Server.MapPath("~/ImageUpload/");
FileUpload1.PostedFile.SaveAs(path + FileUpload1.FileName);
imageloc = Convert.ToString(path + FileUpload1.FileName);
return(imageloc);
}
else
{
}
return("");
}
private int Itemqty(string type, string name, int Newqty)
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
int ItemID = 0;
int Oldqty = 0;
int bothqty = 0;
int nwqty = Newqty;
DataSet dsItemdqty = Dal.getdataset("Select Item_id,Item_qty from AddNewInvetory where Item_Type='" + type + "' and Item_Name ='" + name + "' ");
if (dsItemdqty.Tables[0].Rows.Count > 0)
{
ItemID = Convert.ToInt32(dsItemdqty.Tables[0].Rows[0][0].ToString().Trim());
Oldqty = Convert.ToInt32(dsItemdqty.Tables[0].Rows[0][1].ToString().Trim());
bothqty = Oldqty + nwqty;
Dal.executesql("Update AddNewInvetory Set Item_qty ='" + bothqty + "' where Item_id ='" + ItemID + "' ");
ClearAll();
MyMasterPage.ShowErrorMessage("Record Inserted SuccessFully");
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Inserted SuccessFully');", true);
BindGridTelerik();
//HttpContext.Current.Items.Add("COMPLETE", "INSERT");
//Server.Transfer("CompleteForm.aspx");
}
return(nwqty);
}
String tovisit()
{
SpaMaster SM = (SpaMaster)Page.Master;
String zipRegex = "^[a-z A-Z]+$";
if (txtServingAt1.Text != "")
{
if (Regex.IsMatch(txtServingAt1.Text, zipRegex))
{
return(txtServingAt1.Text);
}
else
{
//lblerror.Visible = true;
//lblerror.Text = "Please Fill Alphabets Values ..!";
//lblerr6.Visible = true;
SM.ShowErrorMessage("Please Fill Alphabets Values ..!");
throw new Exception();
}
}
else
{
//lblerror.Visible = true;
//lblerror.Text = "Please Fill To Visit Values ..!";
//lblerr6.Visible = true;
SM.ShowErrorMessage("Please Fill To Visit Values ..!");
throw new Exception();
}
return("");
}
protected void imgDelete_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{ SpaMaster MyMasterPage = (SpaMaster)Page.Master;
// SpaMaster MyMasterPage = (SpaMaster)Page.Master;
DataTable dtAddNewPass = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "90");
if (dtAddNewPass.Rows.Count > 0)
{
if (ViewState["KeyID"] != null)
{
ModalPopupDeleteimage.Show();
}
}
else
{
MyMasterPage.ShowErrorMessage("You Do not Have Permission..!");
} }
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SpaMaster SM = (SpaMaster)Page.Master;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
lblerror.Visible = false;
lblerr1.Visible = false;
txtNricID2.Focus();
gvContractorTable.Visible = false;
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
if (Session["LCID"] != null)
{
// objchickin.LocationID = int.Parse(Session["LCID"].ToString());
// Location = Session["LCID"].ToString();
}
else
{
SM.ShowErrorMessage("Please select Location first!!!");
//lblerror.Visible = true;
//lblerror.Text = "Please select Location first!!!";
}
}
protected void txtaddNumberofStaff_Changed(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
if (txtNricID2.Text.Trim() != "")
{
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@NRICno", SqlDbType.VarChar, 100);
para[0].Value = txtNricID2.Text.Trim();
para[1] = new SqlParameter("@Role", SqlDbType.VarChar, 100);
para[1].Value = txtrole.Text.Trim();
DataTable dt = dal.executeprocedure("SP_GetCheckInDetailByNRICrole", para, false);
if (dt.Rows.Count > 0)
{
txtNricID2.Text = dt.Rows[0]["NRICno"].ToString();
txtTeleNo2.Text = dt.Rows[0]["telephone"].ToString();
txtName2.Text = dt.Rows[0]["user_name"].ToString();
txtName2.Enabled = false;
txtKeyNo2.Text = dt.Rows[0]["key_no"].ToString();
txtPassNo2.Text = dt.Rows[0]["pass_no"].ToString();
image3.ImageUrl = dt.Rows[0]["ImagePath"].ToString();
txtAddress2.Text = dt.Rows[0]["user_address"].ToString();
txtCompanyFrom2.Text = dt.Rows[0]["company_from"].ToString();
txtRemarks2.Text = dt.Rows[0]["remarks"].ToString();
txtVehicleNo2.Text = dt.Rows[0]["Vehicle_No"].ToString();
txtpasstype.Text = dt.Rows[0]["pass_type"].ToString();
txtToVisit2.Text = dt.Rows[0]["to_visit"].ToString();
txtVisitorPurpose2.Text = dt.Rows[0]["purpose"].ToString();
txtItemDeclear2.Text = dt.Rows[0]["Item_Declear"].ToString();
txtcheckinTime.Text = dt.Rows[0]["Checkin_DateTime"].ToString();
Panel1.Visible = true;
}
else
{
MyMasterPage.ShowErrorMessage("NRIC/FIN No. Already Checked Out ..!");
// MyMasterPage.ShowErrorMessage("Invalid NRIC/FIN No. ..!");
//lblerror.Visible = true;
//lblerror.Text = "Invalid NRIC/FIN No. ..!";
clear();
//lblerr1.Visible = true;
}
}
else
{
MyMasterPage.ShowErrorMessage("Fill NRIC/FIN No. ..!");
//lblerror.Visible = true;
//lblerror.Text = "Invalid NRIC/FIN No. ..!";
//lblerr1.Visible = true;
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void imgUpdate_Click(object sender, EventArgs e)
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
DataTable dtAddNewPass = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "94");
if (dtAddNewPass.Rows.Count > 0)
{
if (ViewState["Passid"] != null)
{
string _BTId = ViewState["Passid"].ToString();
string state = string.Empty;
SqlDataReader rd = dal.getDataReader("select Pass_Status from Pass_Master where Pass_id ='" + _BTId + "'");//change by rakesh
if (rd.Read())
{
state = (rd.GetValue(0).ToString().Trim());
}
rd.Close();
rd.Dispose();
if (state == "Free")
{
ModalPopupUpdate.Show();
fillpasstype();
PopulatePageCntrls(_BTId);
//HttpContext.Current.Items.Add(ContextKeys.CTX_UPDATE_URL, Request.Url.ToString());
//HttpContext.Current.Items.Add(ContextKeys.CTX_BT_ID, _BTId);
//Server.Transfer("KeyDataUpdate.aspx");
}
else
{
MyMasterPage.ShowErrorMessage("Cannot be Edit It is Reserved ..!");
//lblerror.Visible = true;
//lblerror.Text = "Can't be Edit It's Reserved ..!";
}
}
}
else
{
MyMasterPage.ShowErrorMessage("You Do not Have Permission ..!");
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
String addkey()
{
SpaMaster SM = (SpaMaster)Page.Master;
Boolean bal = false;
String ZipRegex = "^[a-z A-Z 0-9]+$";
if (txtKeyNo3.Text.Trim() != "")
{
if (Regex.IsMatch(txtKeyNo3.Text, ZipRegex))
{
column = "Key_no";
table = "addnewKey";
where = "Where Key_no = '" + txtKeyNo3.Text + "' ";
bal = b.isexistBLL(column, table, where);
if (bal)
{
where1 = "where Key_no = '" + txtKeyNo3.Text + "' and Status='Free'";
bal = b.isexistBLL(column, table, where1);
if (bal)
{
return(txtKeyNo3.Text);
}
else
{
//lblerror.Visible = true;
//lblerror.Text = "Key No. is Occupied ..!";
//lblerr4.Visible = true;
SM.ShowErrorMessage("Key No. is Occupied ..!");
throw new Exception();
}
}
else
{
//lblerror.Visible = true;
//lblerror.Text = "Key No. Not Found ..!";
//lblerr4.Visible = true;
SM.ShowErrorMessage("Key No. Not Found ..!");
throw new Exception();
}
}
else
{
//lblerror.Visible = true;
//lblerror.Text = "Please Fill Only Numeric Values ..!";
//lblerr4.Visible = true;
SM.ShowErrorMessage("Please Fill Only Numeric Values ..!");
throw new Exception();
}
}
return("");
}
//protected void txtnric_TextChanged(object sender, EventArgs e)
//{
// try
// {
// SpaMaster MyMasterPage = (SpaMaster)Page.Master;
// if (txtnric.Text.Trim() != "")
// {
// SqlParameter[] para2 = new SqlParameter[1];
// para2[0] = new SqlParameter("@NRICno", txtnric.Text.Trim());
// DataTable dsuserinfo = dal.executeprocedure("sp_FillNameByStaffId", para2, true);
// if (dsuserinfo.Rows.Count > 0)
// {
// txtname.Text = dsuserinfo.Rows[0]["FirstName"].ToString();
// txtname.Text += " ";
// txtname.Text += dsuserinfo.Rows[0]["MiddleName"].ToString();
// txtname.Text += " ";
// txtname.Text += dsuserinfo.Rows[0]["LastName"].ToString();
// txtposition.Text = dsuserinfo.Rows[0]["Role"].ToString();
// //txtstffid.Text = dsuserinfo.Rows[0]["Staff_ID"].ToString();
// }
// else
// {
// txtnric.Text = "";
// MyMasterPage.ShowErrorMessage("Invalid NRICno....!");
// //lblerror.Visible = true;
// //lblerror.Text = "Invalid NRICno....!";
// // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Invalid NRICno....!');", true);
// }
// }
// }
// catch (Exception ex)
// {
// }
//}
protected void btnNewInventoryOut_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
if (ddlItemName.Text.Trim() != "" && ddlItemType.Text.Trim() != "" && txtquantity.Text.Trim() != "" && txtnric.Text.Trim() != "" && txtname.Text.Trim() != "")
{
string type = ddlItemType.SelectedItem.Text.ToString().Trim();
string name = ddlItemName.SelectedValue.ToString().Trim();
int currqty = 0;
int oldqty = 0;
currqty = Convert.ToInt32(txtquantity.Text.Trim());
int insertItemid = itemId(type, name);
DataSet dsoldqty = dal.getdataset("Select Item_qty from AddNewInvetory where Item_id = '" + insertItemid + "'");
if (dsoldqty.Tables[0].Rows.Count > 0)
{
int newqty = 0;
oldqty = Convert.ToInt32(dsoldqty.Tables[0].Rows[0]["Item_qty"].ToString().Trim());
dal.executesql("insert into NewInventory_Temp(item_Id,Item_Type,Item_Name,Item_QTY,Staff_ID,Status,Comment,Position,FromDate) values(" + insertItemid + ",'" + type + "','" + name + "','" + currqty + "','" + txtstffid.Text + "','New','" + txtComment.Text + "','" + txtposition.Text + "','" + DateTime.Now + "')");
if (oldqty > currqty)
{
newqty = oldqty - currqty;
dal.executesql("Update AddNewInvetory set Item_qty = " + newqty + " where Item_id = '" + insertItemid + "'");
//lblerror.Visible = true;
//lblerror.Text = "Inventory Out Successfully....!";
CearlAll();
MyMasterPage.ShowErrorMessage("Inventory Out Successfully....!");
BindGridTelerik();
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Inventory Out Successfully....!');", true);
}
}
}
else
{
MyMasterPage.ShowErrorMessage("Please Fill All Entries....!");
//lblerror.Visible = true;
//lblerror.Text = "Please Fill All Entries....!";
//ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Please Fill All Entries....!');", true);
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void txtID1_TextChanged(object sender, EventArgs e)
{
SpaMaster SM = (SpaMaster)Page.Master;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
String ZipRegex = "^[a-z A-Z 0-9]+$";
if (Regex.IsMatch(txtID1.Text.Trim(), ZipRegex))
{
DataTable dt = dal.getdata("Select Staff_ID,ImagePathName from UserInformation where NRICno='" + txtID1.Text + "' and Role = '" + txtrole.Text + "' and Staff_ID='" + Session["StaffID1"].ToString() + "'");
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@NRICno", SqlDbType.VarChar, 100);
para[0].Value = txtID1.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)
{
txtID1.Text = dt1.Rows[0]["NRICno"].ToString();
txtTeleNo1.Text = dt1.Rows[0]["telephone"].ToString();
txtName1.Text = dt1.Rows[0]["user_name"].ToString();
txtcheckinTime.Text = dt1.Rows[0]["Checkin_DateTime"].ToString();
Image3.ImageUrl = dt.Rows[0]["ImagePathName"].ToString();
gvContractorTable.Visible = true;
BindGridWithFilterContractor();
}
else
{
//lblerror.Visible = true;
//lblerror.Text = "Invalid NRIC/FIN No. ..!";
//lblerr1.Visible = true;
SM.ShowErrorMessage("Invalid NRIC/FIN No. ..!");
}
}
else
{
//lblerror.Visible = true;
//lblerror.Text = "Invalid NRIC/FIN No. ..!";
//lblerr1.Visible = true;
SM.ShowErrorMessage("Invalid NRIC/FIN No. ..!");
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "MenuShow", "ShowManualPortion();", true);
}
protected void imgout_Click(object sender, EventArgs e)
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
DataTable dtInventoryOut = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "130");
if (dtInventoryOut.Rows.Count > 0)
{
ModalPopupout.Show();
}
else
{
MyMasterPage.ShowErrorMessage("You Do Not Have Permission..!");
}
}
protected void imdAdd_Click(object sender, EventArgs e)
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
DataTable dtAddNewPass = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "89");
if (dtAddNewPass.Rows.Count > 0)
{
ModalPopupAdd.Show();
}
else
{
MyMasterPage.ShowErrorMessage("You Do not Have Permission..!");
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
SpaMaster MyMasterPage = (SpaMaster)Page.Master;
if (txtpassword.Text.Trim() != "" && txtrepassword.Text.Trim() != "")
{
if (txtpassword.Text.Trim() == txtrepassword.Text.Trim())
{
if (Session["ManagementRole"].ToString().ToLower() == "superuser")
{
string staffid = txtuserid.Text;
dal.executesql("Update UserInformation Set UserPassword='******' where UserId = '" + staffid + "'");
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Password Successfully Set...!');", true);
// lblerror.Text = "Password Successfully Set...!";
MyMasterPage.ShowErrorMessage("Password Successfully Set...!");
clear();
}
else
{
string staffid = Session["StaffID"].ToString();
dal.executesql("Update UserInformation Set UserPassword='******' where Staff_ID = '" + staffid + "'");
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Password Successfully Set...!');", true);
// lblerror.Text = "Password Successfully Set...!";
MyMasterPage.ShowErrorMessage("Password Successfully Set...!");
clear();
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Re-Confirm Password..!');", true);
//lblerror.Text = "Re-Confirm Password..!";
MyMasterPage.ShowErrorMessage("Re-Confirm Password..!");
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Please Fill All Entries .....!');", true);
// lblerror.Text = "Please Fill All Entries .....!";
MyMasterPage.ShowErrorMessage("Please Fill All Entries .....!");
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
