private bool GetBuyData(GridView view) { try { sBuyId = Convert.ToInt32(view.GetFocusedRowCellValue("BuyId")); using (var context = new RubberSoftEntities()) { var query = context.spt_GetBuy().Where(o => o.BuyId == sBuyId).ToList(); if (query.Count > 0) { foreach (spt_GetBuy_Result dt in query) { strBuyNumber = dt.BuyNumber; TxtBuyNumber.Text = dt.BuyNumber; DtBuyDate.DateTime = dt.BuyDate.Value; sCustomerId = dt.CustomerId.Value; TxtCustomerName.Text = dt.CustomerName; SpinSubTotal.Value = dt.SubTotal.Value; SpinDownValue.Value = dt.DownValue.Value; SpinNetTotal.Value = dt.NetTotal.Value; SpinSetOffValue.Value = dt.SetOffValue.Value; SpinValueBalance.Value = dt.ValueBalance.Value; sActive = dt.Active.Value; sProductTypeId = dt.ProductTypeId.Value; } GetCustomer(sCustomerId); GetBuyProduct(sBuyId); LoadProductType(sProductTypeId); GetValueBalance(sCustomerId); if (sActive == false) { BtnEditBuy.Enabled = false; //if (ClassProperty.IsOpenBuy == false) //{ // BtnRefBuy.Visible = true; //} } else { BtnEditBuy.Enabled = true; //BtnRefBuy.Visible = false; } } else { ClearData(); } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetData(int id) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetUsers().Where(o => o.UserId == id).ToList(); if (query.Count > 0) { foreach (spt_GetUsers_Result dt in query) { userName = dt.UserName; strUserName = dt.UserName; roleId = dt.UserTypeId.Value; TxtUserName.Text = dt.UserName; TxtPassword.Text = SQLData.DecryptString(dt.Password); TxtFirstName.Text = dt.FirstName; TxtLastName.Text = dt.LastName; SLRole.EditValue = roleId; } } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
public bool GetTerminal(int id) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetTerminal().Where(o => o.TerminalId == id).ToList(); if (query.Count > 0) { foreach (spt_GetTerminal_Result dt in query) { ClassProperty.StrTerminalId = dt.TerminalId; ClassProperty.MachineName = dt.TerminalName; ClassProperty.EnableTerminal = dt.Active.Value; } } else { ClassProperty.StrTerminalId = 0; ClassProperty.MachineName = ""; ClassProperty.EnableTerminal = false; } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetGridData(string tex) { try { using (var context = new RubberSoftEntities()) { if (tex.Trim() == "" || tex.Length <= 0) { var query = context.spt_GetUsers().Where(o => o.Active == true).ToList(); GridUsers.DataSource = query; } else { var query = context.spt_GetUsers().Where(o => o.Active == true && o.UserName == tex || o.FirstName == tex || o.LastName == tex).ToList(); GridUsers.DataSource = query; } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool CheckData(int id) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetUsers().Where(o => o.UserId == id).ToList(); if (query.Count > 0) { foreach (spt_GetUsers_Result dt in query) { userId = dt.UserId; } return(true); } else { return(false); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetUserData(int UserId) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetUsers().Where(o => o.UserId == UserId).ToList(); if (query.Count > 0) { foreach (spt_GetUsers_Result dt in query) { ClassProperty.permisUserNm = dt.UserName; ClassProperty.permisRole = dt.RoleName; ClassProperty.permisRoleId = dt.UserTypeId.Value; lblUserName.Text = "ยินดีต้อนรับ : " + ClassProperty.permisUserNm; } } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetSale() { try { string text = TxtSearch.Text.Trim(); using (var context = new RubberSoftEntities()) { SetTime(); if (text == "") { var query = context.spt_GetSale().Where(o => o.SaleDate >= StartDate && o.SaleDate <= EndDate).ToList(); GridSale.DataSource = query; } else { var query = context.spt_GetSale().Where(o => o.SaleDate >= StartDate && o.SaleDate <= EndDate && (o.SaleNumber.Contains(text) || o.CustomerName.Contains(text))).ToList(); GridSale.DataSource = query; } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetData(int sRoleId) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetRoles().Where(o => o.RoleId == sRoleId).ToList(); if (query.Count > 0) { foreach (spt_GetRoles_Result dt in query) { strRoleName = dt.RoleName; TxtRoleName.Text = dt.RoleName; strRoleFullName = dt.RoleFullName; TxtRoleFullName.Text = dt.RoleFullName; } GetAuthorized(sRoleId); } else { ClearValues(); } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetCustomer(int id) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetCustomer().Where(o => o.CustomerId == id).ToList(); if (query.Count > 0) { foreach (spt_GetCustomer_Result dt in query) { TxtLicensePlate.Text = dt.LicensePlate; TxtPhone.Text = dt.Phone; TxtAddress.Text = dt.CustomerAddress; } } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
public bool CheckTerminal(string name) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetTerminal().Where(o => o.MachineName == name).ToList(); if (query.Count > 0) { foreach (spt_GetTerminal_Result dt in query) { ClassProperty.StrTerminalId = dt.TerminalId; } return(true); } else { return(false); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetSaleData(GridView view) { try { sSaleId = Convert.ToInt32(view.GetFocusedRowCellValue("SaleId")); using (var context = new RubberSoftEntities()) { var query = context.spt_GetSale().Where(o => o.SaleId == sSaleId).ToList(); if (query.Count > 0) { foreach (spt_GetSale_Result dt in query) { strSaleNumber = dt.SaleNumber; TxtSaleNumber.Text = dt.SaleNumber; DtSaleDate.DateTime = dt.SaleDate.Value; sCustomerId = dt.CustomerId.Value; TxtCustomerName.Text = dt.CustomerName; SpinSubTotal.Value = dt.SubTotal.Value; SpinDownValue.Value = dt.DownValue.Value; SpinNetTotal.Value = dt.NetTotal.Value; SpinSetOffValue.Value = dt.SetOffValue.Value; SpinValueBalance.Value = dt.ValueBalance.Value; sActive = dt.Active.Value; sProductTypeId = dt.ProductTypeId.Value; } GetCustomer(sCustomerId); GetSaleProduct(sSaleId); LoadProductType(sProductTypeId); GetValueBalance(sCustomerId); if (sActive == false) { BtnCancelSale.Enabled = false; } else { BtnCancelSale.Enabled = true; } } else { ClearData(); } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetData(int id) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetCustomer().Where(o => o.CustomerId == id).ToList(); if (query.Count > 0) { foreach (spt_GetCustomer_Result dt in query) { TxtCustomerCode.Text = dt.CustomerCode; stCustomerCode = dt.CustomerCode; TxtCustomerName.Text = dt.CustomerName; stCustomerName = dt.CustomerName; TxtLicensePlate.Text = dt.LicensePlate; TxtPhone.Text = dt.Phone; TxtCustomerAddress.Text = dt.CustomerAddress; stCustomerTypeId = dt.CustomerTypeId.Value; _IsDefault = dt.IsDefault; if (_IsDefault == true) { LkCustomerTypes.EditValue = 0; LkCustomerGroup.EditValue = 0; SetDefaultCustomer(true); } else { LkCustomerTypes.EditValue = dt.CustomerTypeId; LkCustomerGroup.EditValue = dt.CustomerGroupId; SetDefaultCustomer(false); } SpinNetTotal.ReadOnly = true; BtnAdjust.Enabled = true; LoadCustomerPrices(id); GetValueBalance(id); } } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool AddOutStandingLog(decimal BeginOutstandingDebt, decimal OutstandingDebt, int RefId, int Status, int LogTypeId) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_AddOutStandingLog(sCustomerId, BeginOutstandingDebt, OutstandingDebt, RefId, Status, LogTypeId); return(true); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool UpdateOutStandingBalance(decimal BeginDebt, decimal OutstandingDebt, int LastLogId) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_UpdateOutStandingBalance(sCustomerId, BeginDebt, OutstandingDebt, LastLogId); return(true); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool DeleteData(int cid) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_DeleteCustomer(cid, ClassProperty.permisUserID); return(true); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
public bool Addlog(int logtype, string logname, string logdetail, int userid, string ipmachhine, string machinename) { try { using (var context = new RubberSoftEntities()) { context.spt_AddLog(logtype, logname, logdetail, userid, ipmachhine, machinename); } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
public bool AddTerminal() { try { using (var context = new RubberSoftEntities()) { context.spt_AddTerminal(ClassProperty.GetCurrentName, ClassProperty.IPMachine, ClassProperty.MachineName, false); } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool UpdateData(bool active) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_UpdateUsers(userId, roleId, userName, passWord, firstName, lastName, active); return(true); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool UpdateData() { try { using (var context = new RubberSoftEntities()) { var query = context.spt_UpdateCustomer(sCustomerId, stCustomerTypeId, CustomerGroupId, sCustomerCode, sCustomerName, TxtCustomerAddress.Text, TxtLicensePlate.Text, TxtPhone.Text, false, ClassProperty.permisUserID); return(true); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool AddWeightBalance(int PriceId, decimal BeginBalanceAmt, decimal WeightBalanceAmt, int LastLogId) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_AddWeightBalance(sCustomerId, PriceId, BeginBalanceAmt, WeightBalanceAmt, LastLogId); return(true); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
public bool UpdateCustomerPrice(int CustomerId, int sPriceId, string PriceName, DateTime sSaleDate, decimal sSalePriceAdvance, double sWeightAmount, decimal sDeliveryPrice, bool IsDefault) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_UpdateCustomerPrice(sPriceId, PriceName, CustomerId, sSaleDate, sSalePriceAdvance, sWeightAmount, sDeliveryPrice, IsDefault); return(true); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool AddTransactionLog(int PriceId, decimal BeginAmt, decimal WeightAmount_Raw, decimal WeightBalanceAmt, int RefId, int LogTypeId) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_AddTransactionLog(sCustomerId, PriceId, BeginAmt, WeightAmount_Raw, WeightBalanceAmt, RefId, LogTypeId); return(true); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool GetRoles() { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetRoles().Where(o => o.Active == 1).ToList(); SLRole.Properties.DataSource = query; SLRole.Properties.DisplayMember = "RoleFullName"; SLRole.Properties.ValueMember = "RoleId"; } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool CheckDuplicate(int id) { try { using (var context = new RubberSoftEntities()) { if (CheckData(id) == true) { //if (sCustomerName != stCustomerName) //{ // var query = context.spt_GetCustomer().Where(o => o.CustomerName == sCustomerName).ToList(); // if (query.Count > 0) // { // XtraMessageBox.Show("ชื่อนี้มีในระบบแล้ว !", "คำเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return true; // } //} } else { //if (sCustomerName != "") //{ // var query = context.spt_GetCustomer().Where(o => o.CustomerName == sCustomerName).ToList(); // if (query.Count > 0) // { // XtraMessageBox.Show("ชื่อนี้มีในระบบแล้ว !", "คำเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return true; // } //} } return(false); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
public bool CheckRubberSoftConnection() { try { using (RubberSoftEntities db = new RubberSoftEntities()) { bool check = db.Database.Exists(); if (check == false) { db.Database.Connection.Close(); return(false); } } return(true); } catch (SqlException __SqlException) { XtraMessageBox.Show(__SqlException.Message); return(false); } }
private bool CheckData(int SaleId) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetSale().Where(o => o.SaleId == SaleId).ToList(); if (query.Count > 0) { return(true); } else { return(false); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool CheckDataOutStandingBalance(int id) { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetOutStandingBalance().Where(o => o.CustomerId == id).ToList(); if (query.Count > 0) { return(true); } else { return(false); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool CheckDuplicate() { try { using (var context = new RubberSoftEntities()) { var query = context.spt_GetUsers().Where(o => o.UserName == userName && o.Active == true).ToList(); if (query.Count > 0) { return(true); } else { return(false); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool CheckDuplicate(int Type) { try { using (var context = new RubberSoftEntities()) { if (Type == 1) { var ckRoleName = context.spt_GetRoles().Where(o => o.RoleName == stRoleName && o.Active == 1).ToList(); if (ckRoleName.Count > 0) { return(false); } } if (Type == 2) { var ckRoleFullName = context.spt_GetRoles().Where(o => o.RoleFullName == stRoleFullName && o.Active == 1).ToList(); if (ckRoleFullName.Count > 0) { return(false); } } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }
private bool Login() { try { if (SQLData.CheckRubberSoftConnection() == false || SQLData.CheckConnection() == false) { XtraMessageBox.Show("ไม่สามารถเชื่อมต่อระบบได้", "คำเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } if (TxtUserName.Text.Trim() == "" || TxtPassword.Text == "") { Alert(); return(false); } if (TxtUserName.Text.Trim() == SQLData.ID && TxtPassword.Text.Trim() == SQLData.DecryptString(SQLData.KEY)) { ClassProperty.permisUserID = -1; ClassProperty.permisUserNm = SQLData.ID; ClassProperty.permisRole = "IT"; ClassProperty.permisRoleId = -1; ClassProperty.permisUserPass = TxtPassword.Text.Trim(); CheckLogin(); } else { if (ClassProperty.EnableTerminal == false) { XtraMessageBox.Show("เครื่องใช้งานไม่มีสิทธิ์เข้าใช้งานระบบ", "คำเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } using (var context = new RubberSoftEntities()) { var query = context.spt_GetUsers().Where(o => o.UserName == TxtUserName.Text && SQLData.DecryptString(o.Password) == TxtPassword.Text.Trim()).ToList(); if (query.Count > 0) { foreach (spt_GetUsers_Result dt in query) { ClassProperty.permisUserID = dt.UserId; ClassProperty.permisUserNm = dt.UserName; ClassProperty.permisRole = dt.RoleName; ClassProperty.permisRoleId = dt.UserTypeId.Value; ClassProperty.permisUserPass = TxtPassword.Text.Trim(); // 1-001 1 : สิทธิ์ใช้งานหน้าเข้าสู่ระบบ เข้าสู่ระบบ int AuthorizeId = 1; if (SQLAuthorized.CheckAuthorized(ClassProperty.permisRoleId, AuthorizeId) == false) { SQLAuthorized.AlertAuthorized("สิทธิ์ใช้งานหน้าเข้าสู่ระบบ", "ไม่มีสิทธิ์การใช้งานระบบ"); return(false); } CheckLogin(); } } else { //XtraMessageBox.Show("ข้อมูลผู้ใช้งานมีปัญหา กรุณาติดต่อ IT !", "คำเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); Alert(); return(false); } } } return(true); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); return(false); } }