protected DataTable selectbusdy(string qu)
{
SqlCommand cmd = new SqlCommand(qu, PageConn.busclient());
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
return(dt);
}
//HttpCookieCollection cook;
protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(con.ConnectionString) == "")
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
}
if (Convert.ToString(PageConn.busdatabase) == "")
{
PageConn.licenseconn();
}
con1 = PageConn.licenseconn();
if (PageConn.bidname == "")
{
PageConn.busclient();
}
string strData = Request.Url.LocalPath.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Session["pagename"] = page.ToString();
String pageurl = Request.Url.AbsoluteUri;
HttpContext.Current.Response.Cache.SetAllowResponseInBrowserHistory(false);
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Cache.SetNoStore();
Response.Cache.SetExpires(DateTime.Now.AddSeconds(60));
Response.Cache.SetValidUntilExpires(true);
if (!IsPostBack)
{
ddlcountry.Items.Clear();
DataTable dtc = select("select distinct CountryId,CountryName,Country_Code from CountryMaster Order by CountryName ");
if (dtc.Rows.Count > 0)
{
ddlcountry.DataSource = dtc;
ddlcountry.DataTextField = "CountryName";
ddlcountry.DataValueField = "CountryId";
ddlcountry.DataBind();
}
ddlcountry.Items.Insert(0, "Select Country");
ddlcountry.Items[0].Value = "0";
ddlcountry_SelectedIndexChanged(sender, e);
PopulateMenu();
}
}
public static Boolean Usercon(string tablename, string tblforeignkeyid, String countId, string std, string etd, String CID, String Inque)
{
PageConn pgcon = new PageConn();
SqlConnection con = pgcon.dynconn;
Boolean ins = true;
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlCommand cmdt = new SqlCommand();
DataTable dtt = new DataTable();
// "Select DocumentImageMaster.*,DoucmentMaster.* from DocumentImageMaster inner join DocumentImageMaster.DocumentMasterId=DoucmentMaster.DocumentId where DoucmentMaster.DocumentId='@DocumentId and CID=@CID"
// "Select DocumentImageMaster.* from DocumentImageMaster where DocumentMasterId='@DocumentId"
string forkey = "";
if (tblforeignkeyid.Length > 0)
{
forkey = " and ForeignkeyrecordId='" + ClsEncDesc.Encrypted(tblforeignkeyid) + "'";
}
string adf = "Select ClientProductTableMaster.*,ClientProductRecordsAllowed.* from ClientProductTableMaster inner join ClientProductRecordsAllowed on ClientProductRecordsAllowed.ClientProductTblId=ClientProductTableMaster.Id where TableName='" + ClsEncDesc.Encrypted(tablename) + "' and PricePlanId='" + ClsEncDesc.Encrypted(HttpContext.Current.Session["PriceId"].ToString()) + "'" + forkey;
cmd = new SqlCommand(adf, PageConn.busclient());
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(dt);
if (dt.Rows.Count > 0)
{
string pera = "";
if (Convert.ToString(dt.Rows[0]["ForeignkeyrecordName"]) != "")
{
pera = "and " + ClsEncDesc.Decrypted(Convert.ToString(dt.Rows[0]["ForeignkeyrecordName"])) + "=" + tblforeignkeyid;
}
try
{
string adrt = "Select Count(" + tablename + "." + countId + ") from " + Inque + " where " + CID + "='" + HttpContext.Current.Session["Comid"].ToString() + "' " + pera + std + etd;
cmdt = new SqlCommand(adrt, con);
SqlDataAdapter adt = new SqlDataAdapter(cmdt);
adt.Fill(dtt);
if (Convert.ToString(dtt.Rows[0][0]) != "")
{
string pagerecod = ClsEncDesc.Decrypted(dt.Rows[0]["RecordsAllowed"].ToString());
if (Convert.ToInt32(pagerecod) <= Convert.ToInt32(dtt.Rows[0][0]))
{
ins = false;
}
}
}
catch
{
ins = true;
}
}
return(ins);
}
//HttpCookieCollection cook;
protected void Page_Load(object sender, EventArgs e)
{
int mast = 0;
//PageConn pgcon = new PageConn();
//con = pgcon.dynconn;
if (Convert.ToString(con.ConnectionString) == "")
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
}
if (Convert.ToString(PageConn.busdatabase) == "")
{
PageConn.licenseconn();
}
con1 = PageConn.licenseconn();
if (Convert.ToString(PageConn.bidname) == "")
{
PageConn.busclient();
}
string strData = Request.Url.LocalPath.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Session["pagename"] = page.ToString();
String pageurl = Request.Url.AbsoluteUri;
if (Convert.ToString(Session["Devl"]) == "yes")
{
if (!IsPostBack)
{
FillLogos();
HttpContext.Current.Response.Cache.SetAllowResponseInBrowserHistory(false);
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Cache.SetNoStore();
Response.Cache.SetExpires(DateTime.Now.AddSeconds(60));
Response.Cache.SetValidUntilExpires(true);
}
}
else
{
Response.Redirect("~/ShoppingCart/Developer/DeveloperLogin.aspx");
}
}
protected void btnsignin_Click(object sender, EventArgs e)
{
Session["Comid"] = txtcompanyid.Text;
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
PageConn.busclient();
string str = "select party_master.PartyID,PartytTypeMaster.PartType,User_master.State,party_master. Whid,party_master.Account,party_master. id,Login_master.UserID,Login_master.password,Login_master.username from Party_master inner join User_master on User_master.PartyID=Party_master.PartyID inner join Login_master on Login_master.UserID = User_master.UserID inner join PartytTypeMaster on PartytTypeMaster.PartyTypeId=Party_master.PartyTypeId where (Login_master.username = '******') AND (Login_master.password = '******')and(Party_master.id='" + txtcompanyid.Text + "')";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
int recordcount = ds.Tables[0].Rows.Count;
if (recordcount == 0)
{
lblError.Text = "User Name or Password Incorrect";
lblError.Visible = true;
}
else
{
Session["sid"] = ds.Tables[0].Rows[0]["State"].ToString();
lblError.Visible = false;
Session["userid"] = Convert.ToInt32(ds.Tables[0].Rows[0]["UserID"].ToString());
Session["Username"] = txtuname.Text;
Session["Whid"] = Convert.ToInt32(ds.Tables[0].Rows[0]["Whid"].ToString());
Session["PartyID"] = Convert.ToInt32(ds.Tables[0].Rows[0]["PartyID"].ToString());
Session["CompanyId"] = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString());
Session["PartyId"] = Convert.ToInt32(ds.Tables[0].Rows[0]["PartyID"].ToString());
Session["Account"] = Convert.ToInt32(ds.Tables[0].Rows[0]["Account"].ToString());
Session["WH"] = Convert.ToInt32(ds.Tables[0].Rows[0]["Whid"].ToString());
Session["PartType"] = Convert.ToInt32(ds.Tables[0].Rows[0]["Whid"].ToString());
Session["EmployeeId"] = "1850";
Response.Redirect("PartyAfterLogin.aspx");
}
}
public string getPageTitle(string PgName)
{
PageConn pagecon = new PageConn();
con = pagecon.dynconn;
string str = "Select PageTitle from PageMaster where PageName='" + ClsEncDesc.EncDyn(PgName) + "'";
SqlCommand cmd = new SqlCommand(str, PageConn.busclient());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
string pgTitle;
if (dt.Rows.Count > 0)
{
pgTitle = ClsEncDesc.DecDyn(dt.Rows[0]["PageTitle"].ToString());
}
else
{
pgTitle = "Iwebshop Version1.1";
}
return(pgTitle);
}
public static void dypcontrol(Page conpage, string pagen)
{
string str1211 = "SELECT distinct Control_type_Master.Type_name,PageControlMaster.ControlName,PageControlPricePlanCoordination.ControlLabel FROM DynamicPageControlScheme inner join PageControlPricePlanCoordination on PageControlPricePlanCoordination.DynamicPageControlMasterSchemeID = DynamicPageControlScheme.ID inner join PageControlMaster on PageControlMaster.PageControl_id=PageControlPricePlanCoordination.PageControlID inner join PageMaster on PageControlMaster.Page_id=PageMaster.PageId INNER JOIN Control_type_Master ON PageControlMaster.ControlType_id = Control_type_Master.Type_id where DynamicPageControlScheme.PricePlanID='" + HttpContext.Current.Session["PriceId"] + "' and PageMaster.VersionInfoMasterId='" + (HttpContext.Current.Session["VerId"]) + "' and PageMaster.PageName='" + pagen + "'";
SqlDataAdapter da1211 = new SqlDataAdapter(str1211, PageConn.busclient());
DataTable dt1211 = new DataTable();
da1211.Fill(dt1211);
foreach (DataRow dsc in dt1211.Rows)
{
String StrVal = Convert.ToString(dsc["Type_Name"]);
String StrName = Convert.ToString(dsc["ControlName"]);
String ControlLabel = Convert.ToString(dsc["ControlLabel"]);
GetControls(conpage, StrName);
if (myC is Button)
{
Button myLabel = (Button)Convert.ChangeType(myC, typeof(Button));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
else if (myC is GridView)
{
GridView myLabel = (GridView)Convert.ChangeType(myC, typeof(GridView));
if (myLabel.ID == Convert.ToString(StrName))
{
for (int hr = 0; hr < myLabel.Columns.Count; hr++)
{
if (myLabel.Columns[hr].HeaderText.ToString() == Convert.ToString(dsc["Type_Name"]))
{
myLabel.Columns[hr].Visible = false;
}
}
}
}
else if (myC is LinkButton)
{
LinkButton myLabel = (LinkButton)Convert.ChangeType(myC, typeof(LinkButton));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
else if (myC is LinkButton)
{
LinkButton myLabel = (LinkButton)Convert.ChangeType(myC, typeof(LinkButton));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
else if (myC is ImageButton)
{
ImageButton myLabel = (ImageButton)Convert.ChangeType(myC, typeof(ImageButton));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.AlternateText = ControlLabel;
}
}
else if (myC is TextBox)
{
TextBox myLabel = (TextBox)Convert.ChangeType(myC, typeof(TextBox));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
else if (myC is Label)
{
Label myLabel = (Label)Convert.ChangeType(myC, typeof(Label));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
else if (myC is CheckBox)
{
CheckBox myLabel = (CheckBox)Convert.ChangeType(myC, typeof(CheckBox));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
else if (myC is CheckBoxList)
{
CheckBoxList myLabel = (CheckBoxList)Convert.ChangeType(myC, typeof(CheckBoxList));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
else if (myC is RadioButton)
{
RadioButton myLabel = (RadioButton)Convert.ChangeType(myC, typeof(RadioButton));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
else if (myC is RadioButtonList)
{
RadioButtonList myLabel = (RadioButtonList)Convert.ChangeType(myC, typeof(RadioButtonList));
if (myLabel.ID == Convert.ToString(StrName))
{
myLabel.Text = ControlLabel;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string[] separator1 = new string[] { "." };
string[] strSplitArr1 = Request.Url.Host.Split(separator1, StringSplitOptions.RemoveEmptyEntries);
if (strSplitArr1[0].ToString() != "")
{
Session["Comid"] = strSplitArr1[0].ToString();
}
else
{
Session["Comid"] = "jobcenter";
}
Session["Comid"] = "jobcenter";
//Session["Comid"] = "1133";
PageConn pgcon = new PageConn();
conn = pgcon.dynconn;
connectioninsert = PageConn.UserLog();
PageConn PCX = new PageConn();
busiclient = PageConn.busclient();
string strdeleteoldest = "delete from NonspecificIpforuser ";
SqlCommand cmddeleteoldest = new SqlCommand(strdeleteoldest, conn);
if (conn.State.ToString() != "Open")
{
conn.Open();
}
cmddeleteoldest.ExecuteNonQuery();
if (!IsPostBack)
{
if (Request.QueryString["ip"] != null && Request.QueryString["maxid"] != null && Request.QueryString["name"] != null)
{
string ip = Convert.ToString(Request.QueryString["ip"]);
ViewState["ip"] = ClsEncDesc.Decrypted(ip.ToString());
string str = ViewState["ip"].ToString();
string firsttwo = str.Substring(0, 2);
string middletwo = str.Substring(2, str.Length - 4);
string newonestr = "";
foreach (char single in middletwo)
{
if (single.ToString() != ":")
{
newonestr += "*";
}
else
{
newonestr += single.ToString();
}
}
string lasttwo = str.Substring(str.Length - 2, 2);
string finaldisplay = firsttwo + newonestr + lasttwo;
ViewState["finaldisplay"] = finaldisplay.ToString();
string name = Convert.ToString(Request.QueryString["name"]);
ViewState["name"] = ClsEncDesc.Decrypted(name.ToString());
string maxid = (Request.QueryString["maxid"]);
ViewState["maxid"] = maxid.ToString();
DataTable dtchek = findmaxidrecord(maxid.ToString());
if (dtchek.Rows.Count > 0)
{
int requesttype = Convert.ToInt32(dtchek.Rows[0]["Requesttype"].ToString());
if (requesttype == 1)
{
DataTable ipstatus = ipaddressverificationstatus(maxid.ToString());
if (ipstatus.Rows.Count > 0)
{
Label4.Text = "This IP address " + ViewState["finaldisplay"].ToString() + " is already in the list of allowed IP addresses. ";
}
else
{
DataTable dtuserdetail = finduserdetail(dtchek.Rows[0]["emailgenerateduserid"].ToString());
if (dtuserdetail.Rows.Count > 0)
{
insertipforuser(dtchek.Rows[0]["emailgenerateduserid"].ToString(), ViewState["ip"].ToString(), ViewState["name"].ToString());
mailgeneteate(dtchek.Rows[0]["verifieduserid"].ToString(), dtchek.Rows[0]["emailgenerateduserid"].ToString(), dtuserdetail.Rows[0]["Name"].ToString(), requesttype, dtuserdetail.Rows[0]["Email"].ToString(), dtuserdetail.Rows[0]["Compname"].ToString());
Label4.Text = "You have successfully added the following IP address to the allowed list.";
Label2.Text = dtuserdetail.Rows[0]["Compname"].ToString();
Label6.Text = dtuserdetail.Rows[0]["PartType"].ToString();
Label8.Text = dtuserdetail.Rows[0]["Username"].ToString();
Label10.Text = ViewState["finaldisplay"].ToString();
Label10.Text = PageMgmt.Decrypted(ViewState["finaldisplay"].ToString());
}
else
{
}
}
}
else
{
DataTable ipstatus = macaddressverificationstatus(maxid.ToString());
if (ipstatus.Rows.Count > 0)
{
Label4.Text = "This computer " + ViewState["finaldisplay"].ToString() + " is already in the list of allowed computers. ";
}
else
{
DataTable dtuserdetail = finduserdetail(dtchek.Rows[0]["emailgenerateduserid"].ToString());
if (dtuserdetail.Rows.Count > 0)
{
insertmacforuser(dtchek.Rows[0]["emailgenerateduserid"].ToString(), ViewState["ip"].ToString(), ViewState["name"].ToString());
mailgeneteate(dtchek.Rows[0]["verifieduserid"].ToString(), dtchek.Rows[0]["emailgenerateduserid"].ToString(), dtuserdetail.Rows[0]["Name"].ToString(), requesttype, dtuserdetail.Rows[0]["Email"].ToString(), dtuserdetail.Rows[0]["Compname"].ToString());
Label4.Text = "You have successfully added the following computer to the allowed list.";
Label2.Text = dtuserdetail.Rows[0]["Compname"].ToString();
Label6.Text = dtuserdetail.Rows[0]["PartType"].ToString();
Label8.Text = dtuserdetail.Rows[0]["Username"].ToString();
Label10.Text = ViewState["finaldisplay"].ToString();
Label10.Text = PageMgmt.Decrypted(ViewState["finaldisplay"].ToString());
}
else
{
}
}
}
}
}
}
}
