public static CustomList <HouseKeepingValue> GetAllHouseKeepingValue(Int32 EntityID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <HouseKeepingValue> HouseKeepingValueCollection = new CustomList <HouseKeepingValue>();
IDataReader reader = null;
String sql = "select *from HouseKeepingValue Where EntityID=" + EntityID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.SetData(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return(HouseKeepingValueCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <HouseKeepingValue> GetCompany()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <HouseKeepingValue> HouseKeepingValueCollection = new CustomList <HouseKeepingValue>();
IDataReader reader = null;
String sql = "Exec GetCompany";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.HKID = reader.GetInt32("HKID");
newHouseKeepingValue.HKName = reader.GetString("HKName");
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return(HouseKeepingValueCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <HouseKeepingValue> GetAllSingleEntity(string spName)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <HouseKeepingValue> HouseKeepingValueCollection = new CustomList <HouseKeepingValue>();
IDataReader reader = null;
String sql = "EXEC " + spName;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.SetDataHeadType(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return(HouseKeepingValueCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <HouseKeepingValue> GetAllHouseKeepingValueForDropdown(Int32 parentID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <HouseKeepingValue> HouseKeepingValueCollection = new CustomList <HouseKeepingValue>();
IDataReader reader = null;
String sql = "EXEC spGetChangeEventHouseKeepingValue '" + parentID + "'";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.SetDataForDropdown(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return(HouseKeepingValueCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <HouseKeepingValue> GetAllHouseKeepingValue(string search, string blank)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <HouseKeepingValue> HouseKeepingValueCollection = new CustomList <HouseKeepingValue>();
IDataReader reader = null;
String sql = search;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.SetData(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
HouseKeepingValueCollection.InsertSpName = "spInsertHouseKeepingValue";
HouseKeepingValueCollection.UpdateSpName = "spUpdateHouseKeepingValue";
HouseKeepingValueCollection.DeleteSpName = "spDeleteHouseKeepingValue";
return(HouseKeepingValueCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList<HouseKeepingValue> GetCompany()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<HouseKeepingValue> HouseKeepingValueCollection = new CustomList<HouseKeepingValue>();
IDataReader reader = null;
String sql = "Exec GetCompany";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.HKID = reader.GetInt32("HKID");
newHouseKeepingValue.HKName = reader.GetString("HKName");
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return HouseKeepingValueCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<HouseKeepingValue> GetAllHouseKeepingValueForDropdown(Int32 parentID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<HouseKeepingValue> HouseKeepingValueCollection = new CustomList<HouseKeepingValue>();
IDataReader reader = null;
String sql = "EXEC spGetChangeEventHouseKeepingValue '" + parentID + "'";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.SetDataForDropdown(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return HouseKeepingValueCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<HouseKeepingValue> GetAllSingleEntity(string spName)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<HouseKeepingValue> HouseKeepingValueCollection = new CustomList<HouseKeepingValue>();
IDataReader reader = null;
String sql = "EXEC " + spName;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.SetDataHeadType(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return HouseKeepingValueCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<HouseKeepingValue> GetAllHouseKeepingValue(Int32 EntityID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<HouseKeepingValue> HouseKeepingValueCollection = new CustomList<HouseKeepingValue>();
IDataReader reader = null;
String sql = "select *from HouseKeepingValue Where EntityID=" + EntityID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.SetData(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return HouseKeepingValueCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<HouseKeepingValue> GetAllHouseKeepingValue(string search, string blank)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<HouseKeepingValue> HouseKeepingValueCollection = new CustomList<HouseKeepingValue>();
IDataReader reader = null;
String sql = search;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HouseKeepingValue newHouseKeepingValue = new HouseKeepingValue();
newHouseKeepingValue.SetData(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
HouseKeepingValueCollection.InsertSpName = "spInsertHouseKeepingValue";
HouseKeepingValueCollection.UpdateSpName = "spUpdateHouseKeepingValue";
HouseKeepingValueCollection.DeleteSpName = "spDeleteHouseKeepingValue";
return HouseKeepingValueCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
private void SetDataInControls(HouseKeepingValue hk)
{
try
{
txtHKName.Text = hk.HKName;
txtShortName.Text = hk.ShortName;
txtDescription.Text = hk.Description;
txtAddress.Text = hk.Address;
}
catch (Exception ex)
{
throw (ex);
}
}
private void PopulateHKInformation(HouseKeepingValue hK)
{
try
{
SetDataInControls(hK);
ChildList = manager.GetAllHousekeepingHierarchy(hK.HKID);
foreach (HouseKeepingValue hKV in ParentList)
{
if (ChildList.FindAll(f => f.ParentID == hKV.HKID).Count != 0)
{
hKV.IsSaved = true;
}
else
{
hKV.IsSaved = false;
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
CustomList<HouseKeepingValue> lstHKEntry = HouseKeepingList;
if (lstHKEntry.Count == 0)
{
HouseKeepingValue newHouseKeepingEntry = new HouseKeepingValue();
lstHKEntry.Add(newHouseKeepingEntry);
}
CustomList<HouseKeepingValue> lstParent = ParentList;
CustomList<HousekeepingHierarchy> lstChild = ChildList;
CustomList<HousekeepingHierarchy> savedList = new CustomList<HousekeepingHierarchy>();
foreach (HouseKeepingValue hKV in lstParent)
{
if (hKV.IsSaved)
{
HousekeepingHierarchy childObj = ChildList.Find(f => f.ParentID == hKV.HKID);
if (childObj.IsNotNull())
{
savedList.Add(childObj);
}
else
{
HousekeepingHierarchy obj = new HousekeepingHierarchy();
obj.ParentID = hKV.HKID;
savedList.Add(obj);
}
}
else
{
HousekeepingHierarchy childObj = ChildList.Find(f => f.ParentID == hKV.HKID);
if (childObj.IsNotNull())
{
childObj.Delete();
savedList.Add(childObj);
}
}
}
SetDataFromControls(ref lstHKEntry);
if (!CheckUserAuthentication(lstHKEntry)) return;
manager.SaveHKEntry(ref lstHKEntry, ref savedList);
this.SuccessMessage = (StaticInfo.SavedSuccessfullyMsg);
}
catch (SqlException ex)
{
this.ErrorMessage = (ExceptionHelper.getSqlExceptionMessage(ex));
}
catch (Exception ex)
{
this.ErrorMessage = (ExceptionHelper.getExceptionMessage(ex));
}
}