protected void Page_Load(object sender, EventArgs e) { ConnKey = Session["ConnStr"].ToString(); if (!IsPostBack) { try { lblDate.Text = DateTime.Now.ToString("dd-MM-yyyy"); imgstate.ImageUrl = "~/img/" + Session["statecd"].ToString().Trim() + ".png"; lblstatename.Text = "GOVERNMENT OF " + Session["statename"].ToString(); /*BY DEFAULT SET TODAYS DATE AS FROM AND TO DATE*/ txtFromDate.Text = txtToDt.Text = DateTime.Today.ToString("dd/MM/yyyy"); /*Bind Districts*/ ddt = objMstBL.getDistrictsByStateCodeBAL(Session["statecd"].ToString(), ConnKey); objCommon.BindDropDownLists(ddlDist, ddt, "DistName", "DistCode", "0"); ddlDrug.Items.Clear(); ddlDrug.Items.Insert(0, new ListItem("Select", "0")); //getReport(); } catch (Exception ex) { Response.Redirect("~/Error.aspx"); } } }
protected void BindClass() { objBE.Action = "CLS"; objBE.Id = Department; dt = ObjDL.Getdetails(objBE, con); cf.BindDropDownLists(ddlClass, dt, "class_name", "class_id", "0"); }
protected void Page_Load(object sender, EventArgs e) { ConnKey = Session["ConnStr"].ToString(); if (!IsPostBack) { lblDate.Text = DateTime.Now.ToString("dd-MM-yyyy"); try { imgstate.ImageUrl = "~/img/" + Session["statecd"].ToString().Trim() + ".png"; lblstatename.Text = "GOVERNMENT OF " + Session["statename"].ToString(); txtFromDate.Text = txtToDt.Text = DateTime.Today.ToString("dd/MM/yyyy"); /*Bind States - By Default set State as TELANGANA*/ /*Bind Districts*/ ddt = objMstBL.getDistrictsByStateCodeBAL(Session["statecd"].ToString(), ConnKey); objCommon.BindDropDownLists(ddlDist, ddt, "DistName", "DistCode", "0"); } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex, "Public", Request.ServerVariables["REMOTE_ADDR"].ToString()); Response.Redirect("~/Error.aspx"); } } }
//BindZone protected void BindZone() { objR.Action = "DI"; objR.dept = Department; dt = Objrdl.SampleRegister(objR, con); cf.BindDropDownLists(ddlDiName, dt, "NAME", "Zone_Cd", "0"); }
protected void Page_Load(object sender, EventArgs e) { ConnKey = Session["ConnStr"].ToString(); if (!IsPostBack) { try { imgstate.ImageUrl = "~/img/" + Session["statecd"].ToString().Trim() + ".png"; lblstatename.Text = "GOVERNMENT OF " + Session["statename"].ToString(); lblDate.Text = DateTime.Now.ToString("dd-MM-yyyy"); /*BY DEFAULT SET TODAYS DATE AS FROM AND TO DATE*/ txtFromDate.Text = txtToDt.Text = DateTime.Today.ToString("dd/MM/yyyy"); /*Bind States - By Default set State as TELANGANA*/ /*Bind Districts*/ ddt = objMstBL.getDistrictsByStateCodeBAL(Session["statecd"].ToString(), ConnKey); objCommon.BindDropDownLists(ddlDist, ddt, "DistName", "DistCode", "0"); //getReport(); /*BIND START TIME & END TIME*/ ddlStartTime.DataSource = GenerateTime(8, 24); ddlStartTime.DataBind(); ddlEndTime.DataSource = GenerateTime(Convert.ToInt16(ddlStartTime.SelectedItem.Text) + 1, 24); ddlEndTime.DataBind(); ddlEndTime.SelectedValue = ddlEndTime.Items.FindByText("24").Value; } catch (Exception ex) { Response.Redirect("~/Error.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if ((Request.ServerVariables["HTTP_REFERER"] == null) || (Request.ServerVariables["HTTP_REFERER"] == "")) { Response.Redirect("~/Error.aspx"); } else { string http_ref = Request.ServerVariables["HTTP_REFERER"].Trim(); string http_hos = Request.ServerVariables["HTTP_HOST"].Trim(); int len = http_hos.Length; if (http_ref.IndexOf(http_hos, 0) < 0) { Response.Redirect("~/Error.aspx"); } } if (Session["Role"].ToString() == null || Session["Role"].ToString() != "3") { Response.Redirect("~/Error.aspx"); } lblUsrName.Text = Session["UsrName"].ToString(); lblDate.Text = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; StateCode = Session["StateCd"].ToString(); UserName = Session["UsrName"].ToString(); ConnKey = Session["ConnStr"].ToString(); if (!IsPostBack) { try { imgstate.ImageUrl = "~/img/" + Session["statecd"].ToString().Trim() + ".png"; lblstatename.Text = "GOVERNMENT OF " + Session["statename"].ToString(); ddt = objPhar.getdrug(ConnKey); objCommon.BindDropDownLists(ddl_Drug, ddt, "DrugName", "DrugCode", "0"); ddt = objPhar.getsuply(ConnKey); objCommon.BindDropDownLists(ddl_Suply, ddt, "SupplierName", "SupplierCode", "0"); btn_Update.Visible = false; Viewdata(); GetInsNameBAL(); GetYear(); for (int month = 1; month <= 12; month++) { string monthName = DateTimeFormatInfo.CurrentInfo.GetMonthName(month); ddl_Month.Items.Add(new ListItem(monthName, month.ToString().PadLeft(2, '0'))); } } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString()); Response.Redirect("~/Error.aspx"); } // Calendar1.StartDate = DateTime.Now; //to dissable past Date } //ExCalender.StartDate = DateTime.Now; }
protected void BindCategory() { objR.AnalystId = Session["Labcode"].ToString(); objR.Action = "UCRT"; dt = Objrdl.searchsample(objR, con); cf.BindDropDownLists(ddlCategory, dt, "Category_Name", "Category_ID", "Select"); }
protected void BindCategory() { objBE.Id = Department; objBE.Action = "CAT"; dt = ObjDL.Getdetails(objBE, con); ObjCommon.BindDropDownLists(ddlSampleCat, dt, "category_name", "category_id", "0"); }
protected void Page_Load(object sender, EventArgs e) { ConnKey = Session["ConnStr"].ToString(); if (!IsPostBack) { lblDate.Text = DateTime.Now.ToString("dd-MM-yyyy"); try { imgstate.ImageUrl = "~/img/" + Session["statecd"].ToString().Trim() + ".png"; lblstatename.Text = "GOVERNMENT OF " + Session["statename"].ToString(); /*BY DEFAULT SET TODAYS DATE AS FROM AND TO DATE*/ txtFromDate.Text = txtToDt.Text = DateTime.Today.ToString("dd/MM/yyyy"); /*Bind States - By Default set State as TELANGANA*/ //ddt = objMstBL.getstate( ConnKey); //objCommon.BindDropDownLists(ddlState, ddt, "StateName", "StateCode", "0"); //ddlState.SelectedValue = "05"; //ddlState.Enabled = false; /*Bind Districts*/ ddt = objMstBL.getDistrictsByStateCodeBAL(Session["statecd"].ToString(), ConnKey); objCommon.BindDropDownLists(ddlDist, ddt, "DistName", "DistCode", "0"); //getReport(); } catch (Exception ex) { Response.Redirect("~/Error.aspx"); } } }
protected void BindProtocol() { dt = new DataTable(); Obj.Action = "PROTOCOL"; dt = ObjDAL.Getdetails(Obj, con); cf.BindDropDownLists(ddlprotocol, dt, "ProtocolName", "Protocolid", "Select"); }
protected void BindSamples() { dt = new DataTable(); objBE.dept = Department; objBE.Action = "SMPL"; dt = Objrdl.GenerateSticker(objBE, con); cf.BindDropDownLists(ddlsample, dt, "SampleID", "SampleID", "Select"); }
protected void BindRoles() { MstObj.Action = "ROLE"; MstObj.Id = Department; dt = MstDL.Getdetails(MstObj, con); ObjCommon.BindDropDownLists(ddlRole, dt, "RoleName", "Role_Id", "Select"); }
protected void BindMemos() { dt = new DataTable(); objBE.UserId = deocode; objBE.Action = "MEMO"; dt = objRDL.SampleRegister(objBE, con); cf.BindDropDownLists(ddlmemo, dt, "Memo_ID", "Memo_ID", "Select"); }
protected void BindMemos() { dt = new DataTable(); objBE.Action = "VMEMO"; objBE.dept = Department; dt = Objrdl.SampleRegister(objBE, con); cf.BindDropDownLists(ddlmemo, dt, "Memo_ID", "Memo_ID", "Select"); }
protected void BindCategory() { objR.Action = "C"; objR.SampleID = null; dt = Objrdl.searchsample(objR, con); cf.BindDropDownLists(ddlCategory, dt, "Category_Name", "Category_ID", "Select"); }
protected void BindCategory() { dt = new DataTable(); objBE.Dept = Session["Department"].ToString(); objBE.Action = "R"; dt = ObjDL.CategoryIUDR(objBE, con); ObjCommon.BindDropDownLists(ddlCategory, dt, "category_name", "category_id", "Select"); ddlCategory.SelectedValue = "30"; ddlCategory.Enabled = false; }
protected void BindSamples() { dt = new DataTable(); objBE.Action = "SMPL"; objBE.labID = Session["Labcode"].ToString(); dt = ObjDL.UOAction(objBE, con); if (dt.Rows.Count > 0) { cf.BindDropDownLists(ddlsample, dt, "SampleID", "SampleID", "Select"); } }
/*BIND DRUGS FOR WHICH AVERAGE CONSUMPTION IS NOT YET PROPOSED*/ protected void BindNoAvgConsumptionDtls_Drugs() { try { DataTable dtDrugs = objPhar.getInstdrugBAL(Session["UniqueInstId"].ToString(), ConnKey); objCommon.BindDropDownLists(ddl_drug, dtDrugs, "DrugName", "DrugCode", "0"); } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString()); Response.Redirect("~/Error.aspx"); } }
protected void BindLabs() { objMBE.Action = "R"; objMBE.statecode = Session["StateCode"].ToString(); objMBE.Dept = Department; dt = ObjDL.Lab_IUDR(objMBE, con); if (dt.Rows.Count > 0) { cf.BindDropDownLists(ddlunit, dt, "LabName", "LabCode", "Select"); } else { cf.ShowAlertMessage("No Labs Added"); } }
private void BindSchemes() { try { DataTable dt1 = new DataTable(); objBE.Action = "S"; dt1 = objMst.SchemeMst_IUDR_BAL(objBE, ConnKey); objCommon.BindDropDownLists(ddlScheme, dt1, "SchemeName", "SchemeCode", "0"); } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString()); Response.Redirect("~/Error.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if ((Request.ServerVariables["HTTP_REFERER"] == null) || (Request.ServerVariables["HTTP_REFERER"] == "")) { Response.Redirect("~/Error.aspx"); } else { string http_ref = Request.ServerVariables["HTTP_REFERER"].Trim(); string http_hos = Request.ServerVariables["HTTP_HOST"].Trim(); int len = http_hos.Length; if (http_ref.IndexOf(http_hos, 0) < 0) { Response.Redirect("~/Error.aspx"); } } if (Session["Role"].ToString() == null || Session["Role"].ToString() != "6") { Response.Redirect("~/Error.aspx"); } lblUsrName.Text = Session["UsrName"].ToString(); lblDate.Text = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; StateCode = Session["StateCd"].ToString(); UserName = Session["UsrName"].ToString(); ConnKey = Session["ConnStr"].ToString(); if (!IsPostBack) { try { /*Bind States - By Default set State as TELANGANA*/ ddt = objMstBL.getstate(ConnKey); objCommon.BindDropDownLists(ddlState, ddt, "StateName", "StateCode", "0"); ddlState.SelectedValue = "36"; ddlState.Enabled = false; /*Bind Districts*/ ddt = objMstBL.getDistrictsByStateCodeBAL(ddlState.SelectedValue.ToString(), ConnKey); objCommon.BindDropDownLists(ddlDist, ddt, "DistName", "DistCode", "0"); txtDate.Text = DateTime.Today.AddDays(-1).ToString("dd/MM/yyyy"); } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString()); Response.Redirect("~/Error.aspx"); } } }
protected void BindState() { try { string ConnKey = ""; ConnKey = ConfigurationManager.ConnectionStrings["ConnStrCentral"].ToString(); ddt = objDist.getstate(ConnKey); DataRow[] foundRows; DataTable results = new DataTable(); // Use the Select method to find all rows matching the filter. foundRows = ddt.Select("act_status=1"); if (foundRows.Length > 0) { results = ddt.Select("act_status=1").CopyToDataTable(); } objCommon.BindDropDownLists(ddlstate, results, "StateName", "StateCode", "0"); results = new DataTable(); foundRows = ddt.Select("act_status=1 or Requested_dt is not null"); if (foundRows.Length > 0) { results = ddt.Select("act_status=1 or Requested_dt is not null").CopyToDataTable(); } gvstatus.DataSource = results; gvstatus.DataBind(); } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString()); Response.Redirect("~/Error.aspx"); } }
protected void BindDept() { dt = new DataTable(); objbe.Action = "DEPT"; dt = objm.Getdetails(objbe, con); cf.BindDropDownLists(ddldept, dt, "Dept_Des", "Dept_Code", "Select Department"); }
protected void Rdbaceptrjctlist_SelectedIndexChanged(object sender, EventArgs e) { RadioButtonList Dropdown = sender as RadioButtonList; GridViewRow gRow = (GridViewRow)Dropdown.NamingContainer; RadioButtonList rblaceptrjct = ((RadioButtonList)(gRow.FindControl("Rdbaceptrjctlist"))); DropDownList ddlrejected = ((DropDownList)(gRow.FindControl("ddlrjctreson"))); Button buttongrid = ((Button)(gRow.FindControl("btnAck"))); GVAck.TemplateControl.Visible = true; if (rblaceptrjct.SelectedValue == "R") { ddlrejected.Enabled = true; objMBE.Dept = dept; objMBE.Action = "R"; dt = ObjMDL.RejectedReasons(objMBE, con); ObjCommon.BindDropDownLists(ddlrejected, dt, "Reject_Reason", "ID", "Select"); buttongrid.Visible = true; buttongrid.Text = "Rejected"; buttongrid.BackColor = System.Drawing.Color.Red; } else { buttongrid.Visible = true; buttongrid.Text = "Aproove"; buttongrid.BackColor = System.Drawing.Color.Green; ddlrejected.Enabled = false; } }
protected void BindSampleId() { dt = new DataTable(); objBE.DI_AO_Code = DI_AO_code; objBE.Action = "F"; dt = objdi.SampleRegistrationDI(objBE, con); cf.BindDropDownLists(ddlSamId, dt, "RegID", "RegID", "Select Sample Id"); }
protected void Bindreject() { dt = new DataTable(); objMBE.Dept = Department; objMBE.Action = "R"; dt = ObjDL.RejectedReasons(objMBE, con); cf.BindDropDownLists(ddlrejctreson, dt, "Reject_Reason", "ID", "Select"); }
protected void BindCategory() { dt = new DataTable(); objBE.Id = Session["Department"].ToString(); objBE.Action = "CAT"; dt = ObjDL.Getdetails(objBE, con); ObjCommon.BindDropDownLists(ddlCategory, dt, "category_name", "category_id", "Select"); }
protected void BindCrop() { dt = new DataTable(); objBE.Dept = Session["Department"].ToString(); objBE.Action = "R"; dt = ObjDL.CropIUDR(objBE, con); cf.BindDropDownLists(ddlcrop, dt, "CropName", "CropCode", "Select"); }
protected void Page_Load(object sender, EventArgs e) { if ((Request.ServerVariables["HTTP_REFERER"] == null) || (Request.ServerVariables["HTTP_REFERER"] == "")) { Response.Redirect("~/Error.aspx"); } else { string http_ref = Request.ServerVariables["HTTP_REFERER"].Trim(); string http_hos = Request.ServerVariables["HTTP_HOST"].Trim(); int len = http_hos.Length; if (http_ref.IndexOf(http_hos, 0) < 0) { Response.Redirect("~/Error.aspx"); } } if (Session["Role"].ToString() == null || Session["Role"].ToString() != "1") { Response.Redirect("~/Error.aspx"); } lblUsrName.Text = Session["UsrName"].ToString(); UserName = Session["UsrName"].ToString(); StateCode = Session["StateCd"].ToString(); lblDate.Text = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; ConnKey = Session["ConnStr"].ToString(); if (!IsPostBack) { try { imgstate.ImageUrl = "~/img/" + Session["statecd"].ToString().Trim() + ".png"; lblstatename.Text = "GOVERNMENT OF " + Session["statename"].ToString(); ddt = objDist.getDistrictsByStateCodeBAL(StateCode, ConnKey); objCommon.BindDropDownLists(ddl_dist_code, ddt, "DistName", "DistCode", "0"); ddt = objDist.viewInstitutiondataBAL(ConnKey); objCommon.BindDropDownLists(ddl_Institution, ddt, "InstitutionTypeDesc", "InstitutionTypeCode", "0"); this.txt_Date.Text = DateTime.Today.ToString("dd/MM/yyyy"); btn_Update.Visible = false; } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString()); Response.Redirect("~/Error.aspx"); } } }
protected void BindSamples() { dt = new DataTable(); objBE.dept = Department; objBE.SampleCategory = Category; objBE.Action = "MEMO"; dt = Objrdl.GenerateSticker_AGRI(objBE, con); cf.BindDropDownLists(ddlmemo, dt, "Memo_ID", "Memo_ID", "Select"); }