| public ExecuteNonQuery ( string queryString ) : int | ||
| queryString | string | |
| Résultat | int | |
public Result AddMainMenu(MainMenuViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[2];
aParams[0] = new NpgsqlParameter("Name", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[0].Value = model.Name;
aParams[1] = new NpgsqlParameter("CreatedBy", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = model.CreatedBy;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.AddMainMenu, 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);
}
public Result UpdatePassword(UserViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[2];
aParams[0] = new NpgsqlParameter("Password", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[0].Value = model.newpassword;
aParams[1] = new NpgsqlParameter("UserID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = model.UserID;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdatePassword, 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 Result UpdateFloor(FloorViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[12];
aParams[0] = new NpgsqlParameter("Name", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[0].Value = model.FloorName;
aParams[1] = new NpgsqlParameter("Description", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[1].Value = model.Description;
aParams[2] = new NpgsqlParameter("FloorPlanSHPPath", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[2].Value = model.FloorPlanSHPPath;
aParams[3] = new NpgsqlParameter("BuildingID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[3].Value = model.BuildingID;
aParams[4] = new NpgsqlParameter("FloorNo", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = model.FloorNo;
aParams[5] = new NpgsqlParameter("FloorPlanOrginalFileName", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[5].Value = model.FloorPlanOrginalFileName;
aParams[6] = new NpgsqlParameter("FloorID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[6].Value = model.FloorID;
aParams[7] = new NpgsqlParameter("Lat", NpgsqlTypes.NpgsqlDbType.Double);
aParams[7].Value = model.Latitude;
aParams[8] = new NpgsqlParameter("Long", NpgsqlTypes.NpgsqlDbType.Double);
aParams[8].Value = model.Longitude;
aParams[9] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[9].Value = DateTime.Now;
aParams[10] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[10].Value = 0;
aParams[11] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[11].Value = true;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateFloor, 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 Result UpdateCBSD(CBSDViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[10];
aParams[0] = new NpgsqlParameter("CBSDVendorModelID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = model.CBSDVendorModelID;
aParams[1] = new NpgsqlParameter("SoftwareVersion", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[1].Value = model.SoftwareVersion;
aParams[2] = new NpgsqlParameter("HardwareVersion", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[2].Value = model.HardwareVersion;
aParams[3] = new NpgsqlParameter("FirmwareVersion", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[3].Value = model.FirmwareVersion;
aParams[4] = new NpgsqlParameter("IsSubmitted", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[4].Value = model.IsSubmitted;
aParams[5] = new NpgsqlParameter("CBSDID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = model.CBSDID;
aParams[6] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[6].Value = model.APID;
aParams[7] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[7].Value = DateTime.Now;
aParams[8] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[8].Value = 0;
aParams[9] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[9].Value = true;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateCBSD, 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 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 Result DeleteAPSector(int apID)
//{
// Result result = new Result();
// DBOperations dbOps = new DBOperations();
// try
// {
// NpgsqlParameter[] aParams = new NpgsqlParameter[5];
// aParams[0] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
// aParams[0].Value = false;
// aParams[1] = new NpgsqlParameter("IsDeleted", NpgsqlTypes.NpgsqlDbType.Boolean);
// aParams[1].Value = true;
// aParams[2] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[2].Value = apID;
// aParams[3] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
// aParams[3].Value = DateTime.Now;
// aParams[4] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[4].Value = 0;
// int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.DeleteAPSector, 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 Result ReduceAPSector(int apID, string apSectorID)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[6];
aParams[0] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[0].Value = false;
aParams[1] = new NpgsqlParameter("IsDeleted", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[1].Value = true;
aParams[2] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[2].Value = apID;
aParams[3] = new NpgsqlParameter("APSectorID", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[3].Value = apSectorID;
aParams[4] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[4].Value = DateTime.Now;
aParams[5] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = 0;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.ReduceAPSector, 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 Result UpdateBuilding(BuildingViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[6];
aParams[0] = new NpgsqlParameter("Name", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[0].Value = model.Name;
aParams[1] = new NpgsqlParameter("Description", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[1].Value = model.Description;
aParams[2] = new NpgsqlParameter("BuildingID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[2].Value = model.BuildingId;
aParams[3] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[3].Value = DateTime.Now;
aParams[4] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = 0;
aParams[5] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[5].Value = true;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateBuilding, 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 Result DeleteMainMenu(int mainmenuID)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[5];
aParams[0] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[0].Value = false;
aParams[1] = new NpgsqlParameter("IsDeleted", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[1].Value = true;
aParams[2] = new NpgsqlParameter("MainMenuId", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[2].Value = mainmenuID;
aParams[3] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[3].Value = DateTime.Now;
aParams[4] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = 0;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.DeleteMainMenu, 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 Result UpdateAP(APViewModel model, bool isOutdoor = false)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams;
if (!isOutdoor)
{
aParams = new NpgsqlParameter[14];
}
else
{
aParams = new NpgsqlParameter[9];
}
aParams[0] = new NpgsqlParameter("Name", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[0].Value = model.Name;
aParams[1] = new NpgsqlParameter("Lat", NpgsqlTypes.NpgsqlDbType.Double);
aParams[1].Value = model.Lat;
aParams[2] = new NpgsqlParameter("Long", NpgsqlTypes.NpgsqlDbType.Double);
aParams[2].Value = model.Long;
aParams[3] = new NpgsqlParameter("Description", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[3].Value = model.Description;
aParams[4] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[4].Value = DateTime.Now;
aParams[5] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = 0;
aParams[6] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[6].Value = true;
if (isOutdoor)
{
aParams[7] = new NpgsqlParameter("APImagePath", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[7].Value = model.ImageSHPPath;
}
int i = 8;
if (!isOutdoor)
{
// aParams[8] = new NpgsqlParameter("FloorID", NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[8].Value = model.FloorID;
aParams[7] = new NpgsqlParameter("FloorID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[7].Value = model.FloorID;
aParams[8] = new NpgsqlParameter("APTypeID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[8].Value = model.APTypeID;
aParams[9] = new NpgsqlParameter("GroupID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[9].Value = model.GroupID;
aParams[10] = new NpgsqlParameter("IsIndoor", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[10].Value = true;
aParams[11] = new NpgsqlParameter("APimagepath", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[11].Value = model.ImageSHPPath;
aParams[12] = new NpgsqlParameter("SerialNo", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[12].Value = model.SerialNo;
i = 13;
}
aParams[i] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[i].Value = model.APID;
int res = 0;
if (!isOutdoor)
{
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateAP, aParams);
}
else
{
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateAPForOutdoor, 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 Result UpdateAPSector(APSectorViewModel model, bool isOutdoor = false)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams;
if (!isOutdoor)
{
aParams = new NpgsqlParameter[6];
}
else
{
aParams = new NpgsqlParameter[8];
}
aParams[0] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = model.APId;
aParams[1] = new NpgsqlParameter("SectorNumber", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = model.SectorNumber;
aParams[2] = new NpgsqlParameter("SectorValue", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[2].Value = model.SectorValue;
aParams[3] = new NpgsqlParameter("SerialNo", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[3].Value = model.SerialNumber;
aParams[4] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[4].Value = DateTime.Now;
aParams[5] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = 0;
aParams[6] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[6].Value = true;
int i = 7;
if (!isOutdoor)
{
//aParams[7] = new NpgsqlParameter("FloorID", NpgsqlTypes.NpgsqlDbType.Integer);
//aParams[7].Value = model.FloorID;
//i = 8;
}
aParams[i] = new NpgsqlParameter("APSectorId", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[i].Value = model.APSectorId;
int res = 0;
if (!isOutdoor)
{
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateAPSector, aParams);
}
else
{
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateAPSector, 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 Result AddAPSector(APSectorViewModel model, bool isOutdoor = false)
//{
// Result result = new Result();
// DBOperations dbOps = new DBOperations();
// try
// {
// NpgsqlParameter[] aParams;
// if (!isOutdoor)
// {
// aParams = new NpgsqlParameter[6];
// }
// else
// {
// aParams = new NpgsqlParameter[5];
// }
// aParams[0] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[0].Value = model.APId;
// aParams[1] = new NpgsqlParameter("SectorNumber", NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[1].Value = model.SectorNumber;
// aParams[2] = new NpgsqlParameter("SectorValue", NpgsqlTypes.NpgsqlDbType.Varchar);
// aParams[2].Value = model.SectorValue;
// aParams[3] = new NpgsqlParameter("SerialNo", NpgsqlTypes.NpgsqlDbType.Varchar);
// aParams[3].Value = model.SerialNumber;
// aParams[4] = new NpgsqlParameter(AppConstants.CreatedBy, NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[4].Value = 0;
// //if (!isOutdoor)
// //{
// // aParams[5] = new NpgsqlParameter("FloorID", NpgsqlTypes.NpgsqlDbType.Integer);
// // aParams[5].Value = model.FloorID;
// //}
// int res = 0;
// if (!isOutdoor)
// {
// res = (int)dbOps.ExecuteNonQuery(AppConstants.QueryConstants.AddAP, aParams);
// }
// else
// {
// res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.AddAPSector, 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 Result AddAPSector(APSectorViewModel model, bool isOutdoor = false)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams;
if (!isOutdoor)
{
aParams = new NpgsqlParameter[6];
}
else
{
aParams = new NpgsqlParameter[5];
}
aParams[0] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = model.APId;
aParams[1] = new NpgsqlParameter("SectorNumber", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = model.SectorNumber;
aParams[2] = new NpgsqlParameter("SectorValue", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[2].Value = model.SectorValue;
aParams[3] = new NpgsqlParameter("SerialNo", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[3].Value = model.SerialNumber;
aParams[4] = new NpgsqlParameter(AppConstants.CreatedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = 0;
//if (!isOutdoor)
//{
// aParams[5] = new NpgsqlParameter("FloorID", NpgsqlTypes.NpgsqlDbType.Integer);
// aParams[5].Value = model.FloorID;
//}
int res = 0;
if (!isOutdoor)
{
res = (int)dbOps.ExecuteNonQuery(AppConstants.QueryConstants.AddAPSector, aParams);
}
else
{
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.AddAPSector, 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 Result UpdateInstallationParameters(InstallationParametersViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[19];
//aParams[0] = new NpgsqlParameter("LatLong", NpgsqlTypes.NpgsqlDbType.Geometry);
//aParams[0].Value = "ST_GeomFromText('POINT(" + model.Latitude + " " + model.Longitude + ")', 4326)";
aParams[0] = new NpgsqlParameter("Lat", NpgsqlTypes.NpgsqlDbType.Double);
aParams[0].Value = model.Latitude;
aParams[1] = new NpgsqlParameter("Long", NpgsqlTypes.NpgsqlDbType.Double);
aParams[1].Value = model.Longitude;
aParams[2] = new NpgsqlParameter("Height", NpgsqlTypes.NpgsqlDbType.Numeric);
aParams[2].Value = model.Height;
aParams[3] = new NpgsqlParameter("HeightTypeID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[3].Value = model.HeightTypeID;
aParams[4] = new NpgsqlParameter("HorizontalAccuracy", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = model.HorizontalAccuracy;
aParams[5] = new NpgsqlParameter("VerticalAccuracy", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = model.VerticalAccuracy;
aParams[6] = new NpgsqlParameter("IndoorDeployment", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[6].Value = model.IndoorDeployment;
aParams[7] = new NpgsqlParameter("AntennaAzimuth", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[7].Value = model.AntennaAzimuth;
aParams[8] = new NpgsqlParameter("AntennaDowntilt", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[8].Value = model.AntennaDowntilt;
aParams[9] = new NpgsqlParameter("AntennaGain", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[9].Value = model.AntennaGain;
aParams[10] = new NpgsqlParameter("EirpCapability", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[10].Value = model.EripCapability;
aParams[11] = new NpgsqlParameter("AntennaBeamwidth", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[11].Value = model.AntennaBeamwidth;
aParams[12] = new NpgsqlParameter("AntennaModelID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[12].Value = model.AntennaModelID;
aParams[13] = new NpgsqlParameter("IsSubmitted", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[13].Value = model.IsSubmitted;
aParams[14] = new NpgsqlParameter("InstallationParameterID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[14].Value = model.InstallationParamterID;
aParams[15] = new NpgsqlParameter("APID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[15].Value = model.APID;
aParams[16] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[16].Value = DateTime.Now;
aParams[17] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[17].Value = 0;
aParams[18] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[18].Value = true;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateInstallationParameters, aParams);
if (res > 0)
{
result.Status = Status.Success;
}
else
{
result.Status = Status.Failure;
}
}
catch (Exception Ex)
{
dbOps.Abort();
result.Status = Status.Failure;
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
dbOps = DBOperations.Instance;
links = Links.Instance;
general = General.Instance;
categories = Categories.Instance;
engine = ProcessingEngine.Instance;
log = Logger.Instance;
UID = string.Empty;
url = string.Empty;
// log.Log("PathInfo: " + Request.PathInfo);
#region CookieAlreadyExists
// START: If a getputsCookie with the Username already exists, do not show the Login Page.
if (Request.Cookies["getputsCookie"] != null)
{
HttpCookie getputsCookie = Request.Cookies["getputsCookie"];
UID = dbOps.Decrypt(getputsCookie["UID"].ToString().Trim());
}
if (string.IsNullOrEmpty(UID))
{
Response.Redirect(links.LoginLink);
}
else
{
}
// END: If a getputsCookie with the Username already exists, do not show the Login Page.
#endregion CookieAlreadyExists
// Update the SavedItems DB
if (!string.IsNullOrEmpty(UID) && !string.IsNullOrEmpty(Request.QueryString["iid"]))
{
string IID = Request.QueryString["iid"];
// Make sure that the IID is a valid integer.
if (general.IsValidInt(IID))
{
string date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string queryString = "INSERT INTO saveditems VALUES ('" + UID + "' , " + IID + " , '" + date + "');";
int retInt = dbOps.ExecuteNonQuery(queryString);
// Also update the getputs.item NSaved Field.
queryString = "UPDATE item SET NSaved=NSaved+1 WHERE IID=" + IID + ";";
retInt = dbOps.ExecuteNonQuery(queryString);
Response.Redirect(Context.Request.UrlReferrer.OriginalString);
}
else
{
Response.Redirect(links.FrontPageLink);
}
}
else
{
Response.Redirect(links.FrontPageLink);
}
}
public Result SaveRoleNRights(ManageRoleNRightsViewModel manageRoleNRightsViewModel)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
foreach (var item in manageRoleNRightsViewModel.RolesNRightsViewMdoels)
{
int res;
NpgsqlParameter[] aParams1 = new NpgsqlParameter[1];
aParams1[0] = new NpgsqlParameter("RNRID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams1[0].Value = item.RNRID;
long count = (long)dbOps.ExecuteScalar(AppConstants.QueryConstants.CheckRolesNRights, aParams1);
if (count > 0)
{
NpgsqlParameter[] aParams = new NpgsqlParameter[6];
aParams[0] = new NpgsqlParameter("RoleID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = manageRoleNRightsViewModel.RoleID;
aParams[1] = new NpgsqlParameter("ActionID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = item.ActionID;
aParams[2] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[2].Value = item.IsActive;
aParams[3] = new NpgsqlParameter("LastModifiedBy", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[3].Value = 0;
aParams[4] = new NpgsqlParameter("LastModifiedOn", NpgsqlTypes.NpgsqlDbType.Date);
aParams[4].Value = DateTime.Now;
aParams[5] = new NpgsqlParameter("RNRID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = item.RNRID;
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateRolesNRights, aParams);
}
else
{
NpgsqlParameter[] aParams = new NpgsqlParameter[5];
aParams[0] = new NpgsqlParameter("RoleID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = manageRoleNRightsViewModel.RoleID;
aParams[1] = new NpgsqlParameter("ActionID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = item.ActionID;
aParams[2] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[2].Value = item.IsActive;
aParams[3] = new NpgsqlParameter("CreatedBy", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[3].Value = 0;
aParams[4] = new NpgsqlParameter("CreatedOn", NpgsqlTypes.NpgsqlDbType.Date);
aParams[4].Value = DateTime.Now;
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.AddRolesNRights, 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);
}
