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);
compid = Session["Comid"].ToString();
statuslable.Visible = false;
if (!IsPostBack)
{
ViewState["sortOrder"] = "";
Pagecontrol.dypcontrol(Page, page);
fillwarehouse();
ddlwarehouse_SelectedIndexChanged(sender, e);
btnUpdate.Visible = false;
//Button6.Visible = false;
}
}
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)
{
txtfromdate.Text = System.DateTime.Now.ToShortDateString();
txttodate.Text = System.DateTime.Now.ToShortDateString();
Pagecontrol.dypcontrol(Page, page);
fillwarehouse();
if (ddlwarehouse.SelectedItem.Text.Equals("All"))
{
string qryStr1 = "Select id,Departmentname from DepartmentmasterMNC where Companyid='" + ViewState["Compid"] + "' order by Departmentname";
ddlDept.DataSource = (DataSet)fillddl(qryStr1);
fillddlOther(ddlDept, "Departmentname", "id");
ddlDept.Items.Insert(0, "All");
ddlDept.Items[0].Value = "0";
}
else
{
// fillemploy();
string qryStr = "Select id,Departmentname from DepartmentmasterMNC where Companyid='" + ViewState["Compid"] + "' and Whid='" + ddlwarehouse.SelectedValue + "' order by Departmentname";
ddlDept.DataSource = (DataSet)fillddl(qryStr);
fillddlOther(ddlDept, "Departmentname", "id");
ddlDept.Items.Insert(0, "All");
ddlDept.Items[0].Value = "0";
}
ddlDesignation.Items.Insert(0, "All");
ddlDesignation.Items[0].Value = "0";
ddlEmployeeName.Items.Insert(0, "All");
ddlEmployeeName.Items[0].Value = "0";
ddlproject.Items.Insert(0, "All");
ddlproject.Items[0].Value = "0";
ddltask.Items.Insert(0, "All");
ddltask.Items[0].Value = "0";
fillgriddata();
}
}
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[] { '/' };
// 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);
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
if (!Page.IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
if (Request.QueryString["Id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["Id"]);
string inf = "select vacancymastertbl.* from vacancymastertbl where vacancymastertbl.ID=" + id;
SqlDataAdapter dainf = new SqlDataAdapter(inf, con);
DataTable dtinf = new DataTable();
dainf.Fill(dtinf);
ViewState["whid"] = Convert.ToString(dtinf.Rows[0]["BusinessID"]);
ViewState["vacancypositiontypeid"] = Convert.ToString(dtinf.Rows[0]["vacancypositiontypeid"]);
ViewState["vacancypositiontitleid"] = Convert.ToString(dtinf.Rows[0]["vacancypositiontitleid"]);
SqlDataAdapter da11 = new SqlDataAdapter("select LogoUrl from CompanyWebsitMaster where whid='" + ViewState["whid"] + "'", con);
DataTable dt11 = new DataTable();
da11.Fill(dt11);
if (dt11.Rows.Count > 0)
{
Img1.ImageUrl = "~/ShoppingCart/images/" + dt11.Rows[0]["LogoUrl"].ToString();
}
SqlDataAdapter daza = new SqlDataAdapter("select warehousemaster.Name,CityMasterTbl.CityName,StateMasterTbl.StateName,CompanyWebsiteAddressMaster.TollFree1,CountryMaster.CountryName,CompanyWebsiteAddressMaster.Address1,CompanyWebsiteAddressMaster.Zip,CompanyWebsiteAddressMaster.Address2,CompanyWebsiteAddressMaster.Phone1,CompanyWebsiteAddressMaster.Phone2,CompanyWebsiteAddressMaster.Email from CompanyWebsiteAddressMaster inner join warehousemaster on warehousemaster.warehouseid=CompanyWebsiteAddressMaster.CompanyWebsiteMasterId inner join CityMasterTbl on CityMasterTbl.CityId=CompanyWebsiteAddressMaster.City inner join StateMasterTbl on StateMasterTbl.StateId=CompanyWebsiteAddressMaster.State inner join CountryMaster on CountryMaster.CountryId=CompanyWebsiteAddressMaster.Country where CompanyWebsiteAddressMaster.CompanyWebsiteMasterId='" + ViewState["whid"] + "'", con);
DataTable dtza = new DataTable();
daza.Fill(dtza);
if (dtza.Rows.Count > 0)
{
lblcompanyname.Text = dtza.Rows[0]["Name"].ToString();
lbladdress1.Text = "";
if (Convert.ToString(dtza.Rows[0]["TollFree1"]) != "")
{
lbladdress1.Text += "Tollfree : " + dtza.Rows[0]["TollFree1"].ToString();
}
if (Convert.ToString(dtza.Rows[0]["Phone1"]) != "" && Convert.ToString(dtza.Rows[0]["TollFree1"]) != "")
{
lbladdress1.Text += " , Ph : " + dtza.Rows[0]["Phone1"].ToString();
}
else
{
lbladdress1.Text += "Ph : " + dtza.Rows[0]["Phone1"].ToString();
}
//lbladdress1.Text = "Tollfree : " + dtza.Rows[0]["TollFree1"].ToString() + " , Ph : " + dtza.Rows[0]["Phone1"].ToString();
if (Convert.ToString(dtza.Rows[0]["Email"]) != "")
{
lblphoneno.Text = "Email : " + dtza.Rows[0]["Email"].ToString();
}
//lblcompanyname.Text = dtza.Rows[0]["Name"].ToString();
//lbladdress1.Text = dtza.Rows[0]["Address1"].ToString();
//lbltollfreeno.Text = dtza.Rows[0]["Address2"].ToString();
//lblphoneno.Text = dtza.Rows[0]["Phone1"].ToString();
//Label3.Text = dtza.Rows[0]["Email"].ToString();
//lblcs.Text = dtza.Rows[0]["CityName"].ToString() + "," + dtza.Rows[0]["StateName"].ToString() + "," + dtza.Rows[0]["CountryName"].ToString();
}
string strii = "select distinct VacancyMasterTbl.*,case when (VacancyMasterTbl.status='1') then 'Active' else 'Inactive' End as Statuslabel,WareHouseMaster.Name as wname,DepartmentmasterMNC.Departmentname + ' - ' + DesignationMaster.DesignationName as dname,VacancyTypeMaster.Name as vname,VacancyPositionTitleMaster.VacancyPositionTitle as vtitle from VacancyMasterTbl inner join WareHouseMaster on WareHouseMaster.WareHouseId=VacancyMasterTbl.businessid inner join DesignationMaster on DesignationMaster.DesignationMasterId=VacancyMasterTbl.DesignationID inner join DepartmentmasterMNC on DesignationMaster.DeptID=DepartmentmasterMNC.id inner join VacancyTypeMaster on VacancyTypeMaster.ID=VacancyMasterTbl.vacancypositiontypeid inner join VacancyPositionTitleMaster on VacancyPositionTitleMaster.ID=VacancyMasterTbl.vacancypositiontitleid where VacancyMasterTbl.ID='" + id + "'";
SqlDataAdapter da = new SqlDataAdapter(strii, con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
lblbusiness.Text = Convert.ToString(dt.Rows[0]["wname"]);
lblvactype.Text = Convert.ToString(dt.Rows[0]["vname"]);
lblvactitle.Text = Convert.ToString(dt.Rows[0]["vtitle"]);
lblemail.Text = Convert.ToString(dt.Rows[0]["contactEmail"]);
lblpername.Text = Convert.ToString(dt.Rows[0]["contactname"]);
lblphonno.Text = Convert.ToString(dt.Rows[0]["contactphoneno"]);
lbladdress.Text = Convert.ToString(dt.Rows[0]["contactAddress"]);
lblsal2.Text = Convert.ToString(dt.Rows[0]["salaryamount"]);
if (Convert.ToBoolean(dt.Rows[0]["applybyemail"]) == true)
{
pansdsdssdd.Visible = true;
}
else
{
pansdsdssdd.Visible = false;
}
if (Convert.ToBoolean(dt.Rows[0]["applybyphone"]) == true)
{
Panel1.Visible = true;
}
else
{
Panel1.Visible = false;
}
if (Convert.ToBoolean(dt.Rows[0]["applybyvisit"]) == true)
{
Panel2.Visible = true;
}
else
{
Panel2.Visible = false;
}
if (Convert.ToBoolean(dt.Rows[0]["applyonline"]) == true)
{
Panel3.Visible = true;
}
else
{
Panel3.Visible = false;
}
}
SqlDataAdapter dac = new SqlDataAdapter("select [CityMasterTbl].[CityName],StateMasterTbl.[StateName],CountryMaster.[CountryName] from [CityMasterTbl] inner join VacancyMasterTbl on VacancyMasterTbl.cityid=[CityMasterTbl].[CityId] inner join StateMasterTbl on StateMasterTbl.StateId=VacancyMasterTbl.stateid inner join CountryMaster on CountryMaster.CountryId=VacancyMasterTbl.countryid where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtc = new DataTable();
dac.Fill(dtc);
if (dtc.Rows.Count > 0)
{
lblcountry.Text = Convert.ToString(dtc.Rows[0]["CountryName"]);
lblstate.Text = Convert.ToString(dtc.Rows[0]["StateName"]);
lblcity.Text = Convert.ToString(dtc.Rows[0]["CityName"]);
}
SqlDataAdapter dac1 = new SqlDataAdapter("select VacancyDetailTbl.* from VacancyDetailTbl inner join VacancyMasterTbl on VacancyMasterTbl.ID=VacancyDetailTbl.vacancymasterid where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtc1 = new DataTable();
dac1.Fill(dtc1);
if (dtc1.Rows.Count > 0)
{
lbljobfun.Text = Convert.ToString(dtc1.Rows[0]["JobFunction"]);
lblqualifi.Text = Convert.ToString(dtc1.Rows[0]["QualificationRequirements"]);
lblTandC.Text = Convert.ToString(dtc1.Rows[0]["TermsandConditions"]);
}
SqlDataAdapter dac11 = new SqlDataAdapter("select Name from VacancyFTPT inner join VacancyMasterTbl on VacancyMasterTbl.vacancyftptid=VacancyFTPT.Id where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtc11 = new DataTable();
dac11.Fill(dtc11);
if (dtc11.Rows.Count > 0)
{
lblduration.Text = Convert.ToString(dtc11.Rows[0]["Name"]);
}
SqlDataAdapter dasl = new SqlDataAdapter("select CurrencyMaster.CurrencyName from CurrencyMaster inner join VacancyMasterTbl on VacancyMasterTbl.currencyid=CurrencyMaster.CurrencyId where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtsl = new DataTable();
dasl.Fill(dtsl);
if (dtsl.Rows.Count > 0)
{
lblsal1.Text = Convert.ToString(dtsl.Rows[0]["CurrencyName"]);
}
SqlDataAdapter dasl11 = new SqlDataAdapter("select SalaryPerPeriodMaster.Name from SalaryPerPeriodMaster inner join VacancyMasterTbl on VacancyMasterTbl.salaryperperiodid=SalaryPerPeriodMaster.ID where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtsl11 = new DataTable();
dasl11.Fill(dtsl11);
if (dtsl11.Rows.Count > 0)
{
lblsal3.Text = Convert.ToString(dtsl11.Rows[0]["Name"]);
}
}
}
}
// SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["OnlineAccountConnectionString"].ConnectionString);
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[] { '/' };
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);
PageConn pgcon = new PageConn();
conn = pgcon.dynconn;
if (!Page.IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
ViewState["sortOrder"] = "";
lblCompany.Text = Session["Cname"].ToString();
lblBusiness.Text = "All";
//string str = "select WareHouseId,Name from WareHouseMaster WHERE comid='" + Session["Comid"].ToString() + "' and [WareHouseMaster].Status='1' order by Name";
//SqlCommand cmd = new SqlCommand(str, conn);
//SqlDataAdapter adp = new SqlDataAdapter(cmd);
//DataSet ds = new DataSet();
//adp.Fill(ds);
//ddlstorename.DataSource = ds;
//ddlstorename.DataTextField = "Name";
//ddlstorename.DataValueField = "WareHouseId";
//ddlstorename.DataBind();
//DropDownList3.DataSource = ds;
//DropDownList3.DataTextField = "Name";
//DropDownList3.DataValueField = "WareHouseId";
//DropDownList3.DataBind();
//DropDownList3.Items.Insert(0, "ALL");
fillstore();
lblCompany.Text = Session["Cname"].ToString();
Fillddlbatch();
Fillddltime();
Fillgridbatchtiming();
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
SqlDataAdapter adpt = new SqlDataAdapter("select BatchMaster.ID,BatchMaster.WHID,WareHouseMaster.WareHouseId from BatchMaster inner join WareHouseMaster on BatchMaster.WHID = WareHouseMaster.WareHouseId where BatchMaster.ID ='" + Request.QueryString["id"] + "'", conn);
DataTable dt = new DataTable();
adpt.Fill(dt);
if (dt.Rows.Count > 0)
{
ddlstorename.SelectedIndex = ddlstorename.Items.IndexOf(ddlstorename.Items.FindByValue(dt.Rows[0]["WareHouseId"].ToString()));
Fillddlbatch();
ddlbatchmaster.SelectedIndex = ddlbatchmaster.Items.IndexOf(ddlbatchmaster.Items.FindByValue(dt.Rows[0]["ID"].ToString()));
Fillddltime();
Label1.Text = "";
lblmsg.Text = "";
pnladd.Visible = true;
lbladd.Text = "Add New Batch Time";
btnadd.Visible = false;
}
}
//ddlstorename.Items.Insert(0, "--Select--");
ImageButton49.Visible = false;
ImageButton48.Visible = true;
lblmsg.Text = "";
// txteffectstart.Text = Convert.ToString(System.DateTime.Now);
// txteffectend.Text = Convert.ToString(System.DateTime.Now.AddYears(5));
}
}
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 (Session["CompanyName"] != null)
{
this.Title = Session["CompanyName"] + " IFileCabinet.com - Available Documents : Manager";
}
Session["PageName"] = "DocumentAvailableByMangr.aspx";
if (Session["EmployeeId"] != null)
{
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
ViewState["EmployeeId"] = Session["EmployeeId"];
string str = "SELECT Distinct WareHouseId,Name FROM WareHouseMaster inner join EmployeeWarehouseRights on EmployeeWarehouseRights.Whid=WareHouseMaster.WareHouseId where comid = '" + Session["comid"] + "'and WareHouseMaster.Status='" + 1 + "' and EmployeeWarehouseRights.AccessAllowed='True' order by name";
SqlCommand cmd1 = new SqlCommand(str, con);
cmd1.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
ddlbusiness.DataSource = dt;
ddlbusiness.DataTextField = "Name";
ddlbusiness.DataValueField = "WareHouseId";
ddlbusiness.DataBind();
ViewState["sortOrder"] = "";
string eeed = " Select distinct EmployeeMaster.Whid from EmployeeMaster where EmployeeMasterId='" + Session["EmployeeId"] + "'";
SqlCommand cmdeeed = new SqlCommand(eeed, con);
SqlDataAdapter adpeeed = new SqlDataAdapter(cmdeeed);
DataTable dteeed = new DataTable();
adpeeed.Fill(dteeed);
if (dteeed.Rows.Count > 0)
{
ddlbusiness.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
Fillddl_doc_appvd_by_deo();
Fillddl_doc_appvd_by_sup();
// fillemp();
SelectDocument();
}
}
else
{
Response.Redirect("Shoppingcartlogin.aspx");
}
}
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();
Session["PageUrl"] = strData;
Session["PageName"] = page;
Page.Title = pg.getPageTitle(page);
if (Session["EmployeeId"] != null)
{
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
DataTable desgdept = new DataTable();
string str = "SELECT Distinct FolderID,FolderName FROM DocumentFolderMaster where EmployeeId = '" + Session["EmployeeId"] + "' order by FolderName";
SqlCommand cmd1 = new SqlCommand(str, con);
cmd1.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
ddlfolder.DataSource = dt;
ddlfolder.DataTextField = "FolderName";
ddlfolder.DataValueField = "FolderID";
ddlfolder.DataBind();
ddlfolder.Items.Insert(0, "All");
ddlfolder.Items[0].Value = "0";
}
if (Request.QueryString["Sid"] != null)
{
int FolderId = Convert.ToInt32(Request.QueryString["Sid"]);
ViewState["FolderId"] = FolderId.ToString();
ddlfolder.SelectedIndex = ddlfolder.Items.IndexOf(ddlfolder.Items.FindByValue(ViewState["FolderId"].ToString()));
fillDatalistwithfolder(Convert.ToInt32(ddlfolder.SelectedValue));
}
else if (Request.QueryString["id"] != null)
{
int DocumentId = Convert.ToInt32(Request.QueryString["id"]);
ViewState["docid"] = DocumentId.ToString();
fillDatalist(DocumentId);
}
else
{
ddlfolder_SelectedIndexChanged(sender, e);
}
}
}
else
{
Response.Redirect("~/Shoppingcart/Admin/Soppingcartlogin.aspx");
}
}
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);
Label1.Visible = false;
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
ViewState["sortOrder"] = "";
TextEntryDate.Text = System.DateTime.Now.ToShortDateString();
lblCompany.Text = Session["Cname"].ToString();
ddlWebsiteName.Enabled = true;
ddlEmailType.Enabled = true;
txtEmailContent.Enabled = true;
TextEntryDate.Enabled = true;
ImageButton1.Enabled = true;
imgaddcatt.Visible = true;
imgcattrefresh.Visible = true;
if (Request.QueryString["Id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["Id"]);
SqlDataAdapter da = new SqlDataAdapter("SELECT * from EmailTypeMaster where EmailTypeId='" + id + "'", con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
FillddlSitename();
ddlWebsiteName.SelectedIndex = ddlWebsiteName.Items.IndexOf(ddlWebsiteName.Items.FindByValue(dt.Rows[0]["Whid"].ToString()));
FillddlEmailType();
ddlEmailType.SelectedIndex = ddlEmailType.Items.IndexOf(ddlEmailType.Items.FindByValue(dt.Rows[0]["EmailTypeId"].ToString()));
filterstore();
filterbyemailtype();
FillGrid();
addemail.Visible = true;
btnadd.Visible = false;
Label1.Visible = false;
contntlabel.Visible = true;
contntlabel.Text = "Draft Pre-Formatted Email";
}
}
else if (Request.QueryString["ViewManageId"] != null)
{
int viewmanageid = Convert.ToInt32(Request.QueryString["ViewManageId"]);
SqlDataAdapter da = new SqlDataAdapter("SELECT * from EmailContentMaster where EmailTypeId='" + viewmanageid + "'", con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
FillddlSitename();
ddlWebsiteName.SelectedIndex = ddlWebsiteName.Items.IndexOf(ddlWebsiteName.Items.FindByValue(dt.Rows[0]["CompanyWebsiteMasterId"].ToString()));
ViewState["Id"] = dt.Rows[0]["EmailContentMasterId"].ToString();
FillddlEmailType();
ddlEmailType.SelectedIndex = ddlEmailType.Items.IndexOf(ddlEmailType.Items.FindByValue(dt.Rows[0]["EmailTypeId"].ToString()));
txtEmailContent.Text = dt.Rows[0]["EmailContent"].ToString();
TextEntryDate.Text = Convert.ToDateTime(dt.Rows[0]["EntryDate"].ToString()).ToShortDateString();
btnadd.Visible = false;
addemail.Visible = true;
btnupdate.Visible = true;
contntlabel.Visible = true;
contntlabel.Text = "Edit Pre-Formatted Email";
btnsubmit.Visible = false;
txtEmailContent.Enabled = true;
TextEntryDate.Enabled = true;
ddlEmailType.Enabled = true;
ddlWebsiteName.Enabled = true;
filterstore();
filterbyemailtype();
FillGrid();
}
else
{
SqlDataAdapter da123 = new SqlDataAdapter("SELECT * from EmailTypeMaster where EmailTypeId='" + viewmanageid + "'", con);
DataTable dt123 = new DataTable();
da123.Fill(dt123);
if (dt123.Rows.Count > 0)
{
FillddlSitename();
ddlWebsiteName.SelectedIndex = ddlWebsiteName.Items.IndexOf(ddlWebsiteName.Items.FindByValue(dt123.Rows[0]["Whid"].ToString()));
FillddlEmailType();
ddlEmailType.SelectedIndex = ddlEmailType.Items.IndexOf(ddlEmailType.Items.FindByValue(dt123.Rows[0]["EmailTypeId"].ToString()));
filterstore();
filterbyemailtype();
FillGrid();
addemail.Visible = true;
btnadd.Visible = false;
Label1.Visible = false;
contntlabel.Visible = true;
contntlabel.Text = "Draft Pre-Formatted Email";
}
}
}
else
{
FillddlSitename();
FillddlEmailType();
filterstore();
filterbyemailtype();
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 (Session["CompanyName"] != null)
{
this.Title = Session["CompanyName"] + " IFileCabinet.com - Manage Email";
}
if (!IsPostBack)
{
ViewState["sortOrder"] = "";
Pagecontrol.dypcontrol(Page, page);
string str = "SELECT WareHouseId,Name,Address,CurrencyId FROM WareHouseMaster where comid = '" + Session["comid"] + "'and WareHouseMaster.Status='" + 1 + "' order by name";
SqlCommand cmd1 = new SqlCommand(str, con);
cmd1.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
ddlstore.DataSource = dt;
ddlstore.DataTextField = "Name";
ddlstore.DataValueField = "WareHouseId";
ddlstore.DataBind();
ddlbusinessfil.DataSource = dt;
ddlbusinessfil.DataTextField = "Name";
ddlbusinessfil.DataValueField = "WareHouseId";
ddlbusinessfil.DataBind();
ddlbusinessfil.Items.Insert(0, "All");
ddlbusinessfil.Items[0].Value = "0";
DataTable dsss = new DataTable();
dsss = clsMessage.Empid(ddlstore.SelectedValue);
if (dsss.Rows.Count > 0)
{
Session["EmployeeIdep"] = dsss.Rows[0]["EmployeeMasterId"].ToString();
}
else
{
Session["EmployeeIdep"] = "0";
}
ddlempfil.Items.Insert(0, "All");
ddlempfil.Items[0].Value = "0";
ddlemp.Items.Insert(0, "Select");
ddlemp.Items[0].Value = "0";
ViewState["Dltitem"] = "";
lblCompany.Text = Session["comid"].ToString();
lblBusiness.Text = "All";
FillGrid();
imgupdate.Visible = false;
imgbtnsubmitCabinetAdd.Visible = true;
//imgcancel.Visible = false;
}
}
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();
compid = Session["Comid"].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.Text = "";
lblmsg.Visible = false;
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
//fillddlclass();
if (txtdateto.Text.Length <= 0)
{
txtdateto.Text = DateTime.Now.ToShortDateString();
}
if (txtdatefrom.Text.Length <= 0)
{
txtdatefrom.Text = DateTime.Now.ToShortDateString();
}
ViewState["sortOrder"] = "";
fillstore();
lblcompname.Text = Session["Cname"].ToString();
if (Request.QueryString["Gd"] != null && Request.QueryString["Wh"] != null)
{
Panel1.Visible = true;
ddlSearchByStore.SelectedValue = Request.QueryString["Wh"];
ddlSearchByStore_SelectedIndexChanged(sender, e);
txtdatefrom.Text = Session["ddf"].ToString();
txtdateto.Text = Session["dde"].ToString();
DataTable drt = select("select [ClassCompanyMaster].[id],[GroupCompanyMaster].[id] as gid from [GroupCompanyMaster] inner join [ClassCompanyMaster] on [ClassCompanyMaster].id = [GroupCompanyMaster].classcompanymasterid where [GroupCompanyMaster].GroupId = '" + Request.QueryString["Gd"] + "' and [GroupCompanyMaster].Whid='" + ddlSearchByStore.SelectedValue + "' ");
if (drt.Rows.Count > 0)
{
ddlclass.SelectedIndex = ddlclass.Items.IndexOf(ddlclass.Items.FindByValue(drt.Rows[0]["id"].ToString()));
}
ddlclass_SelectedIndexChanged(sender, e);
ddlgroup.SelectedIndex = ddlgroup.Items.IndexOf(ddlgroup.Items.FindByValue(drt.Rows[0]["gid"].ToString()));
imgbtngo_Click(sender, e);
}
else
{
ddlSearchByStore_SelectedIndexChanged(sender, e);
}
}
}
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 (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
ViewState["sortOrder"] = "";
lblcomid.Text = Session["Cname"].ToString();
flaganddoc();
//lblcomname.Text = "All";
string str = "SELECT WareHouseId,Name,Address,CurrencyId FROM WareHouseMaster where comid = '" + Session["comid"] + "'and WareHouseMaster.Status='" + 1 + "' order by name";
SqlCommand cmd1 = new SqlCommand(str, con);
cmd1.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
ddlbusiness.DataSource = dt;
ddlbusiness.DataTextField = "Name";
ddlbusiness.DataValueField = "WareHouseId";
ddlbusiness.DataBind();
ddlstore.DataSource = dt;
ddlstore.DataTextField = "Name";
ddlstore.DataValueField = "WareHouseId";
ddlstore.DataBind();
ddlstore.Items.Insert(0, "All");
ddlstore.Items[0].Value = "0";
string eeed = " Select distinct EmployeeMaster.Whid from EmployeeMaster where EmployeeMasterId='" + Session["EmployeeId"] + "'";
SqlCommand cmdeeed = new SqlCommand(eeed, con);
SqlDataAdapter adpeeed = new SqlDataAdapter(cmdeeed);
DataTable dteeed = new DataTable();
adpeeed.Fill(dteeed);
if (dteeed.Rows.Count > 0)
{
ddlbusiness.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
RadioButtonList1_SelectedIndexChanged(sender, e);
FillDocumentTypeAll();
FillParty();
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();
Page.Title = pg.getPageTitle(page);
if (!IsPostBack)
{
Label1.Text = "";
lblfilen.Text = "";
ViewState["sortOrder"] = "";
Pagecontrol.dypcontrol(Page, page);
DataTable ds = ClsStore.SelectStorename();
ddlWarehouse.DataSource = ds;
ddlWarehouse.DataTextField = "Name";
ddlWarehouse.DataValueField = "WareHouseId";
ddlWarehouse.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlWarehouse.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
//string strwh = "SELECT WareHouseId,Name,Address,CurrencyId FROM WareHouseMaster where comid='" + Session["comid"] + "'and Status='1' order by Name ";
//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();
if (ddlWarehouse.SelectedIndex > -1)
{
FillddlInvCat();
ddlInvCat_SelectedIndexChanged(sender, e);
}
DropDownList2.DataSource = (DataSet)fillMediaType();
DropDownList2.DataTextField = "MediaFileType";
DropDownList2.DataValueField = "MediaFileTypeID";
DropDownList2.DataBind();
DropDownList2.Items.Insert(0, "-Select-");
DropDownList2.Items[0].Value = "0";
}
}
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[] { '/' };
// 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);
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
if (!Page.IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
if (Request.QueryString["Id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["Id"]);
string strii = "select distinct VacancyMasterTbl.*,case when (VacancyMasterTbl.status='1') then 'Active' else 'Inactive' End as Statuslabel,WareHouseMaster.Name as wname,DepartmentmasterMNC.Departmentname + ' - ' + DesignationMaster.DesignationName as dname,VacancyTypeMaster.Name as vname,VacancyPositionTitleMaster.VacancyPositionTitle as vtitle from VacancyMasterTbl inner join WareHouseMaster on WareHouseMaster.WareHouseId=VacancyMasterTbl.businessid inner join DesignationMaster on DesignationMaster.DesignationMasterId=VacancyMasterTbl.DesignationID inner join DepartmentmasterMNC on DesignationMaster.DeptID=DepartmentmasterMNC.id inner join VacancyTypeMaster on VacancyTypeMaster.ID=VacancyMasterTbl.vacancypositiontypeid inner join VacancyPositionTitleMaster on VacancyPositionTitleMaster.ID=VacancyMasterTbl.vacancypositiontitleid where VacancyMasterTbl.ID='" + id + "'";
SqlDataAdapter da = new SqlDataAdapter(strii, con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
lblbusiness.Text = Convert.ToString(dt.Rows[0]["wname"]);
//lbldepdes.Text = Convert.ToString(dt.Rows[0]["dname"]);
//lblvactype.Text = Convert.ToString(dt.Rows[0]["vname"]);
lblvactitle.Text = Convert.ToString(dt.Rows[0]["vtitle"]);
//lblnovac.Text = Convert.ToString(dt.Rows[0]["noofvacancy"]);
//lblstart.Text = Convert.ToDateTime(dt.Rows[0]["startdate"].ToString()).ToShortDateString();
//lblend.Text = Convert.ToDateTime(dt.Rows[0]["enddate"].ToString()).ToShortDateString();
lblemail.Text = Convert.ToString(dt.Rows[0]["contactEmail"]);
lblpername.Text = Convert.ToString(dt.Rows[0]["contactname"]);
lblphonno.Text = Convert.ToString(dt.Rows[0]["contactphoneno"]);
lbladdress.Text = Convert.ToString(dt.Rows[0]["contactAddress"]);
//lblschedule.Text = Convert.ToString(dt.Rows[0]["worktimings"]);
lblsal2.Text = Convert.ToString(dt.Rows[0]["salaryamount"]);
// lblhour.Text = Convert.ToString(dt.Rows[0]["hours"]);
if (Convert.ToBoolean(dt.Rows[0]["applybyemail"]) == true)
{
lblbyemail.Visible = true;
}
else
{
lblbyemail.Visible = false;
}
if (Convert.ToBoolean(dt.Rows[0]["applybyphone"]) == true)
{
lblphonno.Visible = true;
}
else
{
lblphonno.Visible = false;
}
if (Convert.ToBoolean(dt.Rows[0]["applybyvisit"]) == true)
{
Label13.Visible = true;
}
else
{
Label13.Visible = false;
}
if (Convert.ToBoolean(dt.Rows[0]["applyonline"]) == true)
{
Label20.Visible = true;
}
else
{
Label20.Visible = false;
}
}
SqlDataAdapter dac = new SqlDataAdapter("select [CityMasterTbl].[CityName],StateMasterTbl.[StateName],CountryMaster.[CountryName] from [CityMasterTbl] inner join VacancyMasterTbl on VacancyMasterTbl.cityid=[CityMasterTbl].[CityId] inner join StateMasterTbl on StateMasterTbl.StateId=VacancyMasterTbl.stateid inner join CountryMaster on CountryMaster.CountryId=VacancyMasterTbl.countryid where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtc = new DataTable();
dac.Fill(dtc);
if (dtc.Rows.Count > 0)
{
lblcountry.Text = Convert.ToString(dtc.Rows[0]["CountryName"]);
lblstate.Text = Convert.ToString(dtc.Rows[0]["StateName"]);
lblcity.Text = Convert.ToString(dtc.Rows[0]["CityName"]);
}
SqlDataAdapter dac1 = new SqlDataAdapter("select VacancyDetailTbl.* from VacancyDetailTbl inner join VacancyMasterTbl on VacancyMasterTbl.ID=VacancyDetailTbl.vacancymasterid where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtc1 = new DataTable();
dac1.Fill(dtc1);
if (dtc1.Rows.Count > 0)
{
lbljobfun.Text = Convert.ToString(dtc1.Rows[0]["JobFunction"]);
lblqualifi.Text = Convert.ToString(dtc1.Rows[0]["QualificationRequirements"]);
lblTandC.Text = Convert.ToString(dtc1.Rows[0]["TermsandConditions"]);
}
SqlDataAdapter dac11 = new SqlDataAdapter("select Name from VacancyFTPT inner join VacancyMasterTbl on VacancyMasterTbl.vacancyftptid=VacancyFTPT.Id where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtc11 = new DataTable();
dac11.Fill(dtc11);
if (dtc11.Rows.Count > 0)
{
lblduration.Text = Convert.ToString(dtc11.Rows[0]["Name"]);
}
SqlDataAdapter dasl = new SqlDataAdapter("select CurrencyMaster.CurrencyName from CurrencyMaster inner join VacancyMasterTbl on VacancyMasterTbl.currencyid=CurrencyMaster.CurrencyId where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtsl = new DataTable();
dasl.Fill(dtsl);
if (dtsl.Rows.Count > 0)
{
lblsal1.Text = Convert.ToString(dtsl.Rows[0]["CurrencyName"]);
}
SqlDataAdapter dasl11 = new SqlDataAdapter("select SalaryPerPeriodMaster.Name from SalaryPerPeriodMaster inner join VacancyMasterTbl on VacancyMasterTbl.salaryperperiodid=SalaryPerPeriodMaster.ID where VacancyMasterTbl.ID='" + id + "'", con);
DataTable dtsl11 = new DataTable();
dasl11.Fill(dtsl11);
if (dtsl11.Rows.Count > 0)
{
lblsal3.Text = Convert.ToString(dtsl11.Rows[0]["Name"]);
}
}
}
}
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);
if (Request.QueryString["gatepass"] != null)
{
Session["Gatepass"] = Request.QueryString["gatepass"].ToString();
}
lblDateTime.Text = System.DateTime.Now.ToShortDateString();
string gtpsrq = "select Gatepassdetails.ID,Gatepassdetails.TimeReached,Gatepassdetails.TimeLeft,Gatepassdetails.TaskId,Gatepassdetails.GatePassId,GatepassDetails.ID,GatepassDetails.PurposeofVisit,GatePassTBL.ExpectedOutTime,GatepassTBL.ExpectedInTime,GatepassDetails.PartyID,EmployeeMaster.EmployeeName,Party_master.Compname as 'PartyName' from GatepassTBL inner join GatepassDetails on GatepassDetails.GatePassID=GatepassTBL.Id inner join Party_master on GatepassDetails.PartyID = Party_master.PartyID inner join EmployeeMaster on EmployeeMaster.EmployeeMasterID=GatepassTBL.EmployeeID where GatepassDetails.GatePassID = '" + Session["Gatepass"].ToString() + "' ";//GatePassNumber NOT NULL
SqlCommand cmdrq = new SqlCommand(gtpsrq, con);
SqlDataAdapter adpt = new SqlDataAdapter(cmdrq);
DataSet dsrq = new DataSet();
adpt.Fill(dsrq);
if (dsrq.Tables[0].Rows.Count > 0)
{
SqlDataAdapter daaa = new SqlDataAdapter("select Gatepassdetails.* from GatepassTBL inner join GatepassDetails on GatepassDetails.GatePassID=GatepassTBL.Id inner join Party_master on GatepassDetails.PartyID = Party_master.PartyID inner join EmployeeMaster on EmployeeMaster.EmployeeMasterID=GatepassTBL.EmployeeID where GatepassDetails.GatePassID = '" + Session["Gatepass"].ToString() + "' and GatepassDetails.Detail IS NULL ", con);
DataTable dtaaa = new DataTable();
daaa.Fill(dtaaa);
if (dtaaa.Rows.Count > 0)
{
btnSubmit.Visible = true;
lblExpIn.Text = dsrq.Tables[0].Rows[0]["ExpectedInTime"].ToString();
lblExpOut.Text = dsrq.Tables[0].Rows[0]["ExpectedOutTime"].ToString();
lblactualouttime.Text = dsrq.Tables[0].Rows[0]["TimeReached"].ToString();
lblactualintime.Text = dsrq.Tables[0].Rows[0]["TimeLeft"].ToString();
lblEmployeeName.Text = dsrq.Tables[0].Rows[0]["EmployeeName"].ToString();
lblgatepass.Text = dsrq.Tables[0].Rows[0]["GatePassId"].ToString();
grdreturn.DataSource = dsrq;
grdreturn.DataBind();
DateTime tme1 = Convert.ToDateTime(lblExpIn.Text);
DateTime tme2 = Convert.ToDateTime(lblExpOut.Text);
TimeSpan t11 = ((Convert.ToDateTime(tme1)) - Convert.ToDateTime(tme2));
string a1 = t11.Hours.ToString();
string a2 = t11.Minutes.ToString();
lblTotalTime.Text = a1 + " : " + a2;
if (lblactualouttime.Text != "" && lblactualintime.Text != "")
{
DateTime tme11 = Convert.ToDateTime(lblactualintime.Text);
DateTime tme22 = Convert.ToDateTime(lblactualouttime.Text);
TimeSpan t111 = ((Convert.ToDateTime(tme11)) - Convert.ToDateTime(tme22));
string a11 = t111.Hours.ToString();
string a22 = t111.Minutes.ToString();
lblactualduration.Text = a11 + " : " + a22;
}
else
{
lblactualouttime.Text = "0";
lblactualintime.Text = "0";
lblactualduration.Text = "0";
}
}
else
{
grdreturn.DataSource = null;
grdreturn.DataBind();
btnSubmit.Visible = false;
}
}
}
}
