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