protected void Page_Load(object sender, EventArgs e)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
compid = Session["comid"].ToString();
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
if (!IsPostBack)
{
statuslable.Text = "";
Pagecontrol.dypcontrol(Page, page);
//PageConn pgcon = new PageConn();
//con = pgcon.dynconn;
statuslable.Visible = false;
ViewState["sortOrder"] = "";
// ddl();
fillwarehouse();
// ModalPopupExtender1.Hide();
ModalPopupExtender1222.Hide();
FillGridView1();
}
}
protected void Page_Load(object sender, EventArgs e)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
compid = Session["comid"].ToString();
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
compid = Session["Comid"].ToString();
Page.Title = pg.getPageTitle(page);
ModalPopupExtender1222.Hide();
Label1.Visible = false;
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
ViewState["sortOrder"] = "";
//string strwh = "SELECT WareHouseId,Name,Address,CurrencyId FROM WareHouseMaster where comid='" + compid + "' and WareHouseMaster.Status='" + 1 + "'";
//SqlCommand cmdwh = new SqlCommand(strwh, con);
//SqlDataAdapter adpwh = new SqlDataAdapter(cmdwh);
//DataTable dtwh = new DataTable();
//adpwh.Fill(dtwh);
//ddlWarehouse.DataSource = dtwh;
//ddlWarehouse.DataTextField = "Name";
//ddlWarehouse.DataValueField = "WareHouseId";
//ddlWarehouse.DataBind();
//DropDownList1.DataSource = dtwh;
//DropDownList1.DataTextField = "Name";
//DropDownList1.DataValueField = "WareHouseId";
//DropDownList1.DataBind();
//DropDownList1.Items.Insert(0, "ALL");
//DropDownList1.Items[0].Value = "0";
tXtEffectiveStartdate.Text = System.DateTime.Now.ToShortDateString();
txtenddate.Text = System.DateTime.Now.ToShortDateString();
fillstore();
fillstorewithfilter();
filldatagrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
if (!IsPostBack)
{
ViewState["sortOrder"] = "";
txteenddate.Text = System.DateTime.Now.ToShortDateString();
txtenddateto.Text = System.DateTime.Now.ToShortDateString();
fillstore();
fillbatch();
fillemployee();
fillgrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/ShoppingCart/Admin/ShoppingCartLogin.aspx");
}
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Session["PageUrl"] = strData;
Session["PageName"] = page;
Page.Title = pg.getPageTitle(page);
if (!Page.IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
ViewState["sortOrder"] = "";
lblcom.Text = Session["Cname"].ToString();
fillstore();
fillfilterstore();
FillRuleType();
}
}
protected void Page_Load(object sender, EventArgs e)
{
PageConn pgcon = new PageConn();
cn = pgcon.dynconn;
//cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
if (ViewState["up"] != null)
{
upfile = Convert.ToInt32(ViewState["up"]);
}
if (ViewState["rej"] != null)
{
rejfile = Convert.ToInt32(ViewState["rej"]);
}
Label1.Text = "";
if (!IsPostBack)
{
filladdresstype();
ddlAddType.SelectedIndex = ddlAddType.Items.IndexOf(ddlAddType.Items.FindByText("Business Address"));
fillddlCat();
ddlSheets.Items.Insert(0, "-Select-");
ddlSheets.Items[0].Value = "0";
// fillgrid();
}
}
protected void bindgrid()
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
string gra = "";
if (filterschool.SelectedIndex > 0)
{
gra += " where tblAnnouncementType.BusinessID='" + filterschool.SelectedValue + "'";
}
SqlCommand cmdc = new SqlCommand("SELECT WareHouseMaster.Name as School,tblAnnouncementType.ID,tblAnnouncementType.AnnouncementType FROM tblAnnouncementType inner join WareHouseMaster on tblAnnouncementType.BusinessID=WareHouseMaster.WareHouseId " + gra + "", con);
SqlDataAdapter dac = new SqlDataAdapter(cmdc);
DataTable dtc = new DataTable();
dac.Fill(dtc);
if (dtc.Rows.Count > 0)
{
GVC.DataSource = dtc;
GVC.DataBind();
}
else
{
GVC.DataSource = null;
GVC.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
lblmsg.Visible = false;
if (!IsPostBack)
{
if (!IsPostBack)
{
ViewState["sortOrder"] = "";
fillstore();
ddlwarehouse_SelectedIndexChanged(sender, e);
}
}
}
public void UpdateActiveDeactiveEmployee(int active_deactive, int EmployeeID, int Company_id)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
try
{
con.Close();
cmd = new SqlCommand("UpdateActiveDeactiveEmployee", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@active_deactive", active_deactive);
cmd.Parameters.AddWithValue("@EmployeeID", EmployeeID);
cmd.Parameters.AddWithValue("@Company_id", Company_id);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return;
}
catch (Exception ex)
{
return;
}
}
public DataTable selectObjectiveByCompany(int company_id)
{
DataTable dt = new DataTable();
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
con.Close();
con.Open();
string k1;
k1 = "SELECT ObjectiveMaster.MasterId, ObjectiveMaster.BusinessId, ObjectiveMaster.EmployeeId, ObjectiveMaster.ObjectiveName, ObjectiveMaster.Description, "
+ " ObjectiveMaster.EStartDate, ObjectiveMaster.EEndDate, ObjectiveMaster.AEndDate, ObjectiveMaster.BudgetedCost, ObjectiveMaster.ActualCost, "
+ " ObjectiveMaster.ShortageExcess, BusinessMaster.BusinessID , BusinessMaster.BusinessName"
+ " FROM ObjectiveMaster INNER JOIN"
+ " BusinessMaster ON ObjectiveMaster.BusinessId = BusinessMaster.BusinessID INNER JOIN"
+ " Company_Business ON BusinessMaster.BusinessID = Company_Business.BusinessID "
+ " WHERE (Company_Business.company_id = " + company_id + ")"
+ " ORDER BY BusinessMaster.BusinessName, ObjectiveMaster.ObjectiveName";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
adp1.Fill(dt);
con.Close();
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
if (!IsPostBack)
{
bindgrid();
fillstore();
fn_bind_ddlbuilding();
if (Request.QueryString["buildingid"] != null)
{
pnladdd.Visible = true;
btnadddd.Visible = false;
string buildingid = Request.QueryString["buildingid"];
SqlCommand cmdstr = new SqlCommand("Select * from tblBuilding where ID = '" + buildingid + "'", con);
SqlDataAdapter adp = new SqlDataAdapter(cmdstr);
DataTable ds = new DataTable();
adp.Fill(ds);
if (ds.Rows.Count > 0)
{
ddlschool.SelectedValue = ds.Rows[0]["BusinessID"].ToString();
fn_bind_ddlbuilding();
ddlbuildingName.SelectedValue = ds.Rows[0]["ID"].ToString();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
GridView1.PagerSettings.Visible = true;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
compid = Session["Comid"].ToString();
Page.Title = pg.getPageTitle(page);
Label1.Visible = false;
if (!Page.IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
lblCompany.Text = Session["Cname"].ToString();
ViewState["sortOrder"] = "";
fillpartymastercategory();
DDL();
FillGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
Page.Form.Attributes.Add("enctype", "multipart/form-data");
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
if (!IsPostBack)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
ViewState["sortOrder"] = "";
fillstore();
fillstore1();
fillgrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Login.aspx");
}
PageConn pgcon = new PageConn();
conOADB = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
Label1.Visible = false;
if (!Page.IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
}
}
protected void Page_Load(object sender, EventArgs e)
{
PageConn pgcon = new PageConn();
conOADB = pgcon.dynconn;
if (Session["Comid"] == null || Session["ClientId"] == null)
{
Response.Redirect("~/Login.aspx");
}
lblmsg.Text = "";
if (!IsPostBack)
{
lblpagename.Text = "";
Session["GridFileAttach1"] = null;
ViewState["sortOrder"] = "";
filterproduct(); //M
Fillpages(); //M
FillGV_pagelist(); //
Fillwarehouse(); //
filltimezone();
fillfilteremp(); //
Fillgrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
PageConn pgcon = new PageConn();
conn = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
lblCompany.Text = Session["Cname"].ToString();
ViewState["sortOrder"] = "";
Fillwarehouse();
sh();
Fillaccount();
fillgrid();
lblmsg.Visible = false;
}
}
public DataTable ObjectiveMasterGetDataByYear(int company_id, int year)
{
DataTable dt = new DataTable();
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
con.Close();
con.Open();
string k1;
k1 = " SELECT businessmaster.*, objectivemaster.*, (year(objectivemaster.eenddate))as year"
+ " FROM ObjectiveMaster INNER JOIN"
+ " BusinessMaster ON ObjectiveMaster.BusinessId = BusinessMaster.BusinessID INNER JOIN"
+ " Company_Business ON BusinessMaster.BusinessID = Company_Business.BusinessID"
+ " WHERE (YEAR(ObjectiveMaster.EEndDate) = " + year + ") AND (Company_Business.company_id = " + company_id + ")"
+ " ORDER BY BusinessMaster.BusinessName, ObjectiveMaster.ObjectiveName";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
adp1.Fill(dt);
con.Close();
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
ViewState["Compid"] = Session["Comid"].ToString();
ViewState["UserName"] = Session["userid"].ToString();
Page.Title = pg.getPageTitle(page);
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
fillwarehouse();
txteffectend.Text = System.DateTime.Now.ToShortDateString();
txteffectstart.Text = System.DateTime.Now.ToShortDateString();
}
}
public DataTable ObjectiveMasterGetDataByStatusId(int status, int company_id)
{
DataTable dt = new DataTable();
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
con.Close();
con.Open();
string k1;
k1 = "SELECT objectivemaster.*,businessmaster.*"
+ " FROM ObjectiveMaster INNER JOIN"
+ " BusinessMaster ON ObjectiveMaster.BusinessId = BusinessMaster.BusinessID AND ObjectiveMaster.MasterId IN"
+ " (SELECT DISTINCT MasterId"
+ " FROM ObjectiveEvaluation"
+ " WHERE (StatusId = " + status + ")) INNER JOIN"
+ " Company_Business ON BusinessMaster.BusinessID = Company_Business.BusinessID"
+ " WHERE (Company_Business.company_id = " + company_id + ")";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
adp1.Fill(dt);
con.Close();
return(dt);
}
protected void Button3_Click(object sender, EventArgs e)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
SqlCommand cmdstr = new SqlCommand("select ID from tblAnnouncementType where AnnouncementType = '" + txttype.Text + "' and BusinessID='" + ddlschool.SelectedValue + "'", con);
SqlDataAdapter adp = new SqlDataAdapter(cmdstr);
DataTable ds = new DataTable();
adp.Fill(ds);
if (ds.Rows.Count > 0)
{
string currentsection = ViewState["ID"].ToString();
if (ds.Rows[0]["ID"].ToString() == currentsection)
{
lblmsg.Text = "Record updated successfully.";
}
else
{
lblmsg.Text = "Record already exist.";
}
}
else
{
fn_update();
}
clear();
}
public DataTable LTGMasterByComapanyid(int company_id)
{
DataTable dt = new DataTable();
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
con.Close();
con.Open();
string k1;
k1 = "SELECT * FROM LTGMaster INNER JOIN"
+ " ObjectiveMaster ON LTGMaster.ObjectiveMasterId = ObjectiveMaster.MasterId INNER JOIN"
+ " BusinessMaster ON LTGMaster.BusinessId = BusinessMaster.BusinessID INNER JOIN"
+ " Company_Business ON BusinessMaster.BusinessID = Company_Business.BusinessID"
+ " WHERE (Company_Business.company_id = " + company_id + ") order by BusinessMaster.BusinessName";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
adp1.Fill(dt);
con.Close();
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
Page.Form.Attributes.Add("enctype", "multipart/form-data");
PageConn pgcon = new PageConn();
conn = pgcon.dynconn;
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
lblCompany.Text = Session["Cname"].ToString();
fillgrid();
}
}
public DataTable LTGMasterGetDataByYearbyCompany(int company_id, int year)
{
DataTable dt = new DataTable();
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
con.Close();
con.Open();
string k1;
k1 = "select businessmaster.*, ltgmaster.*, (year(ltgmaster.eenddate))as year"
+ " FROM LTGMaster INNER JOIN"
+ " BusinessMaster ON LTGMaster.BusinessId = BusinessMaster.BusinessID INNER JOIN"
+ " Company_Business ON BusinessMaster.BusinessID = Company_Business.BusinessID"
+ " WHERE (YEAR(LTGMaster.EEndDate) = " + year + ") AND (Company_Business.company_id = " + company_id + ")"
+ " order by BusinessMaster.BusinessName";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
adp1.Fill(dt);
con.Close();
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
string assss = "32";
assss = PageMgmt.Encrypted("Inventorycategorymaster.aspx");
assss = PageMgmt.Decrypted("lpSVW07ER8Q=");
Session.Clear();
if (!IsPostBack)
{
lblmsg.Visible = false;
}
con = PageConn.licenseconn();
// string str = @" DECLARE @Pivot_Column [nvarchar](max);
// DECLARE @Query [nvarchar](max);
// SELECT @Pivot_Column= COALESCE(@Pivot_Column+',','')+ QUOTENAME(CategoryName) FROM
// (SELECT DISTINCT [CategoryName] FROM PageAccessToPricePlanCategory Where CategoryName IS NOT NULL)Tab
// SELECT @Query='SELECT PageId,PageName, '+@Pivot_Column+'FROM
// (SELECT PageId,PageName, [CategoryName] , Id FROM PageAccessToPricePlanCategory )Tab1
// PIVOT
// (
// SUM(Id) FOR CategoryName IN ('+@Pivot_Column+')) AS Tab2
// ORDER BY Tab2.PageName'
// EXEC sp_executesql @Query ";//
// SqlCommand cmd = new SqlCommand(str, con);
// SqlDataAdapter adp = new SqlDataAdapter(cmd);
// DataTable dt = new DataTable();
// adp.Fill(dt);
}
public DataTable STGMasterGetDatabyCompany(int company_id)
{
DataTable dt = new DataTable();
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
con.Close();
con.Open();
string k1;
k1 = "select * FROM STGMaster INNER JOIN"
+ " LTGMaster ON STGMaster.LTGMasterID = LTGMaster.MasterId INNER JOIN"
+ " ObjectiveMaster ON LTGMaster.ObjectiveMasterId = ObjectiveMaster.MasterId INNER JOIN"
+ " BusinessMaster ON STGMaster.BusinessId = BusinessMaster.BusinessID INNER JOIN"
+ " Company_Business ON BusinessMaster.BusinessID = Company_Business.BusinessID"
+ " WHERE (Company_Business.company_id = " + company_id + ") ORDER BY BusinessMaster.BusinessName";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
adp1.Fill(dt);
con.Close();
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
if (!IsPostBack)
{
fillstore();
ddlSearchByStore_SelectedIndexChanged(sender, e);
}
}
public DataTable STGMasterByYearbyCompany(int company_id, int year)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
DataTable dt = new DataTable();
con.Close();
con.Open();
string k1;
k1 = "select * FROM"
+ " STGMaster INNER JOIN LTGMaster ON STGMaster.LTGMasterID = LTGMaster.MasterId"
+ " INNER JOIN ObjectiveMaster ON LTGMaster.ObjectiveMasterId = ObjectiveMaster.MasterId"
+ " INNER JOIN BusinessMaster ON STGMaster.BusinessId = BusinessMaster.BusinessID "
+ " INNER JOIN Company_Business ON BusinessMaster.BusinessID = Company_Business.BusinessID"
+ " WHERE (Company_Business.company_id = " + company_id + ") and (YEAR(STGMaster.EEndDate) = " + year + ")"
+ " ORDER BY BusinessMaster.BusinessName";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
adp1.Fill(dt);
con.Close();
return(dt);
}
public string PrdMsg(string compid)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
connect = PageConn.licenseconn();
string strc = "SELECT CompanyId from CompanyMaster where CompanyLoginId='" + compid + "'";
SqlCommand dac = new SqlCommand(strc, connect);
connect.Open();
object enccompid = dac.ExecuteScalar();
connect.Close();
enccompid = encryptstrring(enccompid.ToString());
//string str = "SELECT MP, CID, PID, V FROM Lmaster where CID='" + enccompid + "'";
//SqlDataAdapter da = new SqlDataAdapter(str, conn);
//DataTable dt = new DataTable();
//da.Fill(dt);
//string str1 = "Select MAX(InventoryMasterId) FROM InventoryMaster inner join InventoruSubSubCategory on InventoryMaster.InventorySubSubId=InventoruSubSubCategory.InventorySubSubId INNER JOIN InventorySubCategoryMaster ON InventoruSubSubCategory.InventorySubCatID = InventorySubCategoryMaster.InventorySubCatId INNER JOIN InventoryCategoryMaster ON InventorySubCategoryMaster.InventoryCategoryMasterId = InventoryCategoryMaster.InventeroyCatId where InventoryCategoryMaster.compid='" + compid + "'";
//SqlDataAdapter da1 = new SqlDataAdapter(str1, con);
//DataTable dt1 = new DataTable();
//da1.Fill(dt1);
//if (dt.Rows[0][0].ToString() != "")
//{
// if (dt1.Rows[0][0].ToString() != "")
// {
// if (dt.Rows[0][0].ToString() != "Unlimited")
// {
// // int LMastlimit = Convert.ToInt16(dt.Rows[0][0].ToString());
// int LMastlimit = Convert.ToInt32(decryptstring(dt.Rows[0][0].ToString()));
// LMastlimit = LMastlimit - 10;
// int InvMasterVal = Convert.ToInt16(dt1.Rows[0][0].ToString());
// if (InvMasterVal >= LMastlimit)
// {
// return "Your Inventory Limit is : " + (LMastlimit + 10) + "Now !! You can enter " + ((LMastlimit + 10) - InvMasterVal) + " products.";
// }
// else
// {
// return "";
// }
// }
// else
// {
// return "";
// }
// }
// else
// {
// return "";
// }
//}
//else
//{
// return "";
//}
return("");
}
public DataTable STGMasterByStatusIdbyCompany(int status, int comapny_id)
{
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
DataTable dt = new DataTable();
con.Close();
con.Open();
string k1;
k1 = "SELECT * FROM STGMaster INNER JOIN"
+ " BusinessMaster ON STGMaster.BusinessId = BusinessMaster.BusinessID AND STGMaster.MasterId IN"
+ " (SELECT DISTINCT MasterId FROM STGEvaluation WHERE (StatusId = " + status + " )) INNER JOIN"
+ " Company_Business ON BusinessMaster.BusinessID = Company_Business.BusinessID"
+ " WHERE (Company_Business.company_id = " + comapny_id + ")";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
adp1.Fill(dt);
con.Close();
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
//Session["pnl1"] = "8";
// Session["pagename"] = "MessageViewSent.aspx";
if (!Page.IsPostBack)
{
GetMessgeDetail();
FillFileAttachDetail();
}
}
protected void Page_Load(object sender, EventArgs e)
{
PageConn pgcon = new PageConn();
iofficecon = pgcon.dynconn;
// chkboxActiveDeactive.Checked=true;
lblmsg.Text = "";
if (!IsPostBack)
{
ViewState["sortOrder"] = "";
if (Session["Login"] != null)
{
if (Session["Login"].ToString() == null)
{
Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
DDLProductModelName();
DDLsuppliername();
DDLddlcomponent();
DDLProductModelNamefilter();
DDLsuppliernamefilter();
DDLddlcomponentfilter();
FillGrid();
}
}
