public int UpdateOfficeGroupTemplate(OfficeGroupTemplate groupOffices)
{
try
{
int ReturnValue = 0;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add(GetParameter("@OfficeGroupTemplateID", SqlDbType.VarChar, groupOffices.OfficeGroupTemplateID));
sqlCmd.Parameters.Add(GetParameter("@OfficeID", SqlDbType.VarChar, groupOffices.office.OfficeID));
sqlCmd.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.DateTime, groupOffices.EffectiveDateFrom));
sqlCmd.Parameters.Add(GetParameter("@EffectiveDateTo", SqlDbType.DateTime, groupOffices.EffectiveDateTo));
sqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
sqlCmd.CommandText = "pADM_OfficeGroupTemplates_Update";
ExecuteStoredProcedure(sqlCmd);
return(int.Parse(sqlCmd.Parameters[0].Value.ToString()));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public int UpdateOfficeGroupTemplate(OfficeGroupTemplate officeGroupTemplate)
{
try
{
return(OfficeGroupIntegration.UpdateOfficeGroupTemplate(officeGroupTemplate));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int InsertOfficeGroupTemplate(OfficeGroupTemplate OfficeGrouptemplate)
{
try
{
return(OfficeGroupsDataAccess.GetInstance.InsertOfficeGroupTemplate(OfficeGrouptemplate));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static OfficeGroupTemplate ConvertFromDatarowToObjectOfficeTemplate(DataRow dataRow)
{
try
{
OfficeGroupTemplate officeGroupTemplate = new OfficeGroupTemplate();
if (dataRow != null)
{
officeGroupTemplate.OfficeGroupTemplateID = int.Parse(dataRow["OfficeGroupTemplateID"].ToString());
officeGroupTemplate.OfficeGroupID = int.Parse(dataRow["OfficeGroupID"].ToString());
officeGroupTemplate.office.OfficeID = int.Parse(dataRow["OfficeID"].ToString());
officeGroupTemplate.EffectiveDateFrom = DateTime.Parse(dataRow["EffectiveDateFrom"].ToString());
officeGroupTemplate.EffectiveDateTo = DateTime.Parse(dataRow["EffectiveDateTo"].ToString());
//officeGroupTemplate.IsActive = (bool)dataRow["IsActive"];
//officeGroupTemplate.IsDeleted = (bool)dataRow["IsDeleted"];
}
return(officeGroupTemplate);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
