public Result UpdateOptionalParameters(OptionalParametersViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[9];
aParams[0] = new NpgsqlParameter("CallSignID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = model.CallSignID;
aParams[1] = new NpgsqlParameter("CbsdInfoID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = model.CbsdInfoID;
aParams[2] = new NpgsqlParameter("GroupingParamID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[2].Value = model.GroupingParamID;
aParams[3] = new NpgsqlParameter("IsSubmitted", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[3].Value = model.IsSubmitted;
aParams[4] = new NpgsqlParameter("OptionalParameterID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = model.OptionalParameterID;
aParams[5] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = model.APID;
aParams[6] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[6].Value = DateTime.Now;
aParams[7] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[7].Value = 0;
aParams[8] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[8].Value = true;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateOptionalParameters, aParams);
if (res > 0)
{
result.Status = Status.Success;
}
else
{
result.Status = Status.Failure;
}
}
catch (Exception Ex)
{
dbOps.Abort();
result.Status = Status.Failure;
}
return(result);
}
public OptionalParametersViewModel GetOptionalParemetersByAPID(int _apid)
{
DBOperations dbOps = new DBOperations();
OptionalParametersViewModel obj = null;
try
{
//dbOps.ProcName = AppConstants.USP_GETINSTALLATIONPARAMETERSBYID;
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_apid", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = _apid;
dbOps.ExecuteReader(AppConstants.usp_GETOPTIONALPARAMETERSBYAPID, aParams);
//dbOps.ExecuteReader(_id);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
obj = new OptionalParametersViewModel
{
OptionalParameterID = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
CallSignID = Helper.HandleDBNull <int>(dbOps.DataReader[1]),
CbsdInfoID = Helper.HandleDBNull <int>(dbOps.DataReader[2]),
GroupingParamID = Helper.HandleDBNull <int>(dbOps.DataReader[3]),
IsActive = Helper.HandleDBNull <bool>(dbOps.DataReader[4]),
IsDeleted = Helper.HandleDBNull <bool>(dbOps.DataReader[5]),
IsSubmitted = Helper.HandleDBNull <bool>(dbOps.DataReader[6]),
APID = Helper.HandleDBNull <int>(dbOps.DataReader[7])
};
}
}
}
return(obj);
}
catch (Exception Ex)
{
throw Ex;
}
}
//public Result AddOptionalParameters(OptionalParametersViewModel model)
//{
// Result result = new Result();
// DBOperations dbOps = new DBOperations();
// try
// {
// NpgsqlParameter[] aParams = new NpgsqlParameter[3];
// aParams[0] = new NpgsqlParameter("_callinfo", NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[0].Value = model.CallInfo;
// aParams[1] = new NpgsqlParameter("_cbsdinfo", NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[1].Value = model.CbsdInfo;
// aParams[2] = new NpgsqlParameter("_groupingParam", NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[2].Value = model.GroupingParam;
// dbOps.ExecuteScalar(AppConstants.USP_ADD_OPTIONALPARAMETERS, aParams);
// result.Message = dbOps.ReturnObject.ToString();
// result.Status = (dbOps.ReturnObject.ToString().ToLower().Contains("error")) ? Status.Failure : Status.Success;
// return result;
// }
// catch (Exception Ex)
// {
// dbOps.Abort();
// result.Status = Status.Failure;
// }
// return result;
//}
public Result AddOptionalParameters(OptionalParametersViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[6];
aParams[0] = new NpgsqlParameter("CallSignID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = model.CallSignID;
aParams[1] = new NpgsqlParameter("CbsdInfoID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = model.CbsdInfoID;
aParams[2] = new NpgsqlParameter("GroupingParamID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[2].Value = model.GroupingParamID;
aParams[3] = new NpgsqlParameter("IsSubmitted", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[3].Value = model.IsSubmitted;
aParams[4] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = model.APID;
aParams[5] = new NpgsqlParameter(AppConstants.CreatedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = 0;
int res = (int)dbOps.ExecuteScalar(AppConstants.QueryConstants.AddOptionalParameters, aParams);
if (res > 0)
{
result.Status = Status.Success;
result.Values = res.ToString();
}
else
{
result.Status = Status.Failure;
}
}
catch (Exception Ex)
{
dbOps.Abort();
result.Status = Status.Failure;
}
return(result);
}
