public int Update(ML_CategoryGroupMaster objML_CategoryGroupMaster)
{
int results = 0;
try
{
sbTraceInformation = new StringBuilder();
sbTraceInformation.Append("Entered:-Inside BusinessClasses-CategoryGroupMaster:Update(ML_CategoryGroupMaster");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
SqlParameter ReturnObj = new SqlParameter("@ReturnObj", ParameterDirection.Output);
ReturnObj.Direction = ParameterDirection.Output;
SqlParameter[] parameters =
{
#region Update Properties
new SqlParameter("@CategoryGroupCode", objML_CategoryGroupMaster.CategoryGroupCode),
new SqlParameter("@CanteenCode", objML_CategoryGroupMaster.CanteenCode),
new SqlParameter("@CategoryGroupName", objML_CategoryGroupMaster.CategoryGroupName),
new SqlParameter("@CategoryGroupActive", objML_CategoryGroupMaster.CategoryGroupActive),
ReturnObj
#endregion
};
this.Parameters = parameters;
SqlHelper.ExecuteNonQuery(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_UpdateCategoryGroupMaster.ToString(), this.Parameters);
sbTraceInformation.Append("Exit:-From BusinessClasses-CategoryGroupMaster:Update(ML_CategoryGroupMaster");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
if (ReturnObj.Value != null)
{
results = ML_Common.string2int32(ReturnObj.Value.ToString());
}
}
catch (SqlException sqlExc)
{
int errNumber = int.MinValue;
//LogManager.LogManager.WriteErrorLog(sqlExc);
foreach (SqlError error in sqlExc.Errors)
{
errNumber = error.Number;
}
if (errNumber == 50000)
{
results = 999;
throw;
}
}
catch (Exception ex)
{
results = 0;
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString());
}
return(results);
}
public DataSet GetCategoryGroupMasterByLoginName(string loginName)
{
DataSet ds = null;
try
{
sbTraceInformation = new StringBuilder();
sbTraceInformation.Append("Entered:-Inside BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterByLoginName(string loginName)");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
objML_CategoryGroupMaster = new ML_CategoryGroupMaster();
SqlParameter[] parameters =
{
#region Get Properties
new SqlParameter("@loginName", loginName)
#endregion
};
this.Parameters = parameters;
ds = SqlHelper.ExecuteDataset(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCategoryGroupMasterByLoginName.ToString(), this.Parameters);
sbTraceInformation.Append("Exit:-From BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterByLoginName(string loginName)");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
}
catch (Exception ex)
{
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString());
}
return(ds);
}
public DataSet GetCategoryGroupMasterBySeacrh(ML_CategoryGroupMaster objML_CategoryGroupMaster)
{
DataSet ds = null;
try
{
sbTraceInformation = new StringBuilder();
sbTraceInformation.Append("Entered:-Inside BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterBySeacrh(ML_CategoryGroupMaster objML_CategoryGroupMaster");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
DateTime?dtFromdate = null;
DateTime objFromdate;
if (DateTime.TryParse(objML_CategoryGroupMaster.FromDate.ToString(), out objFromdate))
{
if (objFromdate.ToString() != "1/1/1900 12:00:00 AM")
{
dtFromdate = objFromdate;
}
}
DateTime?dtTodate = null;
DateTime objdtTodate;
if (DateTime.TryParse(objML_CategoryGroupMaster.ToDate.ToString(), out objdtTodate))
{
if (objdtTodate.ToString() != "1/1/1900 12:00:00 AM")
{
dtTodate = objdtTodate;
}
}
SqlParameter[] parameters =
{
#region Search Properties
new SqlParameter("@CategoryGroupCode", objML_CategoryGroupMaster.CategoryGroupCode),
new SqlParameter("@CanteenCode", objML_CategoryGroupMaster.CanteenCode),
new SqlParameter("@CategoryGroupName", objML_CategoryGroupMaster.CategoryGroupName),
new SqlParameter("@CategoryGroupActive", objML_CategoryGroupMaster.CategoryGroupActive),
new SqlParameter("@FromDate", dtFromdate),
new SqlParameter("@ToDate", dtTodate)
#endregion
};
this.Parameters = parameters;
ds = SqlHelper.ExecuteDataset(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCategoryGroupMasterBySearch.ToString(), this.Parameters);
sbTraceInformation.Append("Exit:-From BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterBySeacrh(ML_CategoryGroupMaster objML_CategoryGroupMaster");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
}
catch (Exception ex)
{
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString());
}
return(ds);
}
public ML_CategoryGroupMaster GetCategoryGroupMasterByCategoryGroupActive(long CategoryGroupActive)
{
try
{
sbTraceInformation = new StringBuilder();
sbTraceInformation.Append("Entered:-Inside BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterById(long Id)");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
objML_CategoryGroupMaster = new ML_CategoryGroupMaster();
SqlParameter[] parameters =
{
#region Get Properties
new SqlParameter("@CategoryGroupActive", CategoryGroupActive)
#endregion
};
this.Parameters = parameters;
DataSet ds = SqlHelper.ExecuteDataset(ML_Connection.CreateConnection().ToString(), CommandType.StoredProcedure, StoredProcedure.Name.usp_GetCategoryGroupMasterByCategoryGroupActive.ToString(), this.Parameters);
sbTraceInformation.Append("Exit:-From BusinessClasses-CategoryGroupMaster:GetCategoryGroupMasterById(long Id)");
sbTraceInformation.Remove(0, sbTraceInformation.Length);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
objML_CategoryGroupMaster.CategoryGroupCode = ML_Common.string2int32(ML_Common.clean(dr["CategoryGroupCode"].ToString()));
objML_CategoryGroupMaster.CanteenCode = ML_Common.string2int32(ML_Common.clean(dr["CanteenCode"].ToString()));
objML_CategoryGroupMaster.CategoryGroupName = ML_Common.clean(dr["CategoryGroupName"].ToString());
objML_CategoryGroupMaster.CategoryGroupActive = ML_Common.string2int32(ML_Common.clean(dr["CategoryGroupActive"].ToString()));
}
}
}
catch (Exception ex)
{
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
throw;
}
finally
{
//LogManager.LogManager.WriteTraceLog(sbTraceInformation.ToString());
}
return(objML_CategoryGroupMaster);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsValid)
{
errNumber = -1;
try
{
objBusinessClass = new BusinessLayer.BusinessClass();
objML_CategoryGroupMaster = new ML_CategoryGroupMaster();
string strAdminLoginName = string.Empty;
if (Session["AdminLoginName"] != null)
{
strAdminLoginName = Session["AdminLoginName"].ToString();
}
// objML_CategoryGroupMaster.CategoryGroupCode = ML_Common.string2int32(ML_Common.clean(txtCategoryGroupCode.Text));
objML_CategoryGroupMaster.CanteenCode = ML_Common.string2int32(ML_Common.clean(txtCanteenCode.Text));
objML_CategoryGroupMaster.CategoryGroupName = ML_Common.clean(txtCategoryGroupName.Text);
// objML_CategoryGroupMaster.CategoryGroupActive = ML_Common.string2int32(ML_Common.clean(txtCategoryGroupActive.Text));
// objML_CategoryGroupMaster.IsActive = ML_Common.clean(ML_Common.bit2int(chkIsActive.Checked).ToString());
// objML_CategoryGroupMaster.IsArchive = ML_Common.clean(ML_Common.bit2int(chkIsArchive.Checked).ToString());
// objML_CategoryGroupMaster.CreatedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString());
// objML_CategoryGroupMaster.CreatedBy = ML_Common.clean(string.Empty);
// objML_CategoryGroupMaster.ModifiedDate = ML_Common.ToDateTimeSafe(System.DateTime.Now.ToString());
// objML_CategoryGroupMaster.ModifiedBy = ML_Common.clean(string.Empty);
int obhReturn = objBusinessClass.AddCategoryGroupMaster(objML_CategoryGroupMaster);
if (obhReturn == 1)
{
lblMsg.Visible = true;
lblMsg.Text = "Record Saved Successfully";
}
else if (obhReturn == 2)
{
lblMsg.Text = "Record Already Exists!";
lblMsg.Visible = true;
}
}
catch (SqlException sqlExc)
{
// LogManager.LogManager.WriteErrorLog(sqlExc);
foreach (SqlError error in sqlExc.Errors)
{
errNumber = error.Number;
}
if (errNumber == 50000)
{
}
return;
}
catch (Exception ex)
{
Exception exc = ex;// Exception exc=ex;// LogManager.LogManager.WriteErrorLog(ex);
}
}
}
