public static int Delete(SRPSettings o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[2];
arrParams[0] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[1] = new SqlParameter("@TenID",
(HttpContext.Current.Session["TenantID"] == null || HttpContext.Current.Session["TenantID"].ToString() == "" ?
-1 :
(int)HttpContext.Current.Session["TenantID"])
);
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SRPSettings_Delete", arrParams);
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return(iReturn);
}
public static int Insert(SRPSettings o)
{
SqlParameter[] arrParams = new SqlParameter[20];
arrParams[0] = new SqlParameter("@Name", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Name, o.Name.GetTypeCode()));
arrParams[1] = new SqlParameter("@Value", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Value, o.Value.GetTypeCode()));
arrParams[2] = new SqlParameter("@StorageType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.StorageType, o.StorageType.GetTypeCode()));
arrParams[3] = new SqlParameter("@EditType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EditType, o.EditType.GetTypeCode()));
arrParams[4] = new SqlParameter("@ModID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ModID, o.ModID.GetTypeCode()));
arrParams[5] = new SqlParameter("@Label", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Label, o.Label.GetTypeCode()));
arrParams[6] = new SqlParameter("@Description", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Description, o.Description.GetTypeCode()));
arrParams[7] = new SqlParameter("@ValueList", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ValueList, o.ValueList.GetTypeCode()));
arrParams[8] = new SqlParameter("@DefaultValue", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DefaultValue, o.DefaultValue.GetTypeCode()));
arrParams[9] = new SqlParameter("@TenID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.TenID, o.TenID.GetTypeCode()));
arrParams[10] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[11] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[12] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[13] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[14] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[15] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[16] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[17] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[18] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
arrParams[19] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[19].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SRPSettings_Insert", arrParams);
return(int.Parse(arrParams[19].Value.ToString()));
}
protected override bool CheckBusinessRules(BusinessRulesValidationMode validationMode)
{
// Remove any old error Codes
ClearErrorCodes();
ClearErrorCodes();
if (validationMode == BusinessRulesValidationMode.INSERT)
{
var allowdups = SRPSettings.GetSettingValue("DupEvtCodes").ToUpper() == "TRUE";
if (!allowdups && GetEventCountByEventCode(SecretCode) != 0)
{
AddErrorCode(new BusinessRulesValidationMessage("Secret Code", "Secret Code", "The Secret Code you have chosen is already in use. Please select a different Secret Code.",
BusinessRulesValidationCode.UNSPECIFIED));
}
}
if (validationMode == BusinessRulesValidationMode.UPDATE)
{
var allowdups = SRPSettings.GetSettingValue("DupEvtCodes").ToUpper() == "TRUE";
if (!allowdups && GetEventCountByEventCode(EID, SecretCode) != 0)
{
AddErrorCode(new BusinessRulesValidationMessage("Secret Code", "Secret Code", "The Secret Code you have chosen is already in use. Please select a different Secret Code.",
BusinessRulesValidationCode.UNSPECIFIED));
}
}
return(ErrorCodes.Count == 0);
//return true;
}
public static int Update(SRPSettings o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[20];
arrParams[0] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[1] = new SqlParameter("@Name", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Name, o.Name.GetTypeCode()));
arrParams[2] = new SqlParameter("@Value", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Value, o.Value.GetTypeCode()));
arrParams[3] = new SqlParameter("@StorageType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.StorageType, o.StorageType.GetTypeCode()));
arrParams[4] = new SqlParameter("@EditType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EditType, o.EditType.GetTypeCode()));
arrParams[5] = new SqlParameter("@ModID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ModID, o.ModID.GetTypeCode()));
arrParams[6] = new SqlParameter("@Label", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Label, o.Label.GetTypeCode()));
arrParams[7] = new SqlParameter("@Description", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Description, o.Description.GetTypeCode()));
arrParams[8] = new SqlParameter("@ValueList", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ValueList, o.ValueList.GetTypeCode()));
arrParams[9] = new SqlParameter("@DefaultValue", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DefaultValue, o.DefaultValue.GetTypeCode()));
arrParams[10] = new SqlParameter("@TenID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.TenID, o.TenID.GetTypeCode()));
arrParams[11] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[12] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[13] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[14] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[15] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[16] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[17] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[18] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[19] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SRPSettings_Update", arrParams);
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return(iReturn);
}
public static int Delete(SRPSettings o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[2];
arrParams[0] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[1] = new SqlParameter("@TenID",
(HttpContext.Current.Session["TenantID"] == null || HttpContext.Current.Session["TenantID"].ToString() == "" ?
-1 :
(int)HttpContext.Current.Session["TenantID"])
);
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SRPSettings_Delete", arrParams);
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return iReturn;
}
public static int Update(SRPSettings o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[20];
arrParams[0] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[1] = new SqlParameter("@Name", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Name, o.Name.GetTypeCode()));
arrParams[2] = new SqlParameter("@Value", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Value, o.Value.GetTypeCode()));
arrParams[3] = new SqlParameter("@StorageType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.StorageType, o.StorageType.GetTypeCode()));
arrParams[4] = new SqlParameter("@EditType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EditType, o.EditType.GetTypeCode()));
arrParams[5] = new SqlParameter("@ModID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ModID, o.ModID.GetTypeCode()));
arrParams[6] = new SqlParameter("@Label", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Label, o.Label.GetTypeCode()));
arrParams[7] = new SqlParameter("@Description", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Description, o.Description.GetTypeCode()));
arrParams[8] = new SqlParameter("@ValueList", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ValueList, o.ValueList.GetTypeCode()));
arrParams[9] = new SqlParameter("@DefaultValue", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DefaultValue, o.DefaultValue.GetTypeCode()));
arrParams[10] = new SqlParameter("@TenID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.TenID, o.TenID.GetTypeCode()));
arrParams[11] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[12] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[13] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[14] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[15] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[16] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[17] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[18] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[19] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SRPSettings_Update", arrParams);
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return iReturn;
}
public static int Insert(SRPSettings o)
{
SqlParameter[] arrParams = new SqlParameter[20];
arrParams[0] = new SqlParameter("@Name", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Name, o.Name.GetTypeCode()));
arrParams[1] = new SqlParameter("@Value", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Value, o.Value.GetTypeCode()));
arrParams[2] = new SqlParameter("@StorageType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.StorageType, o.StorageType.GetTypeCode()));
arrParams[3] = new SqlParameter("@EditType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EditType, o.EditType.GetTypeCode()));
arrParams[4] = new SqlParameter("@ModID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ModID, o.ModID.GetTypeCode()));
arrParams[5] = new SqlParameter("@Label", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Label, o.Label.GetTypeCode()));
arrParams[6] = new SqlParameter("@Description", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Description, o.Description.GetTypeCode()));
arrParams[7] = new SqlParameter("@ValueList", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ValueList, o.ValueList.GetTypeCode()));
arrParams[8] = new SqlParameter("@DefaultValue", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DefaultValue, o.DefaultValue.GetTypeCode()));
arrParams[9] = new SqlParameter("@TenID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.TenID, o.TenID.GetTypeCode()));
arrParams[10] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[11] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[12] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[13] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[14] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[15] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[16] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[17] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[18] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
arrParams[19] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[19].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SRPSettings_Insert", arrParams);
return int.Parse(arrParams[19].Value.ToString());
}
public static SRPSettings GetSRPSettingsByName(string Name, int TenID)
{
// declare reader
SqlDataReader dr;
SqlParameter[] arrParams = new SqlParameter[2];
arrParams[0] = new SqlParameter("@Name", Name);
arrParams[1] = new SqlParameter("@TenID", TenID);
dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "app_SRPSettings_GetByName", arrParams);
if (dr.Read())
{
// declare return value
SRPSettings result = new SRPSettings();
//DateTime _datetime;
int _int;
//decimal _decimal;
if (int.TryParse(dr["SID"].ToString(), out _int)) result.SID = _int;
result.Name = dr["Name"].ToString();
result.Value = dr["Value"].ToString();
result.StorageType = dr["StorageType"].ToString();
result.EditType = dr["EditType"].ToString();
if (int.TryParse(dr["ModID"].ToString(), out _int)) result.ModID = _int;
result.Label = dr["Label"].ToString();
result.Description = dr["Description"].ToString();
result.ValueList = dr["ValueList"].ToString();
result.DefaultValue = dr["DefaultValue"].ToString();
if (int.TryParse(dr["TenID"].ToString(), out _int)) result.TenID = _int;
if (int.TryParse(dr["FldInt1"].ToString(), out _int)) result.FldInt1 = _int;
if (int.TryParse(dr["FldInt2"].ToString(), out _int)) result.FldInt2 = _int;
if (int.TryParse(dr["FldInt3"].ToString(), out _int)) result.FldInt3 = _int;
result.FldBit1 = bool.Parse(dr["FldBit1"].ToString());
result.FldBit2 = bool.Parse(dr["FldBit2"].ToString());
result.FldBit3 = bool.Parse(dr["FldBit3"].ToString());
result.FldText1 = dr["FldText1"].ToString();
result.FldText2 = dr["FldText2"].ToString();
result.FldText3 = dr["FldText3"].ToString();
dr.Close();
return result;
}
dr.Close();
return null;
}
public static SRPSettings GetSRPSettingsByName(string Name, int TenID)
{
// declare reader
SqlDataReader dr;
SqlParameter[] arrParams = new SqlParameter[2];
arrParams[0] = new SqlParameter("@Name", Name);
arrParams[1] = new SqlParameter("@TenID", TenID);
dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "app_SRPSettings_GetByName", arrParams);
if (dr.Read())
{
// declare return value
SRPSettings result = new SRPSettings();
//DateTime _datetime;
int _int;
//decimal _decimal;
if (int.TryParse(dr["SID"].ToString(), out _int))
{
result.SID = _int;
}
result.Name = dr["Name"].ToString();
result.Value = dr["Value"].ToString();
result.StorageType = dr["StorageType"].ToString();
result.EditType = dr["EditType"].ToString();
if (int.TryParse(dr["ModID"].ToString(), out _int))
{
result.ModID = _int;
}
result.Label = dr["Label"].ToString();
result.Description = dr["Description"].ToString();
result.ValueList = dr["ValueList"].ToString();
result.DefaultValue = dr["DefaultValue"].ToString();
if (int.TryParse(dr["TenID"].ToString(), out _int))
{
result.TenID = _int;
}
if (int.TryParse(dr["FldInt1"].ToString(), out _int))
{
result.FldInt1 = _int;
}
if (int.TryParse(dr["FldInt2"].ToString(), out _int))
{
result.FldInt2 = _int;
}
if (int.TryParse(dr["FldInt3"].ToString(), out _int))
{
result.FldInt3 = _int;
}
result.FldBit1 = bool.Parse(dr["FldBit1"].ToString());
result.FldBit2 = bool.Parse(dr["FldBit2"].ToString());
result.FldBit3 = bool.Parse(dr["FldBit3"].ToString());
result.FldText1 = dr["FldText1"].ToString();
result.FldText2 = dr["FldText2"].ToString();
result.FldText3 = dr["FldText3"].ToString();
dr.Close();
return(result);
}
dr.Close();
return(null);
}
