public static CrmSetting GetCrmSettingById(int SettingID)
{
DataRow CrmSettingRow = CrmSettingDataAccess.GetInstance.GetCrmSettingById(SettingID);
CrmSetting TheCrmSetting = new CrmSetting();
TheCrmSetting.SettingID = int.Parse(CrmSettingRow["SettingID"].ToString());
TheCrmSetting.SettingDataType = CrmSettingRow["SettingDataType"].ToString();
TheCrmSetting.SettingKeyID = int.Parse(CrmSettingRow["SettingKeyID"].ToString());
TheCrmSetting.SettingValue = CrmSettingRow["SettingValue"].ToString();
TheCrmSetting.EffectiveDateFrom = DateTime.Parse(CrmSettingRow["EffectiveDateFrom"].ToString()).ToString(Micro.Commons.MicroConstants.DateFormat);
return(TheCrmSetting);
}
public int DeleteSetting(CrmSetting theSetting)
{
int ReturnValue = 0;
using (SqlCommand DeleteCommand = new SqlCommand())
{
DeleteCommand.CommandType = CommandType.StoredProcedure;
DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
DeleteCommand.Parameters.Add(GetParameter("@SettingID", SqlDbType.Int, theSetting.SettingID));
DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
DeleteCommand.CommandText = "pADM_Settings_Delete";
ExecuteStoredProcedure(DeleteCommand);
ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static List <CrmSetting> GetSettingKeyList(string searchText)
{
List <CrmSetting> CrmSettingKeyList = new List <CrmSetting>();
DataTable GetCrmSettingKeyTable = new DataTable();
GetCrmSettingKeyTable = CrmSettingDataAccess.GetInstance.GetSettingKeyList(searchText);
foreach (DataRow dr in GetCrmSettingKeyTable.Rows)
{
CrmSetting TheCrmSettingKey = new CrmSetting();
TheCrmSettingKey.SettingKeyID = int.Parse(dr["SettingKeyID"].ToString());
TheCrmSettingKey.SettingKeyName = dr["SettingKeyName"].ToString();
CrmSettingKeyList.Add(TheCrmSettingKey);
}
return(CrmSettingKeyList);
}
public int UpdateSetting(CrmSetting theCrmSetting)
{
int ReturnValue = 0;
using (SqlCommand UpdateCommand = new SqlCommand())
{
UpdateCommand.CommandType = CommandType.StoredProcedure;
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@SettingID", SqlDbType.Int, theCrmSetting.SettingID));
UpdateCommand.Parameters.Add(GetParameter("@SettingKeyID", SqlDbType.Int, theCrmSetting.SettingKeyID));
UpdateCommand.Parameters.Add(GetParameter("@SettingDataType", SqlDbType.VarChar, theCrmSetting.SettingDataType));
UpdateCommand.Parameters.Add(GetParameter("@SettingValue", SqlDbType.VarChar, theCrmSetting.SettingValue));
UpdateCommand.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.VarChar, theCrmSetting.EffectiveDateFrom));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.CommandText = "pADM_Settings_Update";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int InsertSetting(CrmSetting TheCrmSetting)
{
int ReturnValue = 0;
using (SqlCommand InsertCommand = new SqlCommand())
{
InsertCommand.CommandType = CommandType.StoredProcedure;
InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
InsertCommand.Parameters.Add(GetParameter("@SettingKeyName", SqlDbType.VarChar, TheCrmSetting.SettingKeyName));
InsertCommand.Parameters.Add(GetParameter("@SettingKeyModuleID", SqlDbType.Int, TheCrmSetting.SettingKeyModuleID));
InsertCommand.Parameters.Add(GetParameter("@SettingDataType", SqlDbType.VarChar, TheCrmSetting.SettingDataType));
InsertCommand.Parameters.Add(GetParameter("@SettingValue", SqlDbType.VarChar, TheCrmSetting.SettingValue));
InsertCommand.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.VarChar, TheCrmSetting.EffectiveDateFrom));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pADM_Settings_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static List <CrmSetting> GetCrmSettingList(string SearchText, bool showDeleted = false)
{
List <CrmSetting> CrmSettingList = new List <CrmSetting>();
DataTable CrmSettingTable = new DataTable();
CrmSettingTable = CrmSettingDataAccess.GetInstance.GetCrmSettingList(SearchText, showDeleted);
foreach (DataRow dr in CrmSettingTable.Rows)
{
CrmSetting TheCrmSetting = new CrmSetting();
TheCrmSetting.SettingID = int.Parse(dr["SettingID"].ToString());
TheCrmSetting.SettingKeyName = dr["SettingKeyName"].ToString();
TheCrmSetting.SettingValue = dr["SettingValue"].ToString();
TheCrmSetting.EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(Micro.Commons.MicroConstants.DateFormat);
CrmSettingList.Add(TheCrmSetting);
}
return(CrmSettingList);
}
public static int DeleteSetting(CrmSetting theCrmSetting)
{
return(CrmSettingDataAccess.GetInstance.DeleteSetting(theCrmSetting));
}
public static int InsertSetting(CrmSetting TheCrmSetting)
{
return(CrmSettingDataAccess.GetInstance.InsertSetting(TheCrmSetting));
}
public int DeleteSetting(CrmSetting theCrmSetting)
{
return(CrmSettingIntegration.DeleteSetting(theCrmSetting));
}
public int UpdateSetting(CrmSetting theCrmSetting)
{
return(CrmSettingIntegration.UpdateSetting(theCrmSetting));
}
public int InsertSetting(CrmSetting TheCrmSetting)
{
return(CrmSettingIntegration.InsertSetting(TheCrmSetting));
}
