private void btnSave_Click(object sender, EventArgs e) { ReferenceGroupModel objmodel = new ReferenceGroupModel(); objmodel.Name = tbxName.Text.Trim(); bool issaved = objrefbl.SaveReferenceGroup(objmodel); if (issaved) { MessageBox.Show("Saved Succufully!"); } }
//Get Reference Group Details By Id public ReferenceGroupModel GetReferenceDetailsById(int id) { ReferenceGroupModel objReference = new ReferenceGroupModel(); string Query = "SELECT * FROM referencegroup WHERE RG_ID=" + id + ""; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objReference.ReferenceId = Convert.ToInt32(dr["RG_ID"]); objReference.Name = dr["Name"].ToString(); } return(objReference); }
private void FillReferenceGroup() { if (RefId == 0) { tbxName.Focus(); laCtrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; laCtrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; laCtrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; return; } ReferenceGroupModel objReference = objrefbl.GetReferenceDetailsById(RefId); tbxName.Text = objReference.Name; laCtrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; laCtrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; laCtrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; tbxName.Focus(); }
private void btnUpdate_Click(object sender, EventArgs e) { ReferenceGroupModel objmodel = new ReferenceGroupModel(); objmodel.Name = tbxName.Text.Trim(); objmodel.ReferenceId = RefId; bool IsUpdate = objrefbl.UpdateReferenceGroup(objmodel); if (IsUpdate) { MessageBox.Show("Update Succufully!"); tbxName.Text = string.Empty; RefId = 0; tbxName.Focus(); Administration.List.ReferencegroupList frmList = new Administration.List.ReferencegroupList(); frmList.StartPosition = FormStartPosition.CenterScreen; frmList.ShowDialog(); FillReferenceGroup(); } }
//Get Lis Of All Reference Group public List <ReferenceGroupModel> GetAllReferenceGroups() { List <ReferenceGroupModel> lstRefGrp = new List <ReferenceGroupModel>(); eSunSpeedDomain.ReferenceGroupModel referencegroup; string Query = "SELECT DISTINCT RG_ID,Name FROM `referencegroup`"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { referencegroup = new ReferenceGroupModel(); referencegroup.ReferenceId = Convert.ToInt32(dr["RG_ID"]); referencegroup.Name = dr["Name"].ToString(); lstRefGrp.Add(referencegroup); } return(lstRefGrp); }