protected void btnSaveUpdate_Click(object sender, EventArgs e) { BM.Update(); lblErrorMessageUpdate.Text = string.Empty; branch = BM.GetBranchByKey(long.Parse(gvBranchList.SelectedRow.Cells[2].Text)); BM.PreviousBranch = BM.GetBranchByKey(long.Parse(gvBranchList.SelectedRow.Cells[2].Text)); branch.AddressOne = txtAddressOneUpdate.Text; branch.AddressTwo = txtAddressTwoUpdate.Text; branch.BillingAddress = txtBillAddUpdate.Text; branch.BranchName = txtBranchNameUpdate.Text; branch.ContactPerson = txtContactPersonUpdate.Text; branch.FaxNumber = txtFaxNoUpdate.Text; branch.MobileNumber = txtMobileNoUpdate.Text; branch.PositionDescription = txtPositionUpdate.Text; branch.ShippingAddress = txtShipToAddUpdate.Text; branch.TelephoneNumber = txtTelNoUpdate.Text; branch.TIN = txtTinUpdate.Text; string sMessage = string.Empty; if (BM.ValidateData(branch, ref sMessage) == true) { BM.Save(branch); LoadAllBranch(); ClearTextCtrls(); EnableButtons(); } else { lblErrorMessageUpdate.Text = sMessage; btnUpdateBranch_ModalPopupExtender.Show(); } }
public bool Delete(BranchClass branch) { bool bResult = false; try { using (DbManager db = new DbManager()) { Accessor.Query.Delete(db, branch); bResult = true; } } catch(Exception except) { throw new System.ArgumentException(except.Message); } return bResult; }
protected void btnSaveBranch_Click(object sender, EventArgs e) { ListItem litem = new ListItem(); lblErrorMessage.Text = string.Empty; litem = dlAccounts.Items[dlAccounts.SelectedIndex]; var branch = new BranchClass { AccountCode = litem.Value, BranchCode = txtBranchCode.Text, BranchName = txtBranchName.Text, AddressOne = txtAddressOne.Text, AddressTwo = txtAddressTwo.Text, ContactPerson = txtContactPerson.Text, PositionDescription = txtPosition.Text, TelephoneNumber = txtTelNo.Text, MobileNumber = txtMobileNo.Text, FaxNumber = txtFaxNo.Text, BillingAddress = txtBillingAdd.Text, ShippingAddress = txtShipToBillAdd.Text, TIN = txtTIN.Text }; BM.Add(); string sMessage = string.Empty; if (BM.ValidateData(branch, ref sMessage) == true) { BM.Save(branch); LoadAllBranch(); ClearTextCtrls(); EnableButtons(); } else { lblErrorMessage.Text = sMessage; btnNewBranch_ModalPopupExtender.Show(); } }
public bool ValidateData(BranchClass branch, ref string Message) { bool bResult = false; if (string.IsNullOrEmpty(branch.AccountCode) == true) { Message = "Account name required!"; return bResult; } if (string.IsNullOrEmpty(branch.BranchName) == true) { Message = "Branch name required!"; return bResult; } int iResultCount = 0; bool bChange = true; if (OldBranch.AccountCode == branch.AccountCode || TransState == TransactionState.Add) { iResultCount = Accessor.BranchByBranchName(branch.AccountCode, branch.BranchName).Count; if (TransState == TransactionState.Update) { if (OldBranch.BranchName == branch.BranchName) bChange = false; } } if (iResultCount > 0 && bChange == true) { Message = "Branch name already been used!"; return bResult; } /* string[] paramKey = new string[2]; string[] paramColumn = new string[2]; paramKey[0] = branch.BranchName; paramKey[1] = branch.BranchCode; paramColumn[0] = "BRANCH_NAME"; paramColumn[1] = "BRANCH_CODE"; int iResultCount = 0; bool bChange = true; iResultCount = Accessor.Query.SelectByKeyWords<BranchClass>(paramKey,paramColumn).Count; if (TransState == TransactionState.Update) { if (OldBranch.BranchName == branch.BranchName) bChange = false; } if (iResultCount > 0 && bChange == true) { Message = "Branch name already been used!"; return bResult; } paramKey = new string[1]; paramColumn = new string[1]; paramKey[0] = branch.BranchCode; paramColumn[0] = "BRANCH_CODE"; iResultCount = 0; bChange = true; iResultCount = Accessor.Query.SelectByKeyWords<BranchClass>(paramKey, paramColumn).Count; if (TransState == TransactionState.Update) { if (OldBranch.BranchCode == branch.BranchCode) bChange = false; } if (iResultCount > 0 && bChange == true) { Message = "Branch code already been used!"; return bResult; }*/ bResult = true; return bResult; }
public bool Save(BranchClass branch) { bool bResult = false; branch.BranchCode = GenerateBranchCode(); using (DbManager db = new DbManager()) { try { if (branch.RecordNo != 0) { Accessor.Query.Update(db, branch); } else { Accessor.Query.Insert(db, branch); } bResult = true; } catch (Exception except) { throw new System.ArgumentException(except.Message); } } return bResult; }
private void GetObjectsFromDropList() { if (dlAccounts.SelectedIndex > 0) { AccountClass accountSelect = new AccountClass(); accountSelect = AM.GetAccountByAccountCode(dlAccounts.SelectedValue); account = accountSelect; //CIM.AccountObject = accountSelect; OM.AccountObject = accountSelect; } if (dlBranch.SelectedIndex > -1) { BranchClass branchSelect = new BranchClass(); branchSelect = BM.GetBranchByBranchCode(dlBranch.SelectedValue); branch = branchSelect; //CIM.BranchObject = branchSelect; OM.BranchObject = branchSelect; } if (dlBrand.SelectedIndex > 0) { Brand brandlocal = new Brand(); brandlocal = BrM.GetBrandByBrandCode(dlBrand.SelectedValue); brand = brandlocal; //CIM.BrandObject = brandlocal; OM.BrandObject = brandlocal; } }
protected void gvBranchList_SelectedIndexChanged(object sender, EventArgs e) { AccountsManager AM = new AccountsManager(); branch = BM.GetBranchByKey(long.Parse(gvBranchList.SelectedRow.Cells[2].Text)); txtAccountNameUpdate.Text = AM.GetAccountByAccountCode(branch.AccountCode).AccountName; txtAddressOneUpdate.Text = branch.AddressOne; txtAddressTwoUpdate.Text = branch.AddressTwo; txtBillAddUpdate.Text = branch.BillingAddress; txtBranchCodeUpdate.Text = branch.BranchCode; txtBranchNameUpdate.Text = branch.BranchName; txtContactPersonUpdate.Text = branch.ContactPerson; txtFaxNoUpdate.Text = branch.FaxNumber; txtMobileNoUpdate.Text = branch.MobileNumber; txtPositionUpdate.Text = branch.PositionDescription; txtShipToAddUpdate.Text = branch.ShippingAddress; txtTelNoUpdate.Text = branch.TelephoneNumber; txtTinUpdate.Text = branch.TIN; }