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