|
public ExecuteReader ( string queryString ) : |
||
| queryString | string | |
| return | ||
public static List <SelectListItem> GetDropDownWithAnotherDropDown(string ProcName, long Id = 0, string selectedValues = "")
{
DBOperations pobjSqlHelper = new DBOperations();
List <SelectListItem> bindDropDownList = new List <SelectListItem>();
try
{
pobjSqlHelper.ProcName = ProcName;
if (Id != 0 && selectedValues != "")
{
pobjSqlHelper.ExecuteReader(Id, selectedValues);
}
else
{
pobjSqlHelper.ExecuteReader();
}
if (!(pobjSqlHelper.DataReader == null))
{
while (pobjSqlHelper.DataReader.Read())
{
bindDropDownList.Add(DoBindDropDownList(pobjSqlHelper.DataReader));
}
}
return(bindDropDownList);
}
catch (Exception Ex)
{
throw Ex;
}
}
internal void fillOrderTypes()
{
orderType = dbOps.ExecuteReader(DB.DB_Conn,
dbSQL.sqlFillCookieOrderTypes,
CommandType.Text);
while (orderType.Read())
{
cboOrderType.Items.Add(orderType.GetValue(0));
}
}
internal void fillTroop()
{
SqlDataReader troop;
troop = dbOps.ExecuteReader(DB.DB_Conn,
dbSQL.sqlFillTroop,
CommandType.Text);
while (troop.Read())
{
cboTroop.Items.Add(troop.GetValue(0));
}
}
public List <MainMenuViewModel> GetMainMenus()
{
DBOperations dbOps = new DBOperations();
List <MainMenuViewModel> objs = new List <MainMenuViewModel>();
try
{
dbOps.ProcName = AppConstants.USP_GETMAINMENUS;
dbOps.ExecuteReader();
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
MainMenuViewModel obj = new MainMenuViewModel
{
MainMenuId = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
Name = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
};
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
public List <BuildingViewModel> GetBuildings()
{
DBOperations dbOps = new DBOperations();
List <BuildingViewModel> objs = new List <BuildingViewModel>();
try
{
dbOps.ProcName = AppConstants.USP_GETBUILDINGS;
dbOps.ExecuteReader();
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
BuildingViewModel obj = new BuildingViewModel
{
BuildingId = Helper.HandleDBNull <int>(dbOps.DataReader[8]),
Name = Helper.HandleDBNull <string>(dbOps.DataReader[0]),
Description = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
};
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
/// <summary>
/// CreatedBy : suhel
/// CreatedDate :03/01/2019
/// Summary : Bind Drop Down List
/// </summary>
/// <param name="ProcName"></param>
/// <param name="Id"></param>
/// <returns></returns>
public static List <SelectListItem> GetDropDown(string ProcName, long Id = 0, string selectedText = "SELECT", long mode = 0)
{
DBOperations dbOps = new DBOperations();
List <SelectListItem> bindDropDownList = new List <SelectListItem>();
try
{
dbOps.ProcName = ProcName;
if (Id != 0 && mode != 0)
{
dbOps.ExecuteReader(Id, mode);
}
else if (Id != 0)
{
dbOps.ExecuteReader(Id);
}
else if (mode != 0)
{
dbOps.ExecuteReader(Id, mode);
}
else
{
dbOps.ExecuteReader();
}
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
bindDropDownList.Add(DoBindDropDownList(dbOps.DataReader));
// CompanyDropDownList.Add( DoBindCompanyDropDownList(dbOps.DataReader));
}
}
}
bindDropDownList.Insert(0, new SelectListItem {
Value = "0", Text = "-- " + selectedText + " --"
});
return(bindDropDownList);
}
catch (Exception Ex)
{
throw Ex;
}
}
public static List <SelectListItem> GetDropDown(string ProcName, long Id = 0, long ddlSelectedValue = 0, string selectedValues = "")
{
DBOperations dbOps = new DBOperations();
List <SelectListItem> bindDropDownList = new List <SelectListItem>();
try
{
dbOps.ProcName = ProcName;
if (Id != 0 && ddlSelectedValue != 0)
{
dbOps.ExecuteReader(Id, ddlSelectedValue);
}
else if (Id != 0 && selectedValues == "")
{
dbOps.ExecuteReader(Id);
}
else if (selectedValues != "")
{
dbOps.ExecuteReader(selectedValues);
}
else
{
dbOps.ExecuteReader();
}
if (!(dbOps.DataReader == null))
{
while (dbOps.DataReader.Read())
{
bindDropDownList.Add(DoBindDropDownList(dbOps.DataReader));
// CompanyDropDownList.Add( DoBindCompanyDropDownList(pobjSqlHelper.DataReader));
}
}
//bindDropDownList.Insert(0, new SelectListItem { Value = "0", Text = "-- " + selectedText + "--" });
return(bindDropDownList);
}
catch (Exception Ex)
{
throw Ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
engine = ProcessingEngine.Instance;
dbOps = DBOperations.Instance;
links = Links.Instance;
Random random = new Random();
bool isDone = false;
string link = string.Empty;
//string queryString = "SELECT COUNT(*) FROM item WHERE Spam = 0;";
//int retInt = dbOps.ExecuteScalar(queryString);
int retInt = engine.ItemRowCount;
if (retInt > 0)
{
int rowCount = retInt;
int rowNumber = random.Next(0, rowCount);
while (!isDone)
{
string queryString = "SELECT Link FROM item WHERE Spam = 0 AND IID = " + rowNumber + ";";
MySqlDataReader retList = dbOps.ExecuteReader(queryString);
if (retList != null && retList.HasRows)
{
// DB Hit.
while (retList.Read())
{
link = Convert.ToString(retList["Link"]);
}
retList.Close();
isDone = true;
}
else
{
// DB Miss. Select another random number.
rowNumber = random.Next(0, rowCount);
}
}
if (isDone && !string.IsNullOrEmpty(link))
{
Response.Redirect(link, true);
}
}
else
{
// Not decided what to do.
// May be redirect back to getputs.
Response.Redirect(links.FrontPageLink, true);
}
}
private void fillStatesCombo()
{
stateList = dbOps.ExecuteReader(DB.DB_Conn,
dbSQL.sqlFillStates,
CommandType.Text);
while (stateList.Read())
{
cboState.Items.Add(stateList.GetValue(0));
}
}
public InstallationParametersViewModel GetInstallationParemetersByAPID(int apid)
{
DBOperations dbOps = new DBOperations();
InstallationParametersViewModel 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_GETINSTALLATIONPARAMETERSBYAPID, aParams);
//dbOps.ExecuteReader(_id);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
obj = new InstallationParametersViewModel
{
InstallationParamterID = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
Latitude = Helper.HandleDBNull <double>(dbOps.DataReader[1]),
Longitude = Helper.HandleDBNull <double>(dbOps.DataReader[2]),
Height = Helper.HandleDBNull <decimal>(dbOps.DataReader[3]),
HeightTypeID = Helper.HandleDBNull <int>(dbOps.DataReader[4]),
HorizontalAccuracy = Helper.HandleDBNull <int>(dbOps.DataReader[5]),
VerticalAccuracy = Helper.HandleDBNull <int>(dbOps.DataReader[6]),
IndoorDeployment = Helper.HandleDBNull <bool>(dbOps.DataReader[7]),
AntennaAzimuth = Helper.HandleDBNull <int>(dbOps.DataReader[8]),
AntennaDowntilt = Helper.HandleDBNull <int>(dbOps.DataReader[9]),
AntennaGain = Helper.HandleDBNull <int>(dbOps.DataReader[10]),
EripCapability = Helper.HandleDBNull <int>(dbOps.DataReader[11]),
AntennaBeamwidth = Helper.HandleDBNull <int>(dbOps.DataReader[12]),
AntennaModelID = Helper.HandleDBNull <int>(dbOps.DataReader[13]),
IsActive = Helper.HandleDBNull <bool>(dbOps.DataReader[14]),
IsDeleted = Helper.HandleDBNull <bool>(dbOps.DataReader[15]),
APID = Helper.HandleDBNull <int>(dbOps.DataReader[16])
};
}
}
}
return(obj);
}
catch (Exception Ex)
{
throw Ex;
}
}
private void fillCombo()
{
SqlDataReader dataType;
string sql = String.Empty;
string msg = String.Empty;
sql = dbSQL.sqlFillCustomer;
msg = sysMessages.msgNoActiveCustomer;
dataType = dbOps.ExecuteReader(DB.DB_Conn, sql, CommandType.Text);
while (dataType.Read())
{
cboRecords.Items.Add(dataType.GetValue(0));
}
if (cboRecords.Items.Count == 0)
{
lblNoActiveRecord.Text = msg;
lblNoActiveRecord.Visible = true;
}
}
public List <FloorViewModel> GetFloorsByBuildingID(int _id)
{
DBOperations dbOps = new DBOperations();
List <FloorViewModel> objs = new List <FloorViewModel>();
try
{
//dbOps.ProcName = AppConstants.USP_GETINSTALLATIONPARAMETERSBYID;
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_id", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = _id;
dbOps.ExecuteReader(AppConstants.USP_GETFLOORSBYBUILDINGID, aParams);
//dbOps.ExecuteReader(_id);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
FloorViewModel obj = new FloorViewModel
{
FloorID = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
FloorName = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
FloorPlanSHPPath = Helper.HandleDBNull <string>(dbOps.DataReader[2]),
FloorNo = Helper.HandleDBNull <int>(dbOps.DataReader[3]),
FloorPlanOrginalFileName = Helper.HandleDBNull <string>(dbOps.DataReader[4]),
Latitude = Helper.HandleDBNull <double>(dbOps.DataReader[5]),
Longitude = Helper.HandleDBNull <double>(dbOps.DataReader[6]),
Description = Helper.HandleDBNull <string>(dbOps.DataReader[7]),
BuildingID = Helper.HandleDBNull <int>(dbOps.DataReader[8])
};
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
public List <APViewModel> GetAPByFloorID(int floorID)
{
DBOperations dbOps = new DBOperations();
List <APViewModel> objs = new List <APViewModel>();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_floorid", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = floorID;
dbOps.ExecuteReader(AppConstants.usp_GETAPSBYFLOORID, aParams);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
APViewModel obj = new APViewModel
{
APID = Helper.HandleDBNull <Int32>(dbOps.DataReader[0]),
Name = Helper.HandleDBNull <String>(dbOps.DataReader[1]),
Lat = Helper.HandleDBNull <double>(dbOps.DataReader[2]),
Long = Helper.HandleDBNull <double>(dbOps.DataReader[3]),
Description = Helper.HandleDBNull <String>(dbOps.DataReader[4]),
FloorID = Helper.HandleDBNull <int>(dbOps.DataReader[5]),
ImageSHPPath = Helper.HandleDBNull <String>(dbOps.DataReader[6]),
APTypeID = Helper.HandleDBNull <int>(dbOps.DataReader[7]),
GroupID = Helper.HandleDBNull <int>(dbOps.DataReader[8]),
SerialNo = Helper.HandleDBNull <string>(dbOps.DataReader[9]),
};
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
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 CBSDViewModel GetCBSDByID(int _id)
{
DBOperations dbOps = new DBOperations();
CBSDViewModel obj = null;
try
{
//dbOps.ProcName = AppConstants.USP_GETINSTALLATIONPARAMETERSBYID;
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_id", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = _id;
dbOps.ExecuteReader(AppConstants.USP_GETCBSDBYID, aParams);
//dbOps.ExecuteReader(_id);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
obj = new CBSDViewModel
{
SoftwareVersion = Helper.HandleDBNull <string>(dbOps.DataReader[0]),
HardwareVersion = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
FirmwareVersion = Helper.HandleDBNull <string>(dbOps.DataReader[2]),
CBSDID = 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]),
CBSDVendorModelID = Helper.HandleDBNull <int>(dbOps.DataReader[7]),
};
}
}
}
return(obj);
}
catch (Exception Ex)
{
throw Ex;
}
}
public BuildingViewModel GetBuildingByID(int _id)
{
DBOperations dbOps = new DBOperations();
BuildingViewModel obj = null;
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_id", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = _id;
dbOps.ExecuteReader(AppConstants.USP_GETBUILDINGBYID, aParams);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
obj = new BuildingViewModel
{
Name = Helper.HandleDBNull <string>(dbOps.DataReader[0]),
Description = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
IsActive = Helper.HandleDBNull <Boolean>(dbOps.DataReader[2]),
IsDeleted = Helper.HandleDBNull <Boolean>(dbOps.DataReader[3]),
CreatedOn = Helper.HandleDBNull <DateTime>(dbOps.DataReader[4]),
CreatedBy = Helper.HandleDBNull <Int32>(dbOps.DataReader[5]),
LastModifiedOn = Helper.HandleDBNull <DateTime>(dbOps.DataReader[6]),
LastModifiedBy = Helper.HandleDBNull <Int32>(dbOps.DataReader[7]),
BuildingId = Helper.HandleDBNull <int>(dbOps.DataReader[8])
};
}
}
}
return(obj);
}
catch (Exception Ex)
{
throw Ex;
}
}
public UserViewModel GetValidUserByEmail(UserViewModel model)
{
UserViewModel result = new UserViewModel();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_emailaddress", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[0].Value = model.EmailAddress;
dbOps.ExecuteReader(AppConstants.USP_GETVALIDUSERBYEMAIL, aParams);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
result = new UserViewModel
{
UserID = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
RoleID = Helper.HandleDBNull <int>(dbOps.DataReader[1]),
EmailAddress = Helper.HandleDBNull <string>(dbOps.DataReader[2]),
password = Helper.HandleDBNull <string>(dbOps.DataReader[3])
};
}
}
}
//Query to get User record and store it in result
}
catch (Exception Ex)
{
dbOps.Abort();
}
return(result);
}
public List <APViewModel> GetAPByOutdoorMasterID(int?floorID)
{
DBOperations dbOps = new DBOperations();
List <APViewModel> objs = new List <APViewModel>();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_outdoormasterid", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = floorID;
dbOps.ExecuteReader(AppConstants.usp_GETAPSBYOutdoorMasterID, aParams);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
APViewModel obj = new APViewModel
{
APID = Helper.HandleDBNull <Int32>(dbOps.DataReader[0]),
Name = Helper.HandleDBNull <String>(dbOps.DataReader[1]),
Lat = Helper.HandleDBNull <double>(dbOps.DataReader[2]),
Long = Helper.HandleDBNull <double>(dbOps.DataReader[3]),
Description = Helper.HandleDBNull <String>(dbOps.DataReader[4]),
ImageSHPPath = Helper.HandleDBNull <String>(dbOps.DataReader[5]),
listAPSector = GetAPSectorByOutdoorAPID(Helper.HandleDBNull <Int32>(dbOps.DataReader[0]))
};
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
public APViewModel GetAPByID(int _id)
{
DBOperations dbOps = new DBOperations();
APViewModel obj = null;
try
{
//dbOps.ProcName = AppConstants.USP_GETINSTALLATIONPARAMETERSBYID;
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_id", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = _id;
dbOps.ExecuteReader(AppConstants.USP_GETAPBYID, aParams);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
obj = new APViewModel
{
APID = Helper.HandleDBNull <Int32>(dbOps.DataReader[0]),
Name = Helper.HandleDBNull <String>(dbOps.DataReader[1]),
Lat = Helper.HandleDBNull <double>(dbOps.DataReader[2]),
Long = Helper.HandleDBNull <double>(dbOps.DataReader[3]),
Description = Helper.HandleDBNull <String>(dbOps.DataReader[4]),
FloorID = Helper.HandleDBNull <int>(dbOps.DataReader[5]),
};
}
}
}
return(obj);
}
catch (Exception Ex)
{
throw Ex;
}
}
public List <FloorViewModel> GetFloorsForIndoor()
{
DBOperations dbOps = new DBOperations();
List <FloorViewModel> objs = new List <FloorViewModel>();
try
{
dbOps.ProcName = AppConstants.USP_GETFLOORSFORINDOOR;
dbOps.ExecuteReader();
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
FloorViewModel obj = new FloorViewModel
{
FloorID = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
FloorName = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
FloorPlanSHPPath = Helper.HandleDBNull <string>(dbOps.DataReader[2]),
FloorNo = Helper.HandleDBNull <int>(dbOps.DataReader[3]),
FloorPlanOrginalFileName = Helper.HandleDBNull <string>(dbOps.DataReader[4]),
Latitude = Helper.HandleDBNull <double>(dbOps.DataReader[5]),
Longitude = Helper.HandleDBNull <double>(dbOps.DataReader[6]),
Description = Helper.HandleDBNull <string>(dbOps.DataReader[7]),
BuildingID = Helper.HandleDBNull <int>(dbOps.DataReader[8])
};
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
public List <APSectorViewModel> GetAPSectorByOutdoorAPID(int?apID)
{
DBOperations dbOps = new DBOperations();
List <APSectorViewModel> objs = new List <APSectorViewModel>();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_outdoorapid", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = apID;
dbOps.ExecuteReader(AppConstants.usp_GetAPSectorByOutdoorAPID, aParams);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
APSectorViewModel obj = new APSectorViewModel
{
APSectorId = Helper.HandleDBNull <Int32>(dbOps.DataReader[0]),
APId = Helper.HandleDBNull <Int32>(dbOps.DataReader[1]),
SectorNumber = Helper.HandleDBNull <Int32>(dbOps.DataReader[2]),
SectorValue = Helper.HandleDBNull <String>(dbOps.DataReader[3]),
SerialNumber = Helper.HandleDBNull <String>(dbOps.DataReader[4])
};
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
// ItemDisplayer.ItemLayoutOptions itemLayoutOptions = ItemDisplayer.ItemLayoutOptions.Columns;
// ItemDisplayer.ItemLayoutOptions itemLayoutOptions = ItemDisplayer.ItemLayoutOptions.Categorized;
protected void Page_Load(object sender, EventArgs e)
{
dbOps = DBOperations.Instance;
links = Links.Instance;
general = General.Instance;
gui = GUIVariables.Instance;
categories = Categories.Instance;
engine = ProcessingEngine.Instance;
imageEngine = ImageEngine.Instance;
itemDisplayer = ItemDisplayer.Instance;
seperator = gui.Seperator;
MyAccountLink.Visible = false;
if (!string.IsNullOrEmpty(Request.QueryString["startItem"]))
{
bool isStartItemInt = int.TryParse(Request.QueryString["startItem"].Trim(), out startItem);
if (!isStartItemInt)
{
startItem = 0;
}
if (startItem < 0)
{
startItem = 0;
}
}
else
{
startItem = 0;
}
if (!string.IsNullOrEmpty(Request.QueryString["sort"]))
{
string sortStr = Convert.ToString(Request.QueryString["sort"]);
sort = engine.GetSortType(sortStr);
}
if (Request.Cookies["getputsLayoutCookie"] != null)
{
HttpCookie getputsLayoutCookie = Request.Cookies["getputsLayoutCookie"];
itemLayoutOptions = itemDisplayer.GetItemLayoutOptionsType(dbOps.Decrypt(getputsLayoutCookie["layout"].ToString().Trim()));
}
#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.FrontPageLink, false);
}
else
{
string queryString = "SELECT PreferredCategories FROM user WHERE UID='" + UID + "';";
MySqlDataReader retList = dbOps.ExecuteReader(queryString);
string prefferedCategoriesStr = string.Empty;
if (retList != null && retList.HasRows)
{
while (retList.Read())
{
prefferedCategoriesStr = Convert.ToString(retList["PreferredCategories"]);
}
retList.Close();
}
if (string.IsNullOrEmpty(prefferedCategoriesStr))
{
MessageLabel.Text = "Please visit the My Account Page and select the Categories that you would like to read more news from.";
MyAccountLink.Visible = true;
MyAccountLink.NavigateUrl = links.UserDetailsPageLink + "?UID=" + UID;
}
else
{
MyAccountLink.Visible = false;
List<string> preferredCategoriesList = GetPreferredCategoriesList(prefferedCategoriesStr);
List<Item> itemList = LoadItemDB(sort, preferredCategoriesList);
if (itemList != null && itemList.Count > 0)
{
MessageLabel.Text = gui.GreenFontStart + "Personalized Items for " + gui.GreenFontEnd + gui.BlueFontStart + UID + gui.BlueFontEnd;
// LoadItemTable(itemList);
ItemDisplayer.ShowItemsOptions itemOptions = ItemDisplayer.ShowItemsOptions.ShowUIDLink
| ItemDisplayer.ShowItemsOptions.ShowTime
| ItemDisplayer.ShowItemsOptions.ShowCategoryLink
| ItemDisplayer.ShowItemsOptions.ShowSaveLink
| ItemDisplayer.ShowItemsOptions.ShowEMailLink
| ItemDisplayer.ShowItemsOptions.ShowCommentsLink
| ItemDisplayer.ShowItemsOptions.ShowImage
| ItemDisplayer.ShowItemsOptions.ShowRatings
| ItemDisplayer.ShowItemsOptions.ShowTags
| ItemDisplayer.ShowItemsOptions.CountClicks
| ItemDisplayer.ShowItemsOptions.ShowPreviousNextLinks;
string itemTable = itemDisplayer.LoadItemTable(itemList, itemOptions, itemLayoutOptions, startItem, UID, sort, links.MyNewsPageLink.Replace("~\\", ""));
ItemDiv.InnerHtml = itemTable;
}
else
{
MessageLabel.Text = "getputs did not find anything worth your attention today!";
}
}
}
// END: If a getputsCookie with the Username already exists, do not show the Login Page.
#endregion CookieAlreadyExists
}
protected void Page_Load(object sender, EventArgs e)
{
//UserDetailsLabel.Visible = false;
//UpdateUserDetailsTable.Visible = false;
InterestsCBL.Visible = false;
AddButton.Visible = false;
SaveChangesLabel.Visible = false;
dbOps = DBOperations.Instance;
links = Links.Instance;
general = General.Instance;
gui = GUIVariables.Instance;
engine = ProcessingEngine.Instance;
categories = Categories.Instance;
if (string.IsNullOrEmpty(Request.QueryString["UID"]))
{
}
else
{
queryStringUID = Request.QueryString["UID"].Trim().ToLower();
}
if (string.IsNullOrEmpty(queryStringUID))
{
UserDetailsLabel.Visible = false;
UpdateUserDetailsTable.Visible = false;
SubmittedLB.Visible = false;
CommentedLB.Visible = false;
}
else
{
UserDetailsLabel.Visible = true;
UpdateUserDetailsTable.Visible = false;
string userDetails = string.Empty;
StringBuilder returnSB = new StringBuilder();
string date = string.Empty;
string eMail = string.Empty;
string about = string.Empty;
string queryString = "SELECT Date, EMail, About FROM getputs.user where UID='" + queryStringUID + "';";
MySqlDataReader retList = dbOps.ExecuteReader(queryString);
if (retList != null && retList.HasRows)
{
while (retList.Read())
{
date = Convert.ToString(retList["Date"]);
eMail = Convert.ToString(retList["EMail"]);
about = Convert.ToString(retList["About"]);
date = general.GetFormattedDate(date);
returnSB.AppendLine(gui.GrayFontStart + "User: "******"Created: " + gui.GrayFontEnd + date);
returnSB.AppendLine(gui.LineBreak);
// // Keep E-Mail Private.
// returnSB.AppendLine(gui.GrayFontStart + "EMail: " + gui.GrayFontEnd + eMail);
// returnSB.AppendLine(gui.LineBreak);
returnSB.AppendLine(gui.GrayFontStart + "About: " + gui.GrayFontEnd + about);
userDetails = returnSB.ToString();
}
retList.Close();
}
if (string.IsNullOrEmpty(userDetails))
{
userDetails = gui.RedFontStart + "No such user found." + gui.RedFontEnd;
SubmittedLB.Visible = false;
CommentedLB.Visible = false;
SavedLB.Visible = false;
RatedLB.Visible = false;
}
UserDetailsLabel.Text = userDetails;
}
if (Request.Cookies["getputsCookie"] != null)
{
HttpCookie getputsCookie = Request.Cookies["getputsCookie"];
loggedUID = dbOps.Decrypt(getputsCookie["UID"].ToString().Trim());
if (string.IsNullOrEmpty(loggedUID))
{
UpdateUserDetailsTable.Visible = false;
}
else if (loggedUID.Equals(queryStringUID))
{
UserDetailsLabel.Visible = false;
UpdateUserDetailsTable.Visible = true;
InterestsCBL.Visible = true;
AddButton.Visible = true;
SaveChangesLabel.Visible = true;
if (!IsPostBack)
{
GetPreferredCategories(loggedUID);
StringBuilder returnSB = new StringBuilder();
string date = string.Empty;
string eMail = string.Empty;
string about = string.Empty;
string queryString = "SELECT Date, EMail, About FROM getputs.user where UID='" + loggedUID + "';";
MySqlDataReader retList = dbOps.ExecuteReader(queryString);
if (retList != null && retList.HasRows)
{
while (retList.Read())
{
date = Convert.ToString(retList["Date"]);
eMail = Convert.ToString(retList["EMail"]);
about = Convert.ToString(retList["About"]);
date = general.GetFormattedDate(date);
UserLabelR.Text = loggedUID;
CreatedLabelR.Text = date;
AboutTB.Text = about;
EMailTB.Text = eMail;
}
retList.Close();
}
}
}
}
// Whether to show the SavedLB or not.
if (!string.IsNullOrEmpty(queryStringUID) && !string.IsNullOrEmpty(loggedUID))
{
if (queryStringUID.Equals(loggedUID))
{
SavedLB.Visible = true;
RatedLB.Visible = true;
}
else
{
SavedLB.Visible = false;
RatedLB.Visible = false;
}
}
else
{
SavedLB.Visible = false;
RatedLB.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
dbOps = DBOperations.Instance;
links = Links.Instance;
general = General.Instance;
gui = GUIVariables.Instance;
engine = ProcessingEngine.Instance;
imageEngine = ImageEngine.Instance;
seperator = gui.Seperator;
if (string.IsNullOrEmpty(Request.QueryString["IID"]))
{
EMailDiv.Visible = false;
ItemTitleLabel.Text = "No such item found.";
}
else
{
iid = Request.QueryString["IID"].Trim().ToLower();
}
if (!general.IsValidInt(iid))
{
EMailDiv.Visible = false;
}
else
{
item = new Item();
string queryString = "SELECT Title, Link, Text, Date, UID, NComments, Category FROM item WHERE IID=" + iid + ";";
MySqlDataReader retList;
retList = dbOps.ExecuteReader(queryString);
if (retList != null && retList.HasRows)
{
while (retList.Read())
{
item.IID = Convert.ToInt32(iid);
item.UID = Convert.ToString(retList["UID"]);
item.Title = Convert.ToString(retList["Title"]);
item.Link = Convert.ToString(retList["Link"]);
item.Text = Convert.ToString(retList["Text"]);
item.Date = Convert.ToString(retList["Date"]);
item.NComments = Convert.ToInt32(retList["NComments"]);
item.Category = Convert.ToString(retList["Category"]);
if (!string.IsNullOrEmpty(item.Link))
{
item.Text = string.Empty;
}
}
retList.Close();
}
ItemTitleLabel.Text = "Title: " + gui.GrayFontStart + item.Title + gui.GrayFontEnd;
}
#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"];
user = dbOps.Decrypt(getputsCookie["UID"].ToString().Trim());
}
if (string.IsNullOrEmpty(user))
{
}
else
{
}
// END: If a getputsCookie with the Username already exists, do not show the Login Page.
#endregion CookieAlreadyExists
// If the user has logged in, populate the 'EMail From' TextBox.
// The variable 'user' = Logged in User.
EMailOutputMessageLabel.Text = string.Empty;
if (!string.IsNullOrEmpty(user))
{
string queryString = "SELECT EMail FROM user WHERE UID='" + user + "';";
MySqlDataReader retList = dbOps.ExecuteReader(queryString);
if (retList != null && retList.HasRows)
{
while (retList.Read())
{
FromTB.Text = Convert.ToString(retList["EMail"]);
}
retList.Close();
}
}
// If not using ReCaptcha Project, but using the Captcha Library.
//if (!IsPostBack)
//{
// HttpContext.Current.Session["CaptchaImageText"] = general.GenerateRandomCode();
//}
}
private void fillCombo(int recordType)
{
SqlDataReader dataType;
string sql = String.Empty;
string msg = String.Empty;
switch (recordType)
{
case 1:
sql = dbSQL.sqlUserArchive;
msg = sysMessages.msgNoActiveUser;
closeMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgUser.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgSpace + sysMessages.msgYouWishTo +
sysMessages.msgSpace + sysMessages.msgArchival + sysMessages.msgSpace + sysMessages.msgProcess + sysMessages.msgQuestion;
clearMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgUser.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgYouWillLose + sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgQuestion;
break;
case 2:
sql = dbSQL.sqlTroopArchive;
msg = sysMessages.msgNoActiveTroop;
closeMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgTroop.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgSpace + sysMessages.msgYouWishTo +
sysMessages.msgSpace + sysMessages.msgArchival + sysMessages.msgSpace + sysMessages.msgProcess + sysMessages.msgQuestion;
clearMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgTroop.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgYouWillLose + sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgQuestion;
break;
case 3:
sql = dbSQL.sqlGirlArchive;
msg = sysMessages.msgNoActiveGirl;
closeMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgGirl.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgSpace + sysMessages.msgYouWishTo +
sysMessages.msgSpace + sysMessages.msgArchival + sysMessages.msgSpace + sysMessages.msgProcess + sysMessages.msgQuestion;
clearMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgGirl.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgYouWillLose + sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgQuestion;
break;
case 4:
sql = dbSQL.sqlCookieArchive;
msg = sysMessages.msgNoActiveCookie;
closeMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgCookie.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgSpace + sysMessages.msgYouWishTo +
sysMessages.msgSpace + sysMessages.msgArchival + sysMessages.msgSpace + sysMessages.msgProcess + sysMessages.msgQuestion;
clearMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgCookie.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgYouWillLose + sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgQuestion;
break;
case 5:
sql = dbSQL.sqlCustomerArchive;
msg = sysMessages.msgNoActiveCustomer;
closeMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgCustomer.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgSpace + sysMessages.msgYouWishTo +
sysMessages.msgSpace + sysMessages.msgArchival + sysMessages.msgSpace + sysMessages.msgProcess + sysMessages.msgQuestion;
clearMsg = sysMessages.msgThereIs + sysMessages.msgSpace + sysMessages.msgCustomer.ToLower() + sysMessages.msgSpace +
sysMessages.msgDataEntered + sysMessages.msgSpace + sysMessages.msgArchived + sysMessages.msgPeriod +
sysMessages.msgSpace + sysMessages.msgYouWillLose + sysMessages.msgSpace + sysMessages.msgAreYouSure + sysMessages.msgQuestion;
break;
default:
break;
}
dataType = dbOps.ExecuteReader(DB.DB_Conn, sql, CommandType.Text);
while (dataType.Read())
{
cboRecords.Items.Add(dataType.GetValue(0));
}
if (cboRecords.Items.Count == 0)
{
lblNoActiveRecord.Text = msg;
lblNoActiveRecord.Visible = true;
}
}
public List <RolesNRightsViewModel> GetRolesNRights(int?roleID)
{
RolesNRightsViewModel obj;
DBOperations dbOps = new DBOperations();
List <RolesNRightsViewModel> objs = new List <RolesNRightsViewModel>();
try
{
if (roleID.HasValue)
{
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("roleid", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = roleID.Value;
dbOps.ExecuteReader(AppConstants.USP_GET_ROLES_N_RIGHTS_By_RoleID, aParams);
}
else
{
dbOps.ProcName = AppConstants.USP_GET_ROLES_N_RIGHTS;
dbOps.ExecuteReader();
}
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
if (roleID.HasValue)
{
obj = new RolesNRightsViewModel
{
ActionID = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
ActionName = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
ControllerName = Helper.HandleDBNull <string>(dbOps.DataReader[3]),
MainMenuName = Helper.HandleDBNull <string>(dbOps.DataReader[5]),
RNRID = Helper.HandleDBNull <int>(dbOps.DataReader[6]),
MainMenuID = Helper.HandleDBNull <int>(dbOps.DataReader[4]),
IsActive = Helper.HandleDBNull <bool>(dbOps.DataReader[8]),
};
}
else
{
obj = new RolesNRightsViewModel
{
ActionID = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
ActionName = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
ControllerName = Helper.HandleDBNull <string>(dbOps.DataReader[3]),
MainMenuName = Helper.HandleDBNull <string>(dbOps.DataReader[5]),
MainMenuID = Helper.HandleDBNull <int>(dbOps.DataReader[4]),
};
}
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
internal void fillFrom(int transferId)
{
switch (transferId)
{
case 3:
fromType = dbOps.ExecuteReader(DB.DB_Conn,
dbSQL.sqlFillTroop,
CommandType.Text);
while (fromType.Read())
{
cboFrom.Items.Add(fromType.GetValue(0));
}
break;
case 4:
fromType = dbOps.ExecuteReader(DB.DB_Conn,
dbSQL.sqlFillTroop,
CommandType.Text);
while (fromType.Read())
{
cboFrom.Items.Add(fromType.GetValue(0));
}
break;
case 5:
fromType = dbOps.ExecuteReader(DB.DB_Conn,
dbSQL.sqlFillGirl,
CommandType.Text);
while (fromType.Read())
{
cboFrom.Items.Add(fromType.GetValue(0));
}
break;
case 6:
fromType = dbOps.ExecuteReader(DB.DB_Conn,
dbSQL.sqlFillTroop,
CommandType.Text);
while (fromType.Read())
{
cboFrom.Items.Add(fromType.GetValue(0));
}
break;
case 7:
fromType = dbOps.ExecuteReader(DB.DB_Conn,
dbSQL.sqlFillBooth,
CommandType.Text);
while (fromType.Read())
{
cboFrom.Items.Add(fromType.GetValue(0));
}
break;
}
}
