private void btnSave_Click(object sender, EventArgs e) { if (tbxGroupName.Text.Equals(string.Empty)) { MessageBox.Show("Cost Center Group can not be blank!"); return; } CostCentreGroupModel objModel = new CostCentreGroupModel(); objModel.GroupName = tbxGroupName.Text.Trim(); objModel.Alias = tbxAlias.Text.Trim() == null?string.Empty:tbxAlias.Text.Trim(); objModel.PrimaryGroup = cbxPrimarygroup.SelectedItem.ToString() == "Y" ? true : false; if (cbxPrimarygroup.SelectedItem.ToString() == "N") { objModel.underGroup = cbxUndergroup.SelectedItem.ToString(); } objModel.CreatedBy = "Admin"; bool isSuccess = objCG.SaveCCG(objModel); if (isSuccess) { MessageBox.Show("Saved Successfully!"); ClearControls(); tbxGroupName.Focus(); } }
private void btnUpdate_Click(object sender, EventArgs e) { CostCentreGroupModel objModel = new CostCentreGroupModel(); objModel.CCG_ID = groupId; objModel.GroupName = tbxGroupName.Text.Trim(); objModel.Alias = tbxAlias.Text.Trim(); objModel.underGroup = cbxUndergroup.SelectedItem.ToString(); objModel.PrimaryGroup = cbxPrimarygroup.SelectedItem.ToString() == "Y" ? true : false; objModel.CreatedBy = "Admin"; bool isSuccess = objCG.UpdateCCGM(objModel); if (isSuccess) { MessageBox.Show("Update Successfully!"); ClearControls(); groupId = 0; Administration.List.CostcentergrpList frmList = new Administration.List.CostcentergrpList(); frmList.StartPosition = FormStartPosition.CenterScreen; frmList.ShowDialog(); FillCostCenterGroupInfo(); } }
//Get All CostcenterGroup By Id public CostCentreGroupModel GetAllCostCentreGroupsById(int id) { CostCentreGroupModel objCCG = new CostCentreGroupModel(); string Query = "SELECT * FROM CostCentreGroupMaster WHERE CCG_ID=" + id + ""; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objCCG = new CostCentreGroupModel(); objCCG.CCG_ID = Convert.ToInt32(dr["CCG_ID"]); objCCG.GroupName = dr["GroupName"].ToString(); objCCG.Alias = dr["Alias"].ToString(); objCCG.PrimaryGroup = Convert.ToBoolean(dr["PrimaryGroup"]); objCCG.underGroup = dr["underGroup"].ToString(); } return(objCCG); }
private void FillCostCenterGroupInfo() { if (groupId == 0) { tbxGroupName.Focus(); ClearControls(); lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; return; } CostCentreGroupModel objMaster = objCG.GetAllCostCentreGroupsById(groupId); tbxGroupName.Text = objMaster.GroupName; tbxAlias.Text = objMaster.Alias; cbxPrimarygroup.SelectedItem = (objMaster.PrimaryGroup)?"Y" : "N"; cbxUndergroup.SelectedItem = objMaster.underGroup; lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; }
//List public List <CostCentreGroupModel> GetAllCostCentreGroups() { List <CostCentreGroupModel> lstCCG = new List <CostCentreGroupModel>(); CostCentreGroupModel objCCG; string Query = "SELECT * FROM CostCentreGroupMaster"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objCCG = new CostCentreGroupModel(); objCCG.CCG_ID = Convert.ToInt32(dr["CCG_ID"]); objCCG.GroupName = dr["GroupName"].ToString(); objCCG.Alias = dr["Alias"].ToString(); objCCG.PrimaryGroup = Convert.ToBoolean(dr["PrimaryGroup"]); objCCG.underGroup = dr["underGroup"].ToString(); //objCCG.ModifiedBy = dr["ModifiedBy"].ToString(); lstCCG.Add(objCCG); } return(lstCCG); }
private void btnSave_Click(object sender, EventArgs e) { if (tbxGroupName.Text.Equals(string.Empty)) { MessageBox.Show("Group Name can not be blank!"); return; } //if (accObj.IsGroupExists(tbxGroupName.Text.Trim())) //{ // MessageBox.Show("Group Name already Exists!", "SunSpeed", MessageBoxButtons.RetryCancel); // cbxUnderGrp.Focus(); // return; //} CostCentreGroupModel objModel = new CostCentreGroupModel(); objModel.GroupName = tbxGroupName.Text.Trim(); objModel.Alias = tbxAlias.Text.Trim(); objModel.underGroup = cbxUndergroup.SelectedItem.ToString(); objModel.PrimaryGroup = cbxPrimarygroup.SelectedItem.ToString() == "Y" ? true : false; objModel.CreatedBy = "Admin"; bool isSuccess = objCG.SaveCCG(objModel); if (isSuccess) { MessageBox.Show("Saved Successfully!"); } //List<CostCentreGroupModel> lstGroups = objCG.GetAllCostCentreGroups(); //dgvList.DataSource = lstGroups; //Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!"); //d.ShowDialog(); }