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");
}
