private void InsUpdDelStockIn(char Event, int id) { var msg = ""; if (Event == 'I' || Event == 'U') { // var session=new BK_Session(int userId,) var objOrder = new OrderedItemClass(id, Convert.ToDateTime(txtDate.Text), txtDocumentNo.Text, " ", txtStockNo.Text, Convert.ToInt32((string)ddlGender.SelectedValue), Convert.ToInt32((string)ddlCategory.SelectedValue), " ", Convert.ToInt32((string)ddlStyle.SelectedValue), Convert.ToInt32((string)ddlColor.SelectedValue), Convert.ToInt32((string)ddlSize.SelectedValue), Convert.ToInt32(txtQty.Text), float.Parse(txtRate.Text), 0, float.Parse(txtMrp.Text)); var objImport = new ProductStockIn(BK_Session.GetSession().BranchId, BK_Session.GetSession().UserId, Convert.ToDateTime("1/1/1900"), " ", txtInvoiceNo.Text, txtAirwayBillNo.Text, Convert.ToInt32((string)ddlSeason.SelectedValue), Convert.ToDateTime("1/1/1900"), 0); msg = BL_Stock_In.InsUpdDelStockIn(Event, objOrder, objImport, out id); } else { var objOrder = new OrderedItemClass(id, Convert.ToDateTime("1/1/1900"), " ", " ", " ", 0, 0, " ", 0, 0, 0, 0, 0, 0, 0); var objImport = new ProductStockIn(0, 0, Convert.ToDateTime("1/1/1900"), " ", " ", " ", 0, Convert.ToDateTime("1/1/1900"), 0); msg = BL_Stock_In.InsUpdDelStockIn(Event, objOrder, objImport, out id); } if (msg == "Data Imported Successfully") { _msgbox.ShowSuccess(msg); } else { _msgbox.ShowWarning(msg); } }
public void InsertDayCloseLog() { var md5Hasher = new MD5CryptoServiceProvider(); byte[] hashedBytes = null; var encoder = new UTF8Encoding(); hashedBytes = md5Hasher.ComputeHash(encoder.GetBytes(BK_Session.GetSession().OpDate.ToLongDateString())); var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CSCommonDB"].ToString()); try { conn.Open(); var cmd1 = new SqlCommand("InsertDayCloseLog", conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@CreatedBy", int.Parse(BK_Session.GetSession().UserId.ToString())); cmd1.Parameters.AddWithValue("@Hvalue", hashedBytes); cmd1.Parameters.AddWithValue("@flag", 1); cmd1.Parameters.AddWithValue("@Branch_Id", BK_Session.GetSession().BranchId); cmd1.Parameters.AddWithValue("@Date", BK_Session.GetSession().OpDate); cmd1.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { throw ex; } }
protected void Page_Init(object sender, EventArgs e) { if (BK_Session.GetSession() == null) { Response.Redirect("~/Login.aspx"); } }
private void InsUpdDelStaffInfo(char Event, int id) { var msg = ""; if (Event == 'I' || Event == 'U') { // var session=new BK_Session(int userId,) var objStaff = new Staff(id, Convert.ToInt32(BK_Session.GetSession().UserId), Convert.ToInt32((string)ddl_branch.SelectedValue), txtStaffName.Text, Convert.ToInt32((string)ddlDesignation.SelectedValue), txtAddress.Text, txtContactNo.Text, txtEmail.Text, Convert.ToInt32((string)ddlQualification.SelectedValue), txtRemarks.Text, true, Convert.ToDateTime(BK_Session.GetSession().OpDate), Convert.ToInt32((string)ddlGender.SelectedValue), Convert.ToDateTime(txtJobStartDate.Text), Convert.ToInt32((string)ddlTitle.SelectedValue), Convert.ToDateTime("01/01/1991"), Convert.ToDateTime("01/01/1991"), Convert.ToDateTime(txtDOB.Text), txtCitizenNo.Text, txtPpNo.Text, Convert.ToInt32((string)ddlDepartment.SelectedValue), Convert.ToInt32((string)ddlmaritalstatus.SelectedValue), Convert.ToInt32((string)ddlServiceType.SelectedValue), Convert.ToInt32((string)ddlEthnicGroups.SelectedValue)); msg = BL_Staff.InsUpdDelStaffInfo(Event, objStaff, out id); } else if (Event == 'N') { var objStaff = new Staff(id, 0, 0, "", 0, "", "", "", 0, "", false, Convert.ToDateTime("01/01/1991"), 0, Convert.ToDateTime("01/01/1991"), 0, Convert.ToDateTime("01/01/1991"), Convert.ToDateTime("01/01/1991"), Convert.ToDateTime("01/01/1991"), "", "", 0, 0, 0, 0); msg = BL_Staff.UpdStaffToInactive(Event, objStaff, out id); } else { var objStaff = new Staff(id, 0, 0, "", 0, "", "", "", 0, "", false, Convert.ToDateTime("01/01/1991"), 0, Convert.ToDateTime("01/01/1991"), 0, Convert.ToDateTime("01/01/1991"), Convert.ToDateTime("01/01/1991"), Convert.ToDateTime("01/01/1991"), "", "", 0, 0, 0, 0); msg = BL_Staff.InsUpdDelStaffInfo(Event, objStaff, out id); } if (DatabaseMessage.ContainMessage(msg)) { _msgbox.ShowSuccess(msg); } else { _msgbox.ShowWarning(msg); } FillGridview(); ClearAll(); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtUserName.Text != "" && txtPwd.Text != "") { var pwd = EncryptDecrypt.base64Encode(txtPwd.Text); var dt = new DataTable(); dt = BL_Users.GetUsers(2, 0, txtUserName.Text); if (dt.Rows.Count > 0) { var a = EncryptDecrypt.base64Decode(dt.Rows[0]["PWD"].ToString()); if (pwd == dt.Rows[0]["PWD"].ToString()) { var userID = Convert.ToInt32(dt.Rows[0]["ID"].ToString()); var roleId = Convert.ToInt32(dt.Rows[0]["ROLE_ID"].ToString()); var obj = new BK_Session(Convert.ToInt32(userID), roleId, this.PrepareMenu(roleId)); obj.UserName = dt.Rows[0]["USER_NAME"].ToString(); obj.RoleName = dt.Rows[0]["ROLE_NAME"].ToString(); obj.BranchId = Convert.ToInt32(dt.Rows[0]["BRANCH_ID"].ToString()); BK_Session.SetSession(obj); var opdate = DateTime.Parse(GetOperationDate(BK_Session.GetSession().BranchId)); InsertDayOpen(BK_Session.GetSession().BranchId, opdate, BK_Session.GetSession().UserId); obj.OpDate = opdate; obj.Name = dt.Rows[0]["NAME"].ToString(); BK_Session.SetSession(obj); Session["Username"] = dt.Rows[0]["USER_NAME"].ToString(); FormsAuthenticationTicket tkt; string cookiestr; tkt = new FormsAuthenticationTicket(1, txtUserName.Text, DateTime.Now, DateTime.Now.AddMinutes(30), false, "your custom data"); cookiestr = FormsAuthentication.Encrypt(tkt); // FormsAuthentication.RedirectFromLoginPage(txtUserName.Text, false); string strRedirect; strRedirect = Request["ReturnUrl"]; if (strRedirect == null) { strRedirect = "~/DashBoard.aspx"; } Response.Redirect(strRedirect, true); } else { //lblError.Text = "Invalid Password For the Given User..!!"; txtPwd.Text = ""; txtPwd.Focus(); } } else { //lblError.Text = "Invalid User Name..!!"; txtUserName.Text = ""; txtPwd.Text = ""; txtUserName.Focus(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillddlSeason(); FillddlBranch(); ddlBranch.SelectedValue = BK_Session.GetSession().BranchId.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillddlSeason(); FillddlBranch(); ddlBranch.SelectedValue = BK_Session.GetSession().BranchId.ToString(); txtDate.Text = ConvertNE.ConvertEToN(BK_Session.GetSession().OpDate); } }
private string FillMenu() { var menu = BK_Session.GetSession().MenuList; if (menu != null) { return(menu); } var dt = BL_MenuAssign.GetMenuAssign(3, Convert.ToInt32(BK_Session.GetSession().RoleId), 0, ""); var mainMenus = BK_Session.GetSession().Menus; var count = mainMenus.Count; var strMenu = new StringBuilder(); if (count > 0) { strMenu.Append("<ul class=\"nav nav-pills nav-stacked\">"); foreach (var item in mainMenus.Keys) { var mm = mainMenus[item]; strMenu.Append("<li class=\"parent\">"); switch (mm.MenuName) { case "Import From Excel": strMenu.Append("<a href=" + "#" + "><i class=\"fa fa-home\" ></i><span>" + mm.MenuName + "</span></a>"); break; case "Reports": strMenu.Append("<a href=" + "#" + "><i class=\"fa fa-file-text\" ></i><span>" + mm.MenuName + "</span></a>"); break; case "Settings": strMenu.Append("<a href=" + "#" + "><i class=\"fa fa-gears\" ></i><span>" + mm.MenuName + "</span></a>"); break; case "correction": strMenu.Append("<a href=" + "#" + "><i class=\"fa fa-suitcase\" ></i><span>" + mm.MenuName + "</span></a>"); break; default: strMenu.Append("<a href=" + "#" + "><i class=\"fa fa-suitcase\" ></i><span>" + mm.MenuName + "</span></a>"); break; } strMenu.Append(GetChildMenu(mm)); strMenu.Append("</li>"); } strMenu.Append("</ul>"); } BK_Session.GetSession().MenuList = strMenu.ToString(); return(strMenu.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { branchId = BK_Session.GetSession().BranchId; txt_OpeningDate.Text = Convert.ToString(DateTime.Now.ToShortDateString()); txtAmount.Text = "0"; FillGrid(); FillDdlBranch(); BindIntCalMethod(); BindAccumulationMethod(); ddlBranch_SelectedIndexChanged(sender, e); //ddlaccounttype_SelectedIndexChanged(sender, e); } }
private void FillgvUsers() { var dt = new DataTable(); dt = BL_Users.GetUsers(1, Convert.ToInt32(BK_Session.GetSession().BranchId), ""); if (dt.Rows.Count > 0) { gvUsers.DataSource = dt; gvUsers.DataBind(); } else { gvUsers.DataSource = new string[] { }; gvUsers.DataBind(); } }
public void Clear() { txtAmount.Text = "0"; txtMaturityDate.Text = ""; txtRate.Text = "0"; txt_AccountNo.Text = ""; txt_BankName.Text = ""; txt_OpeningDate.Text = DateTime.Now.ToShortDateString(); txtavailablebalance.Text = "0"; txtinterestaccumulation.Text = ""; ddlBranch.SelectedValue = Convert.ToString(BK_Session.GetSession().BranchId.ToString()); ddl_acc.SelectedValue = "0"; ddl_calMethod.SelectedValue = "0"; ddl_class.SelectedValue = "0"; ddlaccounttype.SelectedValue = "0"; // ddlmodeofpayment.SelectedValue = "1"; }
private void DeleteOrderedList(string orderedId) { var obj = new ImportExcel(); obj.ExcelData = ""; obj.CreatedBy = BK_Session.GetSession().UserId; obj.BranchId = BK_Session.GetSession().BranchId; obj.OrderedDate = BK_Session.GetSession().OpDate; obj.OrderId = int.Parse(orderedId); int id = 0; var msg = BL_OrderedExcel.InsUpdDelExcelOrder('D', obj, out id); if (msg == "Record Deleted Successfully") { FillGridView(); _msgbox.ShowSuccess(msg); } else { _msgbox.ShowWarning(msg); } }
private void DeleteImportList(string invoiceNo) { var obj = new ImportExcel(); obj.ExcelData = ""; obj.CreatedBy = BK_Session.GetSession().UserId; obj.BranchId = BK_Session.GetSession().BranchId; obj.ImportedDate = BK_Session.GetSession().OpDate; obj.InvoiceNo = invoiceNo; int id = 0; var msg = BllImportExcel.InsUpdDelExcelImport('D', obj, out id); if (msg == "Record Deleted Successfully") { FillGridView(); _msgbox.ShowSuccess(msg); } else { _msgbox.ShowWarning(msg); } }
/** * Calculates wheather english year is leap year or not * * @param integer $year * @return boolean */ public static string GetDefaultYearMonthDays(string yearMonthDays) { string nepdate = ConvertNE.ConvertEToNWithSlash(BK_Session.GetSession().OpDate); string[] nepdatearray = nepdate.Split('/'); string year = nepdatearray[0].ToString(); string month = nepdatearray[1].ToString(); string days = nepdatearray[2].ToString(); if (yearMonthDays.ToLower() == "year") { if (Convert.ToInt16(month) >= 4) { } else { year = (Convert.ToInt16(year) - 1).ToString(); } return(year); } else if (yearMonthDays.ToLower() == "month") { return(month); } else if (yearMonthDays.ToLower() == "days") { return(days); } else if (yearMonthDays.ToLower() == "nepDate") { return(nepdate); } else { return(nepdate); } }
private void FillGridview() { gvMemberInfo.DataSource = BL_Staff.GetStaffDetail(1, BK_Session.GetSession().BranchId, "", ""); gvMemberInfo.DataBind(); }
private void FillddlStaffName() { ddlStaffName = BL_FillDropDown.FillddlStaffName(ddlStaffName, 1, BK_Session.GetSession().BranchId, ""); }
private void CheckMenuRights() { var sPath = System.Web.HttpContext.Current.Request.Url.AbsolutePath; var oInfo = new System.IO.FileInfo(sPath); if (oInfo.Directory != null) { var sRet = @"/" + oInfo.Directory.Name + @"/" + oInfo.Name; //if (sRet.Contains("/script.aspx") || sRet.Contains("/Branch.aspx")) //{ // if (BK_Session.GetSession().RoleId == 1) // { // lititle.Text = "Microfinance"; // } // else // { // Response.Redirect("~/MiddleaPart.aspx"); // } //} if (sRet.Contains("/DashBoard.aspx") ) { lblPageName.Text = "Dashboard"; //lblMainMenuName.Text = "Menu Setting"; lblChildMenuName.Text = "Dashboard"; } else if (sRet.Contains("/Menu/ChildMenuSetup.aspx")) { lblPageName.Text = "Child Menu Setup"; lblMainMenuName.Text = "Menu Setting"; lblChildMenuName.Text = "Child Menu Setup"; } else if (sRet.Contains("/Menu/MainMenuSetup.aspx")) { lblPageName.Text = "Main Menu Setup"; lblMainMenuName.Text = "Menu Setting"; lblChildMenuName.Text = "Main Menu Setup"; } else if (sRet.Contains("/Menu/MenuAssign.aspx")) { lblPageName.Text = "Menu Assign"; lblMainMenuName.Text = "Menu Setting"; lblChildMenuName.Text = "Menu Assign"; } else if (sRet.Contains("/Menu/AddNewUser.aspx")) { lblPageName.Text = "Add New User"; lblMainMenuName.Text = "User Settings"; lblChildMenuName.Text = "Add New User"; } else { string bredcum = BK_Session.GetSession().GetBredCum("~" + sRet); string[] pageArray = bredcum.Split('/'); Array.Reverse(pageArray); lblPageName.Text = pageArray[0].ToString(); lblMainMenuName.Text = pageArray[1].ToString(); lblChildMenuName.Text = pageArray[0].ToString(); } } // //lititle.Text = lblPageName.Text.Replace("<i>", "").Replace("</i>", ""); // //if (lblPageName.Text == "") // //{ // // // Response.Redirect("~/MiddleaPart.aspx"); // //} //} }
protected void btnSubmit_Click(object sender, EventArgs e) { var dtExcel = new DataTable("OrderedExcel"); dtExcel.Columns.Add("Store_x0020_No"); var httpPostedFile = ordImage.PostedFile; if (httpPostedFile != null && httpPostedFile.ContentLength > 0) { var postedFile = ordImage.PostedFile; if (postedFile != null) { var fileExtension = System.IO.Path.GetExtension(postedFile.FileName); if (fileExtension == ".xls" || fileExtension == ".xlsx") { var fileLocation = Server.MapPath("~/Content/") + postedFile.FileName; if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } postedFile.SaveAs(fileLocation); var excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=0\""; //connection String for xls file format. if (fileExtension == ".xls") { excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=0\""; } //connection String for xlsx file format. else if (fileExtension == ".xlsx") { excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\""; } //Create Connection to Excel work book and add oledb namespace var excelConnection = new OleDbConnection(excelConnectionString); excelConnection.Open(); var dt = new DataTable(); // var format=excelConnection.GetOleDbSchemaTable() dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); if (dt == null) { return; } var excelSheets = new String[dt.Rows.Count]; var t = 0; //excel data saves in temp file here. foreach (DataRow row in dt.Rows) { excelSheets[t] = row["TABLE_NAME"].ToString(); t++; } var excelConnection1 = new OleDbConnection(excelConnectionString); //excelSheets[0] var query = string.Format("Select * from [{0}]", excelSheets[0]); // excelSheets.Range["D5"].Text = sheet.Range["C5"].Formula; //string.Format("Select [Date],DocNo,Customer Name as CustomerName,Stock No as StockNo,Gender,Category,Item Descr as ItemDescr,Style,Color,Size,Qty,Item Rate as ItemRate,MRP INR as MRPINR,MRP NPR as MRPNPR from [{0}]", excelSheets[0]); using (var dataAdapter = new OleDbDataAdapter(query, excelConnection1)) { dataAdapter.Fill(dtExcel); } } } if (dtExcel.Rows.Count > 0) { var sw = new StringWriter(); dtExcel.WriteXml(sw); var obj = new ImportExcel(); obj.ExcelData = sw.ToString(); obj.CreatedBy = BK_Session.GetSession().UserId; obj.BranchId = BK_Session.GetSession().BranchId; obj.OrderedDate = BK_Session.GetSession().OpDate; obj.Season = int.Parse(ddlSeason.SelectedValue); int id = 0; var msg = BL_OrderedExcel.InsUpdDelExcelOrder('I', obj, out id); if (msg == "Data Imported Successfully") { _msgbox.ShowSuccess(msg); } else { _msgbox.ShowWarning(msg); } } else { _msgbox.ShowWarning("Please browse excel sheet having data!!"); } } }
protected void clrSession_Click(object sender, EventArgs e) { SessionHelper.ClearSessionOfOtherUserInBranch(BK_Session.GetSession().BranchId, BK_Session.GetSession().UserId); btnSubmit.Enabled = true; }
private void InsUpdDelBankDetail(char Event, int id) { var msg = ""; if (Event == 'I' || Event == 'U') { msgSuccess.Text = ""; msgSuccess.Visible = false; int userid = Convert.ToInt16(BK_Session.GetSession().UserId.ToString()); var accounttype = ""; var cashbank = false; var bankid = 0; var maturitydate = new DateTime(); if (ddlaccounttype.SelectedValue == "1") { accounttype = "C"; txtRate.Text = "0"; txtAmount.Text = "0"; maturitydate = DateTime.Parse("01/01/1991"); } else if (ddlaccounttype.SelectedValue == "2") { accounttype = "S"; txtAmount.Text = "0"; maturitydate = DateTime.Parse("01/01/1991"); } else { txtAmount.Text = "0"; accounttype = "FD"; maturitydate = DateTime.Parse(txtMaturityDate.Text); } if (ddlmodeofpayment.SelectedItem.Text == "Bank") { cashbank = true; bankid = int.Parse(ddlSelectBank.SelectedValue); } var objBank = new Bank(id, txt_BankName.Text + "-" + txt_AccountNo.Text, txt_AccountNo.Text, float.Parse(txtAmount.Text), 0, Convert.ToDateTime(txt_OpeningDate.Text), BK_Session.GetSession().UserId, Convert.ToDateTime(txt_OpeningDate.Text), 0, Convert.ToDateTime(txt_OpeningDate.Text), accounttype, ddl_class.SelectedValue, int.Parse(ddlBranch.SelectedValue), decimal.Parse(txtRate.Text), int.Parse(ddl_calMethod.SelectedValue), int.Parse(ddl_acc.SelectedValue), maturitydate, cashbank, bankid, txtinterestaccumulation.Text); msg = BL_Bank_Desc.InsUpdDelBankDetail(Event, objBank, out id); branchId = BK_Session.GetSession().BranchId; FillGrid(); } else { } if (DatabaseMessage.ContainMessage(msg)) { msgbox.ShowSuccess(msg); } else { msgbox.ShowWarning(msg); } }
public DateTime GetClosedDate() { var dt = new DateTime(); var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CSCommonDB"].ToString()); conn.Open(); var cmd1 = new SqlCommand("Select top(1) Date from tbl_DayCloseLog where DayClose = 1 and branchId=" + BK_Session.GetSession().BranchId + " order by Date desc", conn); cmd1.CommandType = CommandType.Text; var adr = cmd1.ExecuteReader(); while (adr.Read()) { dt = DateTime.Parse(adr[0].ToString()); } conn.Close(); return(dt); }
private void InsupdDeleteusers(char Event, int Id) { var obj = new BL_Users(); if (Event == 'I') { if (txtPassword.Text == txtConfirmPassword.Text) { obj.EVENT = 'I'; // obj.NAME = txtFirstName.Text + " " + txtLastName.Text; obj.STAFF_ID = Convert.ToInt32((string)ddlStaffName.SelectedValue); obj.PWD = EncryptDecrypt.base64Encode(txtPassword.Text); obj.CONTACT_NO = txtContactNo.Text; obj.ADDRESS = txtAddress.Text; obj.EMAIL_ID = txtEmail.Text; obj.REGISTERED_BY = Convert.ToInt32(BK_Session.GetSession().UserId); obj.REGISTERED_DATE = System.DateTime.Now; obj.USER_NAME = txtUserName.Text + lblCompanyCode.Text; obj.USER_STATUS = true; obj.ROLE_ID = Convert.ToInt32((string)ddlRoles.SelectedValue); obj.BranchId = Convert.ToInt32(BK_Session.GetSession().BranchId); Id = 0; var msg = ""; msg = obj.InsUpdDeleteUsers(out Id); if (msg == "Record Inserted Successfully") { msgbox.ShowSuccess(msg); Clear(); } else { msgbox.ShowWarning(msg); } } } else if (Event == 'U') { obj.EVENT = Event; obj.ID = Id; obj.STAFF_ID = Convert.ToInt32((string)ddlStaffName.SelectedValue); obj.PWD = EncryptDecrypt.base64Encode(txtPassword.Text + lblCompanyCode.Text); obj.CONTACT_NO = txtContactNo.Text; obj.ADDRESS = txtAddress.Text; obj.EMAIL_ID = txtEmail.Text; obj.REGISTERED_BY = Convert.ToInt32(BK_Session.GetSession().UserId); obj.REGISTERED_DATE = BK_Session.GetSession().OpDate; obj.USER_NAME = txtUserName.Text; obj.USER_STATUS = true; obj.ROLE_ID = Convert.ToInt32((string)ddlRoles.SelectedValue); obj.BranchId = Convert.ToInt32(BK_Session.GetSession().BranchId); Id = 0; var msg = ""; msg = obj.InsUpdDeleteUsers(out Id); if (msg == "Record Updated Successfully") { msgbox.ShowSuccess(msg); Clear(); } else { msgbox.ShowWarning(msg); } } else if (Event == 'D') { obj.EVENT = Event; obj.ID = Id; obj.STAFF_ID = Convert.ToInt32((string)ddlStaffName.SelectedValue); obj.PWD = EncryptDecrypt.base64Encode(txtPassword.Text); obj.ADDRESS = txtAddress.Text; obj.CONTACT_NO = txtContactNo.Text; obj.EMAIL_ID = txtEmail.Text; obj.REGISTERED_BY = Convert.ToInt32(BK_Session.GetSession().UserId); obj.REGISTERED_DATE = BK_Session.GetSession().OpDate; obj.USER_NAME = txtUserName.Text; Id = 0; var msg = ""; msg = obj.InsUpdDeleteUsers(out Id); if (msg == "Record Deleted Successfully") { msgbox.ShowSuccess(msg); Clear(); } else { msgbox.ShowWarning(msg); } } else { obj.EVENT = Event; obj.ID = Id; obj.STAFF_ID = Convert.ToInt32((string)ddlStaffName.SelectedValue); var pwd = (txtPassword.Text).ToLower(); obj.PWD = EncryptDecrypt.base64Encode(pwd); obj.ADDRESS = txtAddress.Text; obj.CONTACT_NO = txtContactNo.Text; obj.EMAIL_ID = txtEmail.Text; obj.REGISTERED_BY = Convert.ToInt32(BK_Session.GetSession().UserId); obj.REGISTERED_DATE = BK_Session.GetSession().OpDate; obj.USER_NAME = txtUserName.Text; Id = 0; var msg = ""; msg = obj.InsUpdDeleteUsers(out Id); if (msg == "Password Changed Successfully") { msgbox.ShowSuccess(msg); Clear(); } else { msgbox.ShowWarning(msg); } } FillgvUsers(); }