protected void DDLAGE_SelectedIndexChanged(object sender, EventArgs e)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("AGRP_ID", DDLAGE.SelectedValue.ToString());
ATCommon.FillDrpDown(DDLDIS, DBManager.Get(vHashtable, "CMB_DIS_AGE"), "Select Disorder Name", "DIS_NAME", "DIS_ID", "");
}
protected void DDLCAT_SelectedIndexChanged(object sender, EventArgs e)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("DCAT_ID", DDLCAT.SelectedValue.ToString());
ATCommon.FillDrpDown(DDLSUBCAT, DBManager.Get(vHashtable, "CMB_CATEGORY_ID"), "Select Sub Category Name", "DSCAT_DESC", "DSCAT_ID", "");
}
protected void ANALYSIS_DDL_SelectedIndexChanged(object sender, EventArgs e)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("ANM_ID", ANALYSIS_DDL.SelectedValue.ToString());
ATCommon.FillDrpDown(DDLAGE, DBManager.Get(vHashtable, "CMB_AGEGRP"), "Select Group Name", "AGRP_GROUP", "AGRP_ID", "");
}
protected void DDLRECOMMENDATION_SelectedIndexChanged(object sender, EventArgs e)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("RECOM_ID", DDLRECOMMENDATION.SelectedValue.ToString());
ATCommon.FillDrpDown(DDLDESC, DBManager.Get(vHashtable, "CMB_RECOMD_DESC"), "Select Description Name", "RECOMD_DESC", "RECOMD_ID", "");
}
public static System.Data.DataTable RetDT(String pQry)
{
using (SqlConnection vConnection = ATCommon.GetConnection())
{
SqlDataAdapter vDataAdapter = new SqlDataAdapter(pQry, vConnection);
DataSet vDataSet = new DataSet();
vDataAdapter.Fill(vDataSet);
return(vDataSet.Tables[0].Copy());
}
}
protected void RegioanlHQ_DDL_SelectedIndexChanged(object sender, EventArgs e)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("STATE_ID", RegioanlHQ_DDL.SelectedValue.ToString());
ATCommon.FillDrpDown(AreaHQ_DDL, DBManager.Get(vHashtable, "CMB_City"), "Select City Name", "CITY_NAME", "CITY_ID", "");
AreaHQ_DDL.Enabled = true;
UP_AreaHQ.Update();
UP_RegioanlHQ.Update();
}
protected void ddl_state_SelectedIndexChanged(object sender, EventArgs e)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("STATE_ID", ddl_state.SelectedValue.ToString());
ATCommon.FillDrpDown(CUST_STATION_DDL, DBManager.Get(vHashtable, "CMB_City"), "Select City Name", "CITY_NAME", "CITY_ID", "");
CUST_STATION_DDL.Enabled = true;
UP_STATION.Update();
up_state.Update();
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
PTP_TXT.Text = vATSession.UserName;
if (vATSession.UserType == "ADMIN")
{
GridView1.Visible = true;
hidden1.Visible = true;
}
else
{
GridView1.Visible = true;
}
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(COND_ID, DBManager.Get(new Hashtable(), "CMB_CONDITION_MASTER"), "Select Condition Name", "COND_NAME", "COND_ID", "0");
ATCommon.FillDrpDown(DEVCOND_ID, DBManager.Get(new Hashtable(), "CMB_DEVELOPMENT_MASTER"), "Select Development Condition Name", "DEV_NAME", "DEV_ID", "0");
if (vID != null)
{
PTP_ID.Value = vID;
Hashtable vHashtable = new Hashtable();
vHashtable.Add("PTP_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_PATIENT_DETAIL"));
if (vDR != null)
{
PTP_ID.Value = vID;
vID = vDR["PTP_ID"].ToString();
PTP_TXT.Text = vDR["PTP_NAME"].ToString();
}
else
{
ShowMsg("Invalid ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
try
{
ATCommon.FillDrpDown(DDLAGE, DBManager.Get(new Hashtable(), "CMB_AGE_SCREEN_MASTER"), "Select Group Name", "AGRP_GROUP", "AGRP_ID", "0");
ATCommon.FillCDWR(EVALUATION_DDL, DBManager.Get(new Hashtable(), "CMB_EVALUATION"), "Select Evaluation Name", "EVA_NAME", "EVA_ID", "");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("RPT_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_MASTER_REPORT_ID"));
if (vDR != null)
{
TXTID.Value = vDR["RPT_ID"].ToString();
REPORT_TXT.Text = vDR["RPT_NAME"].ToString();
DDLAGE.Text = vDR["AGRP_ID"].ToString();
REPORT_TXT.Enabled = false;
DDLAGE.Enabled = false;
SAVEBTN.Visible = false;
Textarea1.InnerText = vDR["RPTD_REPREASON"].ToString();
Textarea2.InnerText = vDR["RPTD_MED"].ToString();
Textarea3.InnerText = vDR["RPTD_PTMID"].ToString();
Textarea4.InnerText = vDR["RPTD_PTFHID"].ToString();
Textarea5.InnerText = vDR["RPTD_DOBSID"].ToString();
Textarea11.InnerText = vDR["RPTD_DST"].ToString();
Textarea17.InnerText = vDR["RPTD_RECOM"].ToString();
Get_Evaluation_Name(EVALUATION_DDL, vDR["RPTD_EVAID"].ToString(), true);
}
else
{
ShowMsg("Invalid Patient ID");
}
}
EVALUATION_DDL.Enabled = true;
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void DDLSUBCAT_SelectedIndexChanged(object sender, EventArgs e)
{
String vID = Request.QueryString["ID"];
Hashtable vHashtable = new Hashtable();
vHashtable.Add("DSCAT_ID", DDLSUBCAT.SelectedValue.ToString());
vHashtable.Add("IEPDT_ID", vID);
ATCommon.FillDrpDown(DDLIEA, DBManager.Get(vHashtable, "CMB_SUBCATEGORY"), "Select IEP Skill Activity", "IEPA_NAME", "IEPA_ID", "");
Hashtable vHashtable2 = new Hashtable();
vHashtable2.Add("DCAT_ID", DDLCAT.SelectedValue.ToString());
vHashtable2.Add("DSCAT_ID", DDLSUBCAT.SelectedValue.ToString());
ATCommon.FillDrpDown(DDLPRODUCT, DBManager.Get(vHashtable2, "CMB_PRODCATEGORY"), "Select Resoures", "PRODM_NAME", "PRODM_ID", "");
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLCAT, DBManager.Get(new Hashtable(), "CMB_DIS_CAT_MASTER"), "Select Category Name", "DCAT_NAME", "DCAT_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("ID", vID);
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_PRODUCT_ID"));
if (vDR != null)
{
TXTID.Value = vDR["PRODM_ID"].ToString();
PROD_NAME_TXT.Text = vDR["PRODM_NAME"].ToString();
//PROD_MRP_TXT.Text = vDR["PRODM_MRP"].ToString();
//PROD_RTP_TXT.Text = vDR["PRODM_RET_PRICE"].ToString();
//PROD_STK_TXT.Text = vDR["PRODM_STK_PRICE"].ToString();
//PROD_SYN_TXT.Text = vDR["PRODM_SYNP"].ToString();
TXT_LINK.Text = vDR["PRODM_LINK"].ToString();
DDLCAT.SelectedItem.Text = vDR["DCAT_NAME"].ToString();
DDLSUBCAT.SelectedItem.Text = vDR["DSCAT_DESC"].ToString();
HiddenField1.Value = vDR["DCAT_ID"].ToString();
HiddenField2.Value = vDR["DSCAT_ID"].ToString();
HiddenField3.Value = vDR["DCAT_NAME"].ToString();
HiddenField4.Value = vDR["DSCAT_DESC"].ToString();
VIDEO_LINK.Text = vDR["PRODM_VIDEO_LINK"].ToString();
}
else
{
ShowMsg("Invalid Product ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLDOCTER, DBManager.Get(new Hashtable(), "CMB_CUST_MASTER"), "Select Docter Name", "CUST_NAME", "CUST_ID", "0");
ATCommon.FillDrpDown(DDLSCREEN, DBManager.Get(new Hashtable(), "CMB_SCREEN_TEMPLATE"), "Select Screen Name", "SCTP_NAME", "SCTP_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("PTS_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_PT_SCREEN"));
if (vDR != null)
{
TXTID.Value = vDR["PTS_ID"].ToString();
DDLDOCTER.SelectedValue = vDR["PTS_CUSTID"].ToString();
DDLSCREEN.SelectedValue = vDR["PTS_SCTPID"].ToString();
INPUT_TXT.Text = vDR["PTS_INPUT"].ToString();
Textarea1.Value = vDR["PTS_REMARKS"].ToString();
}
else
{
ShowMsg("Invalid Patient ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLDIS, DBManager.Get(new Hashtable(), "CMB_DIS_MASTER"), "Select Disorder Name", "DIS_NAME", "DIS_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("SGM_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_SEVERITY_GROUP_MASTER"));
if (vDR != null)
{
TXTID.Value = vDR["SGM_ID"].ToString();
DDLDIS.SelectedValue = vDR["DIS_ID"].ToString();
DESCRIPTION_TXT.Text = vDR["SGM_DISC"].ToString();
FROM_TXT.Text = vDR["SGM_FROMVALUE"].ToString();
TO_TXT.Text = vDR["SGM_TOVALUE"].ToString();
}
else
{
ShowMsg("Invalid Severity ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Hashtable vHashtable1 = new Hashtable();
vHashtable1.Add("RPT_ID", TXTVALUE.Value);
vHashtable1.Add("RPT_NAME", REPORT_TXT.Text);
vHashtable1.Add("RPT_AGRP_ID", DDLAGE.SelectedValue);
vHashtable1.Add("TYPE", "INS");
if (DBManager.ExecInsUpsReturn(vHashtable1, "INS_REPORT_MASTER", (ATSession)Session["User"]))
{
if (Page.IsValid)
{
try
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("RPTD_ID", TXTID.Value);
vHashtable.Add("RPTD_RPTID", TXTVALUE.Value);
vHashtable.Add("RPTD_REPREASON", Textarea1.InnerText);
vHashtable.Add("RPTD_EVAID", ATCommon.GetListControlValues(EVALUATION_DDL));
vHashtable.Add("RPTD_MED", Textarea2.InnerText);
vHashtable.Add("RPTD_PTMID", Textarea3.InnerText);
vHashtable.Add("RPTD_PTFHID", Textarea4.InnerText);
vHashtable.Add("RPTD_DOBSID", Textarea5.InnerText);
vHashtable.Add("RPTD_DST", Textarea11.InnerText);
vHashtable.Add("RPTD_AGRPID", DDLAGE.SelectedItem.Text);
vHashtable.Add("RPTD_RECOM", Textarea17.InnerText);
vHashtable.Add("TYPE", "INS");
DBManager.ExecInsUps(vHashtable, "INS_REPORT_DETAIL", (ATSession)Session["User"]);
Response.Redirect("Report_Template_List.aspx");
}
catch (Exception xe)
{
ShowMsg(xe);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLDAGECAT, DBManager.Get(new Hashtable(), "GET_AGE_GRP_ID"), "Select Category", "AGRP_GROUP", "AGRP_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("SCTP_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_SCREEN_TEMPLATE"));
if (vDR != null)
{
TXTID.Value = vDR["SCTP_ID"].ToString();
DDLDAGECAT.SelectedValue = vDR["SCTP_AGDISID"].ToString();
SCREEN_TXT.Text = vDR["SCTP_NAME"].ToString();
}
else
{
ShowMsg("Invalid Screen ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLDCAT, DBManager.Get(new Hashtable(), "GET_DCAT_ID"), "Select Category", "DCAT_NAME", "DCAT_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("DSCAT_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_DIS_SUBCAT_MASTER"));
if (vDR != null)
{
TXTID.Value = vDR["DSCAT_ID"].ToString();
DSCAT_DESC_TXT.Text = vDR["DSCAT_DESC"].ToString();
DDLDCAT.SelectedValue = vDR["DSCAT_DCATID"].ToString();
}
else
{
ShowMsg("Invalid Category ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["id"];
if (!IsPostBack)
{
try
{
ValidateUserAccess();
Label1.Text = "You may choose the Test template given against each Disorder. You can fill the data based on your patients current condition. The choosen test and the data entered will be complied and shown in the PDF report of your Patient." +
"<br><b>Suggested Tests</b>- Battery of tests corresponding to each disorder is given for your reference. Its totally optional whether to choose our suggested tests or not.</ br>" +
"<br><b>Disclaimer:</b> NerdNerdy is not providing the assessor the actual test material for the given standardized tests VSMS, CARS-2, & DST. The test template is provided to so that the Assessor can put and record the data of his/her pateint, thus reducing the time and effort. In these templates NerdNerdy has not substituted the actual test material.</ br>";
ATCommon.FillDrpDown(DDLDIS, DBManager.Get(new Hashtable(), "CMB_DIS_MASTER"), "Select Disorder Name", "DIS_NAME", "DIS_ID", "0");
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(COUNTRY_DDL, DBManager.Get(new Hashtable(), "CMB_COUNTRY_MASTER"), "Select Country Name", "COUNTRY_NAME", "COUNTRY_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("STATE_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_STATE_MASTER"));
if (vDR != null)
{
TXTID.Value = vDR["STATE_ID"].ToString();
STATE_TXT.Text = vDR["STATE_NAME"].ToString();
COUNTRY_DDL.SelectedItem.Text = vDR["COUNTRY_NAME"].ToString();
HiddenField1.Value = vDR["COUNTRY_ID"].ToString();
}
else
{
ShowMsg("Invalid State Name");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(CUST_COUNTRY_DDL, DBManager.Get(new Hashtable(), "CMB_COUNTRY_MASTER"), "Select Country Name", "COUNTRY_NAME", "COUNTRY_ID", "0");
Hashtable vHashtable1 = new Hashtable();
vHashtable1.Add("STATE_ID", RegioanlHQ_DDL.SelectedValue.ToString());
Hashtable vHashta = new Hashtable();
vHashta.Add("STATE_ID", RegioanlHQ_DDL.SelectedValue);
ATCommon.FillDrpDown(RegioanlHQ_DDL, DBManager.Get(vHashta, "CMB_State"), "Select State Name", "STATE_NAME", "STATE_ID", "");
if (vID != null)
{
if (vATSession.UserType == "ORGANIZATION" || vATSession.UserType == "Organization")
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("CUST_MOBILE", vID);
DataRow vDR2 = RetDR(DBManager.Get(vHashtable, "GET_CUSTOMER_MOBILENO"));
if (vDR2 != null)
{
TXTID.Value = vDR2["CUST_ID"].ToString();
}
Hashtable vHT = new Hashtable();
vHT.Add("USR_LOGIN", vID);
DataRow vDR = RetDR(DBManager.Get(vHT, "GETUSR"));
if (vDR != null)
{
DDL_USER_TYPE.SelectedValue = vDR["USR_TYPE"].ToString();
TXT_LOGIN.Text = vDR["USR_LOGIN"].ToString();
RegioanlHQ_DDL.SelectedIndex = RegioanlHQ_DDL.Items.IndexOf(RegioanlHQ_DDL.Items.FindByValue(vDR["USR_REGHQ_ID"].ToString()));
RegioanlHQ_DDL_SelectedIndexChanged(sender, e);
AreaHQ_DDL.SelectedIndex = AreaHQ_DDL.Items.IndexOf(AreaHQ_DDL.Items.FindByValue(vDR["USR_ARHQ_ID"].ToString()));
CUST_COUNTRY_DDL.SelectedValue = vDR["USR_COUNTRY"].ToString();
TXT_MOBILE_NO.Text = vDR["USR_MOBILE"].ToString();
TXT_EMAIL.Text = vDR["USR_EMAIL"].ToString();
TXT_ADDRESS.Text = vDR["USR_ADDRESS"].ToString();
TXT_PIN.Text = vDR["USR_PIN"].ToString();
TXT_ORGANIZATION.Text = vDR["USR_ORGANIZATION_NAME"].ToString();
DDL_USER_TYPE.Enabled = false;
TXT_LOGIN.Enabled = false;
TXT_PASSWORD.Text = vDR["USR_PASSWORD"].ToString();
TXT_PASSWORD.Enabled = false;
TXT_START.Text = vDR["USR_FROM_DATE"].ToString();
TXT_END.Text = vDR["USR_TO_DATE"].ToString();
TXT_Sub.Text = vDR["USR_SUBSCRIPTION_NUMBER"].ToString();
TXT_PATIENT.Text = vDR["USR_PATIENT_SUBSCRIPTION_NUMBER"].ToString();
TXT_Sub.Enabled = false;
}
}
else
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("CUST_MOBILE", vID);
DataRow vDR2 = RetDR(DBManager.Get(vHashtable, "GET_CUSTOMER_MOBILENO"));
if (vDR2 != null)
{
TXTID.Value = vDR2["CUST_ID"].ToString();
}
DDL_USER_TYPE.SelectedValue = "";
Hashtable vHT = new Hashtable();
vHT.Add("USR_LOGIN", vID);
DataRow vDR = RetDR(DBManager.Get(vHT, "GETUSR"));
if (vDR != null)
{
DDL_USER_TYPE.SelectedValue = vDR["USR_TYPE"].ToString();
TXT_LOGIN.Text = vDR["USR_LOGIN"].ToString();
RegioanlHQ_DDL.SelectedIndex = RegioanlHQ_DDL.Items.IndexOf(RegioanlHQ_DDL.Items.FindByValue(vDR["USR_REGHQ_ID"].ToString()));
RegioanlHQ_DDL_SelectedIndexChanged(sender, e);
AreaHQ_DDL.SelectedIndex = AreaHQ_DDL.Items.IndexOf(AreaHQ_DDL.Items.FindByValue(vDR["USR_ARHQ_ID"].ToString()));
CUST_COUNTRY_DDL.SelectedValue = vDR["USR_COUNTRY"].ToString();
TXT_MOBILE_NO.Text = vDR["USR_MOBILE"].ToString();
TXT_EMAIL.Text = vDR["USR_EMAIL"].ToString();
TXT_ADDRESS.Text = vDR["USR_ADDRESS"].ToString();
TXT_PIN.Text = vDR["USR_PIN"].ToString();
TXT_ORGANIZATION.Text = vDR["USR_ORGANIZATION_NAME"].ToString();
DDL_USER_TYPE.Enabled = false;
TXT_LOGIN.Enabled = false;
TXT_PASSWORD.Text = vDR["USR_PASSWORD"].ToString();
TXT_PASSWORD.Enabled = false;
TXT_START.Text = vDR["USR_FROM_DATE"].ToString();
TXT_END.Text = vDR["USR_TO_DATE"].ToString();
TXT_Sub.Text = vDR["USR_SUBSCRIPTION_NUMBER"].ToString();
TXT_PATIENT.Text = vDR["USR_PATIENT_SUBSCRIPTION_NUMBER"].ToString();
}
}
}
else
{
if (TXTID.Value == "0")
{
DDL_USER_TYPE.SelectedValue = "ADMIN";
TXT_PASSWORD.Enabled = false;
TXT_LOGIN.Enabled = false;
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
dt = new DataTable();
DataColumn DCAT_NAME = new DataColumn();
DCAT_NAME.DataType = Type.GetType("System.String");
DCAT_NAME.ColumnName = "DCAT_NAME";
dt.Columns.Add(DCAT_NAME);
DataColumn DSCAT_DESC = new DataColumn();
DSCAT_DESC.DataType = Type.GetType("System.String");
DSCAT_DESC.ColumnName = "DSCAT_DESC";
dt.Columns.Add(DSCAT_DESC);
DataColumn IEPMD_NAME = new DataColumn();
IEPMD_NAME.DataType = Type.GetType("System.String");
IEPMD_NAME.ColumnName = "IEPMD_NAME";
dt.Columns.Add(IEPMD_NAME);
DataColumn IEPMD_DESC = new DataColumn();
IEPMD_DESC.DataType = Type.GetType("System.String");
IEPMD_DESC.ColumnName = "IEPMD_DESC";
dt.Columns.Add(IEPMD_DESC);
DataColumn DCAT_ID = new DataColumn();
DCAT_ID.DataType = Type.GetType("System.String");
DCAT_ID.ColumnName = "DCAT_ID";
dt.Columns.Add(DCAT_ID);
DataColumn DSCAT_ID = new DataColumn();
DSCAT_ID.DataType = Type.GetType("System.String");
DSCAT_ID.ColumnName = "DSCAT_ID";
dt.Columns.Add(DSCAT_ID);
DataColumn IEPMD_ID = new DataColumn();
IEPMD_ID.DataType = Type.GetType("System.String");
IEPMD_ID.ColumnName = "IEPMD_ID";
dt.Columns.Add(IEPMD_ID);
ViewState["datagrid"] = dt;
BindGrid();
Clear();
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLCAT, DBManager.Get(new Hashtable(), "CMB_DIS_CAT_MASTER"), "Select Category Name", "DCAT_NAME", "DCAT_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("IEPMD_IEPMID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_IEP_MAPPING_ID"));
DataTable dt2 = DBManager.Get(vHashtable, "GET_IEP_MAPPING_ID");
if (vDR != null)
{
TXTID.Value = vDR["IEPM_ID"].ToString();
Gridview2.DataSource = dt2;
Gridview2.DataBind();
Templatenew.Visible = false;
btnSave.Visible = true;
}
else
{
ShowMsg("Invalid IEP Mapping ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
String vID2 = vATSession.Login;
Hashtable vHashtable6 = new Hashtable();
vHashtable6.Add("USR_LOGIN", vID2);
DataRow vDR6 = RetDR(DBManager.Get(vHashtable6, "GET_USER"));
if (vDR6 != null)
{
HiddenField5.Value = vDR6["USR_ORGANIZATION_NAME"].ToString();
}
Hashtable vHashtable15 = new Hashtable();
vHashtable15.Add("USR_LOGIN", vATSession.Login);
DataRow vDR15 = RetDR(DBManager.Get(vHashtable15, "GET_TOTALPATIENT"));
if (vDR15 != null)
{
HiddenField7.Value = vDR15["USR_PATIENT_SUBSCRIPTION_NUMBER"].ToString();
}
//HiddenField9.Value = TXT_VALUE.Text;
String vID = Request.QueryString["ID"];
if (vID != null)
{
Hashtable vHashtable16 = new Hashtable();
vHashtable16.Add("ID", vID);
DataRow vDR16 = RetDR(DBManager.Get(vHashtable16, "GET_CUSTOMER_ID"));
if (vDR16 != null)
{
if (CUST_MOBILE_TXT.Text != vDR16["CUST_MOBILE"].ToString())
{
Hashtable vHashtable7 = new Hashtable();
vHashtable7.Add("USR_ORGANIZATION_NAME", HiddenField5.Value);
DataRow vDR7 = RetDR(DBManager.Get(vHashtable7, "GET_TOTALPATIENT_NUMBER"));
if (vDR7 != null)
{
HiddenField6.Value = vDR7["USED_PATIENT_SUBSCRIPTION_NUMBER"].ToString();
}
}
HiddenField6.Value = TXT_VALUE.Text;
}
}
if (HiddenField7.Value != "" && HiddenField6.Value != "")
{
HiddenField8.Value = Convert.ToString(Convert.ToInt32(HiddenField7.Value) - Convert.ToInt32(HiddenField6.Value));
if (int.Parse(TXT_VALUE.Text) <= int.Parse(HiddenField8.Value))
{
btnSave.Visible = true;
string PTP_MOBILE = "";
try
{
if (TXTID.Value == "0")
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("CUST_ID", TXTID.Value);
vHashtable.Add("CUST_VSOHQ_ID", "0");
vHashtable.Add("CUST_STA_ID", ddl_state.SelectedValue);
vHashtable.Add("CUST_NAME", CUST_NAME_TXT.Text);
vHashtable.Add("CUST_PROSPECTIVE", ddlProspective.SelectedItem.Text);
vHashtable.Add("CUST_PREFIX", "");
vHashtable.Add("CUST_ADDRESS", "");
vHashtable.Add("CUST_COMP_NAME", "");
vHashtable.Add("CUST_DISTRICT", "0");
vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
vHashtable.Add("CUST_POST_OFFICE", "");
vHashtable.Add("CUST_STATE", "0");
vHashtable.Add("CUST_CATRGORY_ID", "");
vHashtable.Add("CUST_CONSULT_NAME", "");
vHashtable.Add("CUST_CONSULT_MOB", "");
vHashtable.Add("CUST_PIN", "");
vHashtable.Add("CUST_PHONE", "");
vHashtable.Add("CUST_EMAIL", CUST_EMAIL_TXT.Text);
vHashtable.Add("CUST_MOBILE", CUST_MOBILE_TXT.Text);
vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
vHashtable.Add("CUST_DESIGNATION", TXT_DESIGNATION.Text);
vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
vHashtable.Add("CUST_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHashtable.Add("CUST_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
vHashtable.Add("CUST_VALUE", TXT_VALUE.Text);
if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
{
if (TXTID.Value.Equals("0"))
{
try
{
string pwd = Create_Password();
Hashtable vHT = new Hashtable();
vHT.Add("ID", TXTID.Value);
if (TXTID.Value == "0")
{
vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text);
}
else
{
vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
}
vHT.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
vHT.Add("USR_TYPE", "Doctor");
vHT.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
vHT.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHT.Add("USR_VSOHQ_ID", "0");
vHT.Add("USR_COMPANY", "");
vHT.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
vHT.Add("USR_ADDRESS", "");
vHT.Add("USR_PIN", "");
vHT.Add("USR_PHONE", "");
vHT.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
vHT.Add("USR_FAX", "");
vHT.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
vHT.Add("USR_PASSWORD", pwd);
vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue);
vHT.Add("USR_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
vHT.Add("USR_FROM_DATE", TXT_START.Text);
vHT.Add("USR_TO_DATE", TXT_END.Text);
vHT.Add("USR_SUBSCRIPTION_NUMBER", "");
vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_VALUE.Text);
vHT.Add("USR_CLINICAL_HEAD", "");
DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
ATApp vATApp = (ATApp)Application["Config"];
String vBody = "Dear " + CUST_NAME_TXT.Text + "\n\nLogin Detaials for NerdNerdy Web Application.\n\n";
vBody += "URL is:www.nerdnerdy.in\n";
vBody += "Login: "******"\nPassword:"******"\n\n";
vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
ATCommon.SendMail(CUST_EMAIL_TXT.Text, "Login Detaials for NerdNerdy Web Application.", vBody, vATApp);
ShowMsg(int.Parse(TXTID.Value));
Response.Redirect("UserList.aspx");
Clear();
}
catch (Exception xe) { ShowMsg(xe); }
}
else
{
Hashtable vHT1 = new Hashtable();
vHT1.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
vHT1.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
vHT1.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
vHT1.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHT1.Add("USR_VSOHQ_ID", "0");
vHT1.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
vHT1.Add("USR_TYPE", "Doctor");
vHT1.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
vHT1.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
vHT1.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_VALUE.Text);
DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
}
}
ShowMsg(int.Parse(TXTID.Value));
Clear();
Response.Redirect("UserList.aspx");
}
else
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("CUST_ID", TXTID.Value);
vHashtable.Add("CUST_VSOHQ_ID", "0");
vHashtable.Add("CUST_STA_ID", ddl_state.SelectedValue);
vHashtable.Add("CUST_NAME", CUST_NAME_TXT.Text);
vHashtable.Add("CUST_PROSPECTIVE", ddlProspective.SelectedItem.Text);
vHashtable.Add("CUST_PREFIX", "");
vHashtable.Add("CUST_ADDRESS", "");
vHashtable.Add("CUST_COMP_NAME", "");
vHashtable.Add("CUST_DISTRICT", "0");
vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
vHashtable.Add("CUST_POST_OFFICE", "");
vHashtable.Add("CUST_STATE", "0");
vHashtable.Add("CUST_CATRGORY_ID", "");
vHashtable.Add("CUST_CONSULT_NAME", "");
vHashtable.Add("CUST_CONSULT_MOB", "");
vHashtable.Add("CUST_PIN", "");
vHashtable.Add("CUST_PHONE", "");
vHashtable.Add("CUST_EMAIL", CUST_EMAIL_TXT.Text);
vHashtable.Add("CUST_MOBILE", CUST_MOBILE_TXT.Text);
vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
vHashtable.Add("CUST_DESIGNATION", TXT_DESIGNATION.Text);
vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
vHashtable.Add("CUST_ARHQ_ID", HiddenField1.Value);
vHashtable.Add("CUST_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
vHashtable.Add("CUST_VALUE", TXT_VALUE.Text);
if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
{
if (TXTID.Value.Equals("0"))
{
try
{
string pwd = Create_Password();
Hashtable vHT = new Hashtable();
vHT.Add("ID", TXTID.Value);
if (TXTID.Value == "0")
{
vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text);
}
else
{
vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
}
vHT.Add("USR_COMPANY", "");
vHT.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
vHT.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
vHT.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHT.Add("USR_VSOHQ_ID", "0");
vHT.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
vHT.Add("USR_ADDRESS", "");
vHT.Add("USR_TYPE", "Doctor");
vHT.Add("USR_PIN", "");
vHT.Add("USR_PHONE", "");
vHT.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
vHT.Add("USR_FAX", "");
vHT.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
vHT.Add("USR_PASSWORD", pwd);
vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue);
vHT.Add("USR_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
vHT.Add("USR_FROM_DATE", TXT_START.Text);
vHT.Add("USR_TO_DATE", TXT_END.Text);
vHT.Add("USR_SUBSCRIPTION_NUMBER", "");
vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_VALUE.Text);
vHT.Add("USR_CLINICAL_HEAD", "");
DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
ATApp vATApp = (ATApp)Application["Config"];
String vBody = "Dear " + CUST_NAME_TXT.Text + "\n\nLogin Detaials for NerdNerdy Web Application.\n\n";
vBody += "URL is: www.nerdnerdy.in\n";
vBody += "Login: "******"\nPassword:"******"\n\n";
vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
ATCommon.SendMail(CUST_EMAIL_TXT.Text, "Login Detaials for NerdNerdy Web Application.", vBody, vATApp);
ShowMsg(int.Parse(TXTID.Value));
Response.Redirect("UserList.aspx");
Clear();
}
catch (Exception xe) { ShowMsg(xe); }
}
else
{
Hashtable vHT1 = new Hashtable();
vHT1.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
vHT1.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
vHT1.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
vHT1.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHT1.Add("USR_VSOHQ_ID", "0");
vHT1.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
vHT1.Add("USR_TYPE", "Doctor");
vHT1.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
vHT1.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
vHT1.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_VALUE.Text);
DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
}
}
ShowMsg(int.Parse(TXTID.Value));
Clear();
Response.Redirect("UserList.aspx");
}
}
catch (Exception xe)
{
ShowMsg(xe);
}
}
else
{
string message = "You Have Less Patient Subscription as subscribed !!";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<script type = 'text/javascript'>");
sb.Append("window.onload=function(){");
sb.Append("alert('");
sb.Append(message);
sb.Append("')};");
sb.Append("</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString());
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
String vID = Request.QueryString["ID"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
if (!IsPostBack)
{
dt = new DataTable();
DataColumn coltypid = new DataColumn();
coltypid.DataType = Type.GetType("System.String");
coltypid.ColumnName = "CUSTP_TYPE_ID";
dt.Columns.Add(coltypid);
DataColumn coltypname = new DataColumn();
coltypname.DataType = Type.GetType("System.String");
coltypname.ColumnName = "CUST_TYP_NAME";
dt.Columns.Add(coltypname);
DataColumn colvalue = new DataColumn();
colvalue.DataType = Type.GetType("System.String");
colvalue.ColumnName = "CUSTP_VALUE";
dt.Columns.Add(colvalue);
DataColumn coldesc = new DataColumn();
coldesc.DataType = Type.GetType("System.String");
coldesc.ColumnName = "CUSTP_DESC";
dt.Columns.Add(coldesc);
ViewState["datagrid"] = dt;
BindGrid();
Clear();
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(CUST_COUNTRY_DDL, DBManager.Get(new Hashtable(), "CMB_COUNTRY_MASTER"), "Select Country Name", "COUNTRY_NAME", "COUNTRY_ID", "0");
ATCommon.FillCDWR(CUST_TYPE_DDL, DBManager.Get(new Hashtable(), "CMB_CUST_TYPE"), "", "CUST_TYP_NAME", "CUST_TYP_ID", "0");
ATCommon.FillDrpDown(ORGANIZATION_DDL, DBManager.Get(new Hashtable(), "CMB_ORGANIZATION"), "Select Organization Name", "USR_ORGANIZATION_NAME", "USR_LOGIN", "0");
Hashtable vHashta = new Hashtable();
vHashta.Add("STATE_ID", ddl_state.SelectedValue);
ATCommon.FillDrpDown(ddl_state, DBManager.Get(vHashta, "CMB_State"), "Select State Name", "STATE_NAME", "STATE_ID", "");
if (vATSession.UserType == "ADMIN")
{
ATCommon.FillCDWR(CUST_TYPE_DDL, DBManager.Get(new Hashtable(), "CMB_CUST_TYPE"), "Select Customer type", "CUST_TYP_NAME", "CUST_TYP_ID", "0");
ATCommon.FillDrpDown(CUST_CATRGORY_DDL, DBManager.Get(new Hashtable(), "[GET_CATEGORY]"), "Select Category ", "CAT_NAME", "CAT_ID", "0");
}
else
{
ATCommon.FillDrpDown(CUST_TYPE_DDL, DBManager.Get(new Hashtable(), "CMB_CUST_TYPE_VSO"), "", "CUST_TYP_NAME", "CUST_TYP_ID", "0");
ATCommon.FillDrpDown(CUST_CATRGORY_DDL, DBManager.Get(new Hashtable(), "[GET_CATEGORY_BY_VSR]"), "Select Category ", "CAT_NAME", "CAT_ID", "0");
}
if (vID != null)
{
Hashtable vHashtable4 = new Hashtable();
vHashtable4.Add("CUSTPID", vID);
dt = DBManager.Get(vHashtable4, "GET_CUSTPROFILE");
ViewState["datagrid"] = dt;
BindGrid();
Hashtable vHashtable = new Hashtable();
vHashtable.Add("ID", vID);
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_CUSTOMER_ID"));
if (vDR != null)
{
if (vATSession.UserType == "ADMIN")
{
CUST_NAME_TXT.Text = vDR["CUST_NAME"].ToString();
CUST_PREFIX_NAME.Text = vDR["CUST_PREFIX"].ToString();
CUST_COUNTRY_DDL.SelectedValue = vDR["CUST_COUNTRY_ID"].ToString();
string Prospective = vDR["CUST_PROSPECTIVE"].ToString().Trim();
if (vDR["CUST_PROSPECTIVE"].ToString().Trim() == "Yes")
{
ddlProspective.SelectedIndex = 2;
}
else if (vDR["CUST_PROSPECTIVE"].ToString().Trim() == "No")
{
ddlProspective.SelectedIndex = 1;
}
TXTID.Value = vDR["CUST_ID"].ToString();
CUST_ADD_TXT.Text = vDR["CUST_ROAD_STREET_HOUSE"].ToString();
CUST_COMP_NAME_TXT.Text = vDR["CUST_COMP_NAME"].ToString();
CUST_PIN_TXT.Text = vDR["CUST_PIN"].ToString();
CUST_PH_TXT.Text = vDR["CUST_PHONE"].ToString();
TXT_DESIGNATION.Text = vDR["CUST_DESIGNATION"].ToString();
CUST_EMAIL_TXT.Text = vDR["CUST_EMAIL"].ToString();
CUST_MOBILE_TXT.Text = vDR["CUST_MOBILE"].ToString();
txt_vil.Text = vDR["CUST_VILLAGE_TWN_CITY"].ToString();
CUST_CONSL_TXT.Text = vDR["CUST_CONSULT_NAME"].ToString();
CUST_CONSL_MOB_TXT.Text = vDR["CUST_CONSULT_MOB"].ToString();
txt_post.Text = vDR["CUST_POST_OFFICE"].ToString();
ddl_state.SelectedIndex = ddl_state.Items.IndexOf(ddl_state.Items.FindByValue(vDR["CUST_STA_ID"].ToString()));
ddlProspective.SelectedItem.Text = vDR["CUST_PROSPECTIVE"].ToString();
CUST_CATRGORY_DDL.SelectedIndex = CUST_CATRGORY_DDL.Items.IndexOf(CUST_CATRGORY_DDL.Items.FindByValue(vDR["CUST_CATRGORY_ID"].ToString()));
CUST_STATION_DDL.SelectedItem.Text = vDR["CITY_NAME"].ToString();//09112010 changed
CUST_COUNTRY_DDL.SelectedIndex = CUST_COUNTRY_DDL.Items.IndexOf(CUST_COUNTRY_DDL.Items.FindByValue(vDR["CUST_COUNTRY_ID"].ToString()));
CUST_COUNTRY_DDL_SelectedIndexChanged(sender, e);
ORGANIZATION_DDL.SelectedItem.Text = vDR["CUST_ORGANIZATION_NAME"].ToString();
HiddenField1.Value = vDR["CUST_ARHQ_ID"].ToString();
TXT_START.Text = vDR["CUST_FROM_DATE"].ToString();
TXT_END.Text = vDR["CUST_TO_DATE"].ToString();
}
else
{
string Prospective = vDR["CUST_PROSPECTIVE"].ToString().Trim();
if (vDR["CUST_PROSPECTIVE"].ToString().Trim() == "Yes")
{
ddlProspective.SelectedIndex = 2;
}
else if (vDR["CUST_PROSPECTIVE"].ToString().Trim() == "No")
{
ddlProspective.SelectedIndex = 1;
}
TXTID.Value = vDR["CUST_ID"].ToString();
CUST_NAME_TXT.Text = vDR["CUST_NAME"].ToString();
CUST_PREFIX_NAME.Text = vDR["CUST_PREFIX"].ToString();
if (CUST_NAME_TXT.Text == "STORE" || CUST_NAME_TXT.Text == "MEDSTORE")
{
CUST_NAME_TXT.Enabled = true;
}
else
{
CUST_NAME_TXT.Enabled = true;
}
CUST_COMP_NAME_TXT.Enabled = false;
CUST_ADD_TXT.Text = vDR["CUST_ROAD_STREET_HOUSE"].ToString();
CUST_COMP_NAME_TXT.Text = vDR["CUST_COMP_NAME"].ToString();
CUST_COMP_NAME_TXT.Enabled = false;
CUST_PIN_TXT.Text = vDR["CUST_PIN"].ToString();
CUST_PH_TXT.Text = vDR["CUST_PHONE"].ToString();
CUST_EMAIL_TXT.Text = vDR["CUST_EMAIL"].ToString();
TXT_DESIGNATION.Text = vDR["CUST_DESIGNATION"].ToString();
CUST_MOBILE_TXT.Text = vDR["CUST_MOBILE"].ToString();
txt_vil.Text = vDR["CUST_VILLAGE_TWN_CITY"].ToString();
CUST_CONSL_TXT.Text = vDR["CUST_CONSULT_NAME"].ToString();
CUST_CONSL_MOB_TXT.Text = vDR["CUST_CONSULT_MOB"].ToString();
txt_post.Text = vDR["CUST_POST_OFFICE"].ToString();
ddlProspective.SelectedIndex = ddl_state.Items.IndexOf(ddl_state.Items.FindByValue(vDR["CUST_PROSPECTIVE"].ToString()));
ddl_state.SelectedIndex = ddl_state.Items.IndexOf(ddl_state.Items.FindByValue(vDR["CUST_STA_ID"].ToString()));
CUST_CATRGORY_DDL.SelectedIndex = CUST_CATRGORY_DDL.Items.IndexOf(CUST_CATRGORY_DDL.Items.FindByValue(vDR["CUST_CATRGORY_ID"].ToString()));
CUST_CATRGORY_DDL.Enabled = false;
CUST_COUNTRY_DDL.SelectedIndex = CUST_COUNTRY_DDL.Items.IndexOf(CUST_COUNTRY_DDL.Items.FindByValue(vDR["CUST_COUNTRY_ID"].ToString()));
CUST_COUNTRY_DDL_SelectedIndexChanged(sender, e);
ddl_state.SelectedIndex = ddl_state.Items.IndexOf(ddl_state.Items.FindByValue(vDR["CUST_STA_ID"].ToString()));
ddlProspective.SelectedItem.Text = vDR["CUST_PROSPECTIVE"].ToString();
ORGANIZATION_DDL.SelectedItem.Text = vDR["CUST_ORGANIZATION_NAME"].ToString();
CUST_STATION_DDL.SelectedItem.Text = vDR["CITY_NAME"].ToString();
HiddenField1.Value = vDR["CUST_ARHQ_ID"].ToString();
TXT_START.Text = vDR["CUST_FROM_DATE"].ToString();
TXT_END.Text = vDR["CUST_TO_DATE"].ToString();
}
}
}
else
{
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = vATSession.Login;
if (!IsPostBack)
{
try
{
Label2.Text = "<b>Please note:</b> This application is a property of NerdNerdy Technologies Pvt Ltd. The system and content related to this software is under the Patent and Copy right protection." + "<br></br>";
ValidateUserAccess();
ATCommon.FillDrpDown(CUST_COUNTRY_DDL, DBManager.Get(new Hashtable(), "CMB_COUNTRY_MASTER"), "Select Country Name", "COUNTRY_NAME", "COUNTRY_ID", "0");
Hashtable vHashtable1 = new Hashtable();
vHashtable1.Add("STATE_ID", RegioanlHQ_DDL.SelectedValue.ToString());
Hashtable vHashta = new Hashtable();
vHashta.Add("STATE_ID", RegioanlHQ_DDL.SelectedValue);
ATCommon.FillDrpDown(RegioanlHQ_DDL, DBManager.Get(vHashta, "CMB_State"), "Select State Name", "STATE_NAME", "STATE_ID", "");
if (vID != null)
{
if (vATSession.UserType == "ORGANIZATION" || vATSession.UserType == "Organization")
{
Hashtable vHT = new Hashtable();
vHT.Add("USR_LOGIN", vID);
DataRow vDR = RetDR(DBManager.Get(vHT, "GETUSR"));
if (vDR != null)
{
TXTID.Value = "1";
DDL_USER_TYPE.SelectedValue = vDR["USR_TYPE"].ToString();
TXT_LOGIN.Text = vDR["USR_LOGIN"].ToString();
RegioanlHQ_DDL.SelectedIndex = RegioanlHQ_DDL.Items.IndexOf(RegioanlHQ_DDL.Items.FindByValue(vDR["USR_REGHQ_ID"].ToString()));
RegioanlHQ_DDL_SelectedIndexChanged(sender, e);
AreaHQ_DDL.SelectedIndex = AreaHQ_DDL.Items.IndexOf(AreaHQ_DDL.Items.FindByValue(vDR["USR_ARHQ_ID"].ToString()));
CUST_COUNTRY_DDL.SelectedValue = vDR["USR_COUNTRY"].ToString();
TXT_CONT_NAME.Text = vDR["USR_CONT_NAME"].ToString();
//TXT_PHONE_NO.Text = vDR["USR_PHONE"].ToString();
TXT_MOBILE_NO.Text = vDR["USR_MOBILE"].ToString();
//TXT_FAX_NO.Text = vDR["USR_FAX"].ToString();
TXT_EMAIL.Text = vDR["USR_EMAIL"].ToString();
TXT_ADDRESS.Text = vDR["USR_ADDRESS"].ToString();
TXT_PIN.Text = vDR["USR_PIN"].ToString();
TXT_ORGANIZATION.Text = vDR["USR_ORGANIZATION_NAME"].ToString();
DDL_USER_TYPE.Enabled = false;
TXT_LOGIN.Enabled = false;
TXT_PASSWORD.Text = vDR["USR_PASSWORD"].ToString();
TXT_PASSWORD.Enabled = false;
TXT_START.Text = vDR["USR_FROM_DATE"].ToString();
TXT_END.Text = vDR["USR_TO_DATE"].ToString();
TXT_Sub.Text = vDR["USR_SUBSCRIPTION_NUMBER"].ToString();
TXT_PATIENT.Text = vDR["USR_PATIENT_SUBSCRIPTION_NUMBER"].ToString();
TXT_Sub.Enabled = false;
TXT_PATIENT.Enabled = false;
}
}
else
{
DDL_USER_TYPE.SelectedValue = "";
Hashtable vHT = new Hashtable();
vHT.Add("USR_LOGIN", vID);
DataRow vDR = RetDR(DBManager.Get(vHT, "GETUSR"));
if (vDR != null)
{
TXTID.Value = "1";
DDL_USER_TYPE.SelectedValue = vDR["USR_TYPE"].ToString();
TXT_LOGIN.Text = vDR["USR_LOGIN"].ToString();
RegioanlHQ_DDL.SelectedIndex = RegioanlHQ_DDL.Items.IndexOf(RegioanlHQ_DDL.Items.FindByValue(vDR["USR_REGHQ_ID"].ToString()));
RegioanlHQ_DDL_SelectedIndexChanged(sender, e);
AreaHQ_DDL.SelectedIndex = AreaHQ_DDL.Items.IndexOf(AreaHQ_DDL.Items.FindByValue(vDR["USR_ARHQ_ID"].ToString()));
CUST_COUNTRY_DDL.SelectedValue = vDR["USR_COUNTRY"].ToString();
TXT_CONT_NAME.Text = vDR["USR_CONT_NAME"].ToString();
//TXT_PHONE_NO.Text = vDR["USR_PHONE"].ToString();
TXT_MOBILE_NO.Text = vDR["USR_MOBILE"].ToString();
//TXT_FAX_NO.Text = vDR["USR_FAX"].ToString();
TXT_EMAIL.Text = vDR["USR_EMAIL"].ToString();
TXT_ADDRESS.Text = vDR["USR_ADDRESS"].ToString();
TXT_PIN.Text = vDR["USR_PIN"].ToString();
TXT_ORGANIZATION.Text = vDR["USR_ORGANIZATION_NAME"].ToString();
DDL_USER_TYPE.Enabled = false;
TXT_LOGIN.Enabled = false;
TXT_PASSWORD.Text = vDR["USR_PASSWORD"].ToString();
TXT_PASSWORD.Enabled = false;
TXT_START.Text = vDR["USR_FROM_DATE"].ToString();
TXT_END.Text = vDR["USR_TO_DATE"].ToString();
TXT_Sub.Text = vDR["USR_SUBSCRIPTION_NUMBER"].ToString();
TXT_PATIENT.Text = vDR["USR_PATIENT_SUBSCRIPTION_NUMBER"].ToString();
}
}
}
else
{
if (TXTID.Value == "0")
{
DDL_USER_TYPE.SelectedValue = "ADMIN";
TXT_PASSWORD.Enabled = false;
TXT_LOGIN.Enabled = false;
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
PTP_TXT.Text = vATSession.UserName;
if (vATSession.UserType == "ADMIN")
{
GridView1.Visible = true;
hidden1.Visible = true;
btnSave.Visible = false;
}
else
{
GridView1.Visible = true;
}
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(COND_ID, DBManager.Get(new Hashtable(), "CMB_CONDITION_MASTER"), "Select Condition Name", "COND_NAME", "COND_ID", "0");
if (vID != null)
{
PTP_ID.Value = vID;
Hashtable vHashtable = new Hashtable();
vHashtable.Add("PTP_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_PATIENT_DETAIL"));
if (vDR != null)
{
PTP_ID.Value = vID;
vID = vDR["PTP_ID"].ToString();
PTP_TXT.Text = vDR["PTP_NAME"].ToString();
Textarea1.Value = vDR["PTP_NAME"].ToString() + " " + "mother was " +
"------------ " + "years old and father- was " + "------------- " + "years old at the time of the birth of" + " " +
vDR["PTP_NAME"].ToString() + " " + "There were" + " " + "complications / no complications" + " " +
"during pregnancy reported by the mother and" + " " + "he / she" + " " + "was born with no apparent medical complications/ issues like" + " " +
"------------------------------------" + " " + vDR["PTP_NAME"].ToString() + " " +
"was full term / pre-term" + "and was born through C-section / normal delivery." +
"The mother" + " " + "----------" + " " + "did not face complications/ faced complications during delivery." + " " +
"------------------------------------" + " " + vDR["PTP_NAME"].ToString() + " "
+ "birth weight was " + "----------.";
Hashtable vHashtable2 = new Hashtable();
vHashtable2.Add("PTP_ID", vID);
DataRow vDR2 = RetDR(DBManager.Get(vHashtable2, "GET_PT_MENTAL_ID"));
if (vDR2 != null)
{
btnSave.Visible = false;
}
}
else
{
ShowMsg("Invalid ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string PTP_MOBILE = "";
try
{
if (TXTID.Value == "0")
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("CUST_ID", TXTID.Value);
vHashtable.Add("CUST_VSOHQ_ID", "0");
vHashtable.Add("CUST_STA_ID", ddl_state.SelectedValue);
vHashtable.Add("CUST_NAME", CUST_NAME_TXT.Text);
vHashtable.Add("CUST_PROSPECTIVE", ddlProspective.SelectedItem.Text);
vHashtable.Add("CUST_PREFIX", CUST_PREFIX_NAME.SelectedItem.Text);
vHashtable.Add("CUST_ADDRESS", CUST_ADD_TXT.Text);
vHashtable.Add("CUST_COMP_NAME", CUST_COMP_NAME_TXT.Text);
vHashtable.Add("CUST_DISTRICT", "0");
vHashtable.Add("CUST_VILLAGE_TWN_CITY", txt_vil.Text);
vHashtable.Add("CUST_POST_OFFICE", txt_post.Text);
vHashtable.Add("CUST_STATE", "0");
vHashtable.Add("CUST_CATRGORY_ID", CUST_CATRGORY_DDL.SelectedValue);
vHashtable.Add("CUST_CONSULT_NAME", CUST_CONSL_TXT.Text);
vHashtable.Add("CUST_CONSULT_MOB", CUST_CONSL_MOB_TXT.Text);
vHashtable.Add("CUST_PIN", CUST_PIN_TXT.Text);
vHashtable.Add("CUST_PHONE", CUST_PH_TXT.Text);
vHashtable.Add("CUST_EMAIL", CUST_EMAIL_TXT.Text);
vHashtable.Add("CUST_MOBILE", CUST_MOBILE_TXT.Text);
vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
vHashtable.Add("CUST_DESIGNATION", TXT_DESIGNATION.Text);
vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
vHashtable.Add("CUST_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHashtable.Add("CUST_ORGANIZATION_NAME", ORGANIZATION_DDL.SelectedItem.Text);
vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
{
if (TXTID.Value.Equals("0"))
{
try
{
string pwd = Create_Password();
Hashtable vHT = new Hashtable();
vHT.Add("ID", TXTID.Value);
if (TXTID.Value == "0")
{
vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text);
}
else
{
vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
}
vHT.Add("USR_COMPANY", CUST_COMP_NAME_TXT.Text);
vHT.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
vHT.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
vHT.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHT.Add("USR_VSOHQ_ID", "0");
vHT.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
vHT.Add("USR_ADDRESS", "");
vHT.Add("USR_TYPE", "Doctor");
vHT.Add("USR_PIN", "");
vHT.Add("USR_PHONE", CUST_PH_TXT.Text);
vHT.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
vHT.Add("USR_FAX", "");
vHT.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
vHT.Add("USR_PASSWORD", pwd);
vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue);
vHT.Add("USR_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
ATApp vATApp = (ATApp)Application["Config"];
String vBody = "Dear " + CUST_NAME_TXT.Text + "\n\nLogin Detaials for Nerdnerdy Intranet Application.\n\n";
vBody += "URL is: www.nerdnerdy.in\n";
if (TXTID.Value == "0")
{
vBody += "Login: "******"\nPassword:"******"\n\n";
}
else
{
vBody += "Login: "******"\nPassword:"******"\n\n";
}
vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
ATCommon.SendMail(CUST_MOBILE_TXT.Text, "Login Detaials for Nerdnerdy Intranet Application.", vBody, vATApp);
ShowMsg(int.Parse(TXTID.Value));
Clear();
}
catch (Exception xe) { ShowMsg(xe); }
}
else
{
Hashtable vHT1 = new Hashtable();
vHT1.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
vHT1.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
vHT1.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
vHT1.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHT1.Add("USR_VSOHQ_ID", "0");
vHT1.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
vHT1.Add("USR_TYPE", "Doctor");
vHT1.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
}
}
{
DBManager.DeleteadminRec(TXTID.Value, "DEL_CUST_PROFILE");
foreach (GridViewRow grw in CUST_PROFILE.Rows)
{
Hashtable vHashtable1 = new Hashtable();
Label TYPE_ID = (Label)grw.FindControl("CUSTP_TYPE_ID");
Label VALUE = (Label)grw.FindControl("CUSTP_VALUE");
Label DESC = (Label)grw.FindControl("CUSTP_DESC");
vHashtable1.Add("CUST_ID", TXTID.Value);
vHashtable1.Add("CUSTP_TYPE_ID", TYPE_ID.Text);
vHashtable1.Add("CUSTP_VALUE", VALUE.Text);
vHashtable1.Add("CUSTP_DESC", DESC.Text);
DBManager.ExecInsUps(vHashtable1, "INS_CUST_PROFILE", (ATSession)Session["User"]);
}
}
ShowMsg(int.Parse(TXTID.Value));
Clear();
Response.Redirect("customer.aspx");
}
else
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("CUST_ID", TXTID.Value);
vHashtable.Add("CUST_VSOHQ_ID", "0");
vHashtable.Add("CUST_STA_ID", ddl_state.SelectedValue);
vHashtable.Add("CUST_NAME", CUST_NAME_TXT.Text);
vHashtable.Add("CUST_PROSPECTIVE", ddlProspective.SelectedItem.Text);
vHashtable.Add("CUST_PREFIX", CUST_PREFIX_NAME.SelectedItem.Text);
vHashtable.Add("CUST_ADDRESS", CUST_ADD_TXT.Text);
vHashtable.Add("CUST_COMP_NAME", CUST_COMP_NAME_TXT.Text);
vHashtable.Add("CUST_DISTRICT", "0");
vHashtable.Add("CUST_VILLAGE_TWN_CITY", txt_vil.Text);
vHashtable.Add("CUST_POST_OFFICE", txt_post.Text);
vHashtable.Add("CUST_STATE", "0");
vHashtable.Add("CUST_CATRGORY_ID", CUST_CATRGORY_DDL.SelectedValue);
vHashtable.Add("CUST_CONSULT_NAME", CUST_CONSL_TXT.Text);
vHashtable.Add("CUST_CONSULT_MOB", CUST_CONSL_MOB_TXT.Text);
vHashtable.Add("CUST_PIN", CUST_PIN_TXT.Text);
vHashtable.Add("CUST_PHONE", CUST_PH_TXT.Text);
vHashtable.Add("CUST_EMAIL", CUST_EMAIL_TXT.Text);
vHashtable.Add("CUST_MOBILE", CUST_MOBILE_TXT.Text);
vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
vHashtable.Add("CUST_DESIGNATION", TXT_DESIGNATION.Text);
vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
vHashtable.Add("CUST_ARHQ_ID", HiddenField1.Value);
vHashtable.Add("CUST_ORGANIZATION_NAME", ORGANIZATION_DDL.SelectedItem.Text);
vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
{
if (TXTID.Value.Equals("0"))
{
try
{
string pwd = Create_Password();
Hashtable vHT = new Hashtable();
vHT.Add("ID", TXTID.Value);
if (TXTID.Value == "0")
{
vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text);
}
else
{
vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
}
vHT.Add("USR_COMPANY", CUST_COMP_NAME_TXT.Text);
vHT.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
vHT.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
vHT.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHT.Add("USR_VSOHQ_ID", "0");
vHT.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
vHT.Add("USR_ADDRESS", "");
vHT.Add("USR_TYPE", "Doctor");
vHT.Add("USR_PIN", "");
vHT.Add("USR_PHONE", CUST_PH_TXT.Text);
vHT.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
vHT.Add("USR_FAX", "");
vHT.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
vHT.Add("USR_PASSWORD", pwd);
vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue);
vHT.Add("USR_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
ATApp vATApp = (ATApp)Application["Config"];
String vBody = "Dear " + CUST_NAME_TXT.Text + "\n\nLogin Detaials for Nerdnerdy Web Application.\n\n";
vBody += "URL is: www.nerdnerdy.in\n";
if (TXTID.Value == "0")
{
vBody += "Login: "******"\nPassword:"******"\n\n";
}
else
{
vBody += "Login: "******"\nPassword:"******"\n\n";
}
vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
ATCommon.SendMail(CUST_MOBILE_TXT.Text, "Login Detaials for Nerdnerdy Web Application.", vBody, vATApp);
ShowMsg(int.Parse(TXTID.Value));
Clear();
}
catch (Exception xe) { ShowMsg(xe); }
}
else
{
Hashtable vHT1 = new Hashtable();
vHT1.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
vHT1.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
vHT1.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
vHT1.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
vHT1.Add("USR_VSOHQ_ID", "0");
vHT1.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
vHT1.Add("USR_TYPE", "Doctor");
vHT1.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
}
}
{
DBManager.DeleteadminRec(TXTID.Value, "DEL_CUST_PROFILE");
foreach (GridViewRow grw in CUST_PROFILE.Rows)
{
Hashtable vHashtable1 = new Hashtable();
Label TYPE_ID = (Label)grw.FindControl("CUSTP_TYPE_ID");
Label VALUE = (Label)grw.FindControl("CUSTP_VALUE");
Label DESC = (Label)grw.FindControl("CUSTP_DESC");
vHashtable1.Add("CUST_ID", TXTID.Value);
vHashtable1.Add("CUSTP_TYPE_ID", TYPE_ID.Text);
vHashtable1.Add("CUSTP_VALUE", VALUE.Text);
vHashtable1.Add("CUSTP_DESC", DESC.Text);
DBManager.ExecInsUps(vHashtable1, "INS_CUST_PROFILE", (ATSession)Session["User"]);
}
}
ShowMsg(int.Parse(TXTID.Value));
Clear();
Response.Redirect("customer.aspx");
}
}
catch (Exception xe)
{
ShowMsg(xe);
}
// }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
string strPreviousPage = string.Empty;
if (Request.UrlReferrer != null)
{
strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1];
}
if (strPreviousPage == "")
{
Response.Redirect("~/Default.aspx");
}
String vID = Request.QueryString["ID"];
String CCID = Request.QueryString["id1"];
if (!IsPostBack)
{
dt = new DataTable();
DataColumn IEPDT_PRICE = new DataColumn();
IEPDT_PRICE.DataType = Type.GetType("System.String");
IEPDT_PRICE.ColumnName = "IEPDT_PRICE";
dt.Columns.Add(IEPDT_PRICE);
DataColumn coldisname = new DataColumn();
coldisname.DataType = Type.GetType("System.String");
coldisname.ColumnName = "IEPDTD_DSCATID";
dt.Columns.Add(coldisname);
DataColumn coltypgroup = new DataColumn();
coltypgroup.DataType = Type.GetType("System.String");
coltypgroup.ColumnName = "IEPDTD_DCATID";
dt.Columns.Add(coltypgroup);
DataColumn coltypgroup1 = new DataColumn();
coltypgroup1.DataType = Type.GetType("System.String");
coltypgroup1.ColumnName = "IEPDTD_IEPAID";
dt.Columns.Add(coltypgroup1);
DataColumn coldcname = new DataColumn();
coldcname.DataType = Type.GetType("System.String");
coldcname.ColumnName = "DCAT_NAME";
dt.Columns.Add(coldcname);
DataColumn NAME = new DataColumn();
NAME.DataType = Type.GetType("System.String");
NAME.ColumnName = "DIS_NAME";
dt.Columns.Add(NAME);
DataColumn coldesc = new DataColumn();
coldesc.DataType = Type.GetType("System.String");
coldesc.ColumnName = "DSCAT_DESC";
dt.Columns.Add(coldesc);
DataColumn coldobdes = new DataColumn();
coldobdes.DataType = Type.GetType("System.String");
coldobdes.ColumnName = "IEPA_DESC";
dt.Columns.Add(coldobdes);
DataColumn coldID = new DataColumn();
coldID.DataType = Type.GetType("System.String");
coldID.ColumnName = "IEPDT_ID";
dt.Columns.Add(coldID);
DataColumn CID = new DataColumn();
CID.DataType = Type.GetType("System.String");
CID.ColumnName = "IEPA_ID";
dt.Columns.Add(CID);
DataColumn coldIEPD = new DataColumn();
coldIEPD.DataType = Type.GetType("System.String");
coldIEPD.ColumnName = "IEPDTD_IEPDTID";
dt.Columns.Add(coldIEPD);
DataColumn coldDCAT = new DataColumn();
coldDCAT.DataType = Type.GetType("System.String");
coldDCAT.ColumnName = "DSCAT_DCATID";
dt.Columns.Add(coldDCAT);
DataColumn IEPDTD_PRODMID = new DataColumn();
IEPDTD_PRODMID.DataType = Type.GetType("System.String");
IEPDTD_PRODMID.ColumnName = "IEPDTD_PRODMID";
dt.Columns.Add(IEPDTD_PRODMID);
DataColumn PRODM_ID = new DataColumn();
PRODM_ID.DataType = Type.GetType("System.String");
PRODM_ID.ColumnName = "PRODM_ID";
dt.Columns.Add(PRODM_ID);
DataColumn PRODM_NAME = new DataColumn();
PRODM_NAME.DataType = Type.GetType("System.String");
PRODM_NAME.ColumnName = "PRODM_NAME";
dt.Columns.Add(PRODM_NAME);
DataColumn IEPAT_DATE = new DataColumn();
IEPAT_DATE.DataType = Type.GetType("System.String");
IEPAT_DATE.ColumnName = "IEPAT_DATE";
dt.Columns.Add(IEPAT_DATE);
DataColumn IEPAT_REMARK = new DataColumn();
IEPAT_REMARK.DataType = Type.GetType("System.String");
IEPAT_REMARK.ColumnName = "IEPAT_REMARK";
dt.Columns.Add(IEPAT_REMARK);
DataColumn IEPAT_ID = new DataColumn();
IEPAT_ID.DataType = Type.GetType("System.String");
IEPAT_ID.ColumnName = "IEPAT_ID";
dt.Columns.Add(IEPAT_ID);
DataColumn IEPA_NAME = new DataColumn();
IEPA_NAME.DataType = Type.GetType("System.String");
IEPA_NAME.ColumnName = "IEPA_NAME";
dt.Columns.Add(IEPA_NAME);
DataColumn IEPAT_PTPID = new DataColumn();
IEPAT_PTPID.DataType = Type.GetType("System.String");
IEPAT_PTPID.ColumnName = "IEPAT_PTPID";
dt.Columns.Add(IEPAT_PTPID);
DataColumn IEPDTD_ID = new DataColumn();
IEPDTD_ID.DataType = Type.GetType("System.String");
IEPDTD_ID.ColumnName = "IEPDTD_ID";
dt.Columns.Add(IEPDTD_ID);
ViewState["datagrid"] = dt;
BindGrid();
DDLDIS.Enabled = true;
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLDIS, DBManager.Get(new Hashtable(), "CMB_DIS_MASTER"), "Select Disorder Name", "DIS_NAME", "DIS_ID", "0");
ATCommon.FillDrpDown(DDLCAT, DBManager.Get(new Hashtable(), "CMB_DIS_CAT_MASTER_PATIENT_NEW"), "Select Category Name", "DCAT_NAME", "DCAT_ID", "0");
if (vATSession.UserType == "ADMIN")
{
Label1.Text = "The IEP template assist the therapists to create daily, weekly, monthly or yearly Individualized Educational plan (IEP) of your patient. You may select category first and then its corresponding subcategory for the skills that you want to include in your IEP of your patient." +
"<br><b>Suggested Activity:</b> Comprehensive list of suggested activities is provided to you (therapist) based on the skills that you have included in your patient's IEP . You can use these activities as it is or can modify them as per your need. Kindly note that these are suggested activities, its therapists decision whether to use them or not.</ br>" +
"<br><b>Intervention Resources:</b> Intervention Resources/tools are an integral part of any therapy. In our therapy sessions, we need customized intervention resources for our patients.Its our constant endeavor of NerdNerdy, to create, develop or bring in unique research backed intervention tools for our children.</ br>" +
"<br>Based on the chosen IEP, the resources can be selected under the resource tab. The link would come in the IEP itself, once you click the link, it will take you to the website. You can buy the resources from website.</ br>" +
"<br><b>Progress Review-</b> You can review the progress of your patient through progress review tab.The progress can be viewed category,sub-category wise & time-line basis.</ br>" +
"<br><b>Progress-</b> You can fill the progress of your patient by selecting options- Accomplished (if the patient has acquired the skill that you introduced in your IEP), Emerging (If the skill is still not fully acquired) & No Improvement (if the skill is not acquired and needs more practice, thus can be reintroduced in your IEP). Once you select any of the three given options, please update the progress by clicking the, <b>update button</b> in order to save the progress of your patient.</br>";
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("IEPDT_ID", vID);
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_IEPDT_ID_NEW"));
if (vDR != null)
{
TXTID.Value = vDR["IEPDT_ID"].ToString();
DDLDIS.SelectedValue = vDR["IEPDT_DISID"].ToString();
btnSave.Visible = false;
DDLDIS.Enabled = false;
}
else
{
ShowMsg("Invalid IEP ID");
}
Hashtable vHashtable1 = new Hashtable();
vHashtable1.Add("IEPDT_ID", vID);
vHashtable1.Add("IEPAT_PTPID", CCID);
dt = DBManager.Get(vHashtable1, "GET_IEP_PATIENT");
if (dt.Rows.Count > 0)
{
ViewState["datagrid"] = dt;
BindGrid();
}
CCID = Request.QueryString["id1"];
Hashtable vHashtable2 = new Hashtable();
vHashtable2.Add("PTP_ID", CCID);
DataRow vDR1 = RetDR(DBManager.Get(vHashtable2, "GET_PATIENT_ID"));
if (vDR1 != null)
{
PTP_ID.Value = vDR1["PTP_ID"].ToString();
PATIENT_TXT.Text = vDR1["PTP_NAME"].ToString();
PATIENT_TXT.Enabled = false;
}
else
{
ShowMsg("Invalid IEP ID");
}
}
}
else if (vATSession.UserType == "DOCTOR" || vATSession.UserType == "Doctor")
{
if (vID != null)
{
Label1.Text = "The IEP template assist the therapists to create daily, weekly, monthly or yearly Individualized Educational plan (IEP) of your patient. You may select category first and then its corresponding subcategory for the skills that you want to include in your IEP of your patient." +
"<br><b>Suggested Activity:</b> Comprehensive list of suggested activities is provided to you (therapist) based on the skills that you have included in your patient's IEP . You can use these activities as it is or can modify them as per your need. Kindly note that these are suggested activities, its therapists decision whether to use them or not.</ br>" +
"<br><b>Intervention Resources:</b> Intervention Resources/tools are an integral part of any therapy. In our therapy sessions, we need customized intervention resources for our patients.Its our constant endeavor of NerdNerdy, to create, develop or bring in unique research backed intervention tools for our children.</ br>" +
"<br>Based on the chosen IEP, the resources can be selected under the resource tab. The link would come in the IEP itself, once you click the link, it will take you to the website. You can buy the resources from website.</ br>" +
"<br><b>Progress Review-</b> You can review the progress of your patient through progress review tab.The progress can be viewed category,sub-category wise & time-line basis.</ br>" +
"<br><b>Progress-</b> You can fill the progress of your patient by selecting options- Accomplished (if the patient has acquired the skill that you introduced in your IEP), Emerging (If the skill is still not fully acquired) & No Improvement (if the skill is not acquired and needs more practice, thus can be reintroduced in your IEP). Once you select any of the three given options, please update the progress by clicking the, <b>update button</b> in order to save the progress of your patient.</br>";
Hashtable vHashtable = new Hashtable();
vHashtable.Add("IEPDT_ID", vID);
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_IEPDT_ID_NEW"));
if (vDR != null)
{
TXTID.Value = vDR["IEPDT_ID"].ToString();
DDLDIS.SelectedValue = vDR["IEPDT_DISID"].ToString();
DDLDIS.Enabled = false;
}
else
{
ShowMsg("Invalid IEP ID");
}
Hashtable vHashtable1 = new Hashtable();
vHashtable1.Add("IEPDT_ID", vID);
vHashtable1.Add("IEPAT_PTPID", CCID);
dt = DBManager.Get(vHashtable1, "GET_IEP_PATIENT");
if (dt.Rows.Count > 0)
{
ViewState["datagrid"] = dt;
BindGrid();
}
CCID = Request.QueryString["id1"];
Hashtable vHashtable2 = new Hashtable();
vHashtable2.Add("PTP_ID", CCID);
DataRow vDR1 = RetDR(DBManager.Get(vHashtable2, "GET_PATIENT_ID"));
if (vDR1 != null)
{
PTP_ID.Value = vDR1["PTP_ID"].ToString();
PATIENT_TXT.Text = vDR1["PTP_NAME"].ToString();
PATIENT_TXT.Enabled = false;
}
else
{
ShowMsg("Invalid IEP ID");
}
}
}
else if (vATSession.UserType == "ORGANIZATION" || vATSession.UserType == "Organization")
{
if (vID != null)
{
Label1.Text = "The IEP template assist the therapists to create daily, weekly, monthly or yearly Individualized Educational plan (IEP) of your patient. You may select category first and then its corresponding subcategory for the skills that you want to include in your IEP of your patient." +
"<br><b>Suggested Activity:</b> Comprehensive list of suggested activities is provided to you (therapist) based on the skills that you have included in your patient's IEP . You can use these activities as it is or can modify them as per your need. Kindly note that these are suggested activities, its therapists decision whether to use them or not.</ br>" +
"<br><b>Intervention Resources:</b> Intervention Resources/tools are an integral part of any therapy. In our therapy sessions, we need customized intervention resources for our patients.Its our constant endeavor of NerdNerdy, to create, develop or bring in unique research backed intervention tools for our children.</ br>" +
"<br>Based on the chosen IEP, the resources can be selected under the resource tab. The link would come in the IEP itself, once you click the link, it will take you to the website. You can buy the resources from website.</ br>" +
"<br><b>Progress Review-</b> You can review the progress of your patient through progress review tab.The progress can be viewed category,sub-category wise & time-line basis.</ br>" +
"<br><b>Progress-</b> You can fill the progress of your patient by selecting options- Accomplished (if the patient has acquired the skill that you introduced in your IEP), Emerging (If the skill is still not fully acquired) & No Improvement (if the skill is not acquired and needs more practice, thus can be reintroduced in your IEP). Once you select any of the three given options, please update the progress by clicking the, <b>update button</b> in order to save the progress of your patient.</br>";
Hashtable vHashtable = new Hashtable();
vHashtable.Add("IEPDT_ID", vID);
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_IEPDT_ID_NEW"));
if (vDR != null)
{
TXTID.Value = vDR["IEPDT_ID"].ToString();
DDLDIS.SelectedValue = vDR["IEPDT_DISID"].ToString();
DDLDIS.Enabled = false;
}
else
{
ShowMsg("Invalid IEP ID");
}
Hashtable vHashtable1 = new Hashtable();
vHashtable1.Add("IEPDT_ID", vID);
vHashtable1.Add("IEPAT_PTPID", CCID);
dt = DBManager.Get(vHashtable1, "GET_IEP_PATIENT");
if (dt.Rows.Count > 0)
{
ViewState["datagrid"] = dt;
BindGrid();
}
CCID = Request.QueryString["id1"];
Hashtable vHashtable2 = new Hashtable();
vHashtable2.Add("PTP_ID", CCID);
DataRow vDR1 = RetDR(DBManager.Get(vHashtable2, "GET_PATIENT_ID"));
if (vDR1 != null)
{
PTP_ID.Value = vDR1["PTP_ID"].ToString();
PATIENT_TXT.Text = vDR1["PTP_NAME"].ToString();
PATIENT_TXT.Enabled = false;
}
else
{
ShowMsg("Invalid IEP ID");
}
}
}
else if (vATSession.UserType == "THERAPIST" || vATSession.UserType == "Therapist")
{
if (vID != null)
{
Label1.Text = "The IEP template assist the therapists to create daily, weekly, monthly or yearly Individualized Educational plan (IEP) of your patient. You may select category first and then its corresponding subcategory for the skills that you want to include in your IEP of your patient." +
"<br><b>Suggested Activity:</b> Comprehensive list of suggested activities is provided to you (therapist) based on the skills that you have included in your patient's IEP . You can use these activities as it is or can modify them as per your need. Kindly note that these are suggested activities, its therapists decision whether to use them or not.</ br>" +
"<br><b>Intervention Resources:</b> Intervention Resources/tools are an integral part of any therapy. In our therapy sessions, we need customized intervention resources for our patients.Its our constant endeavor of NerdNerdy, to create, develop or bring in unique research backed intervention tools for our children.</ br>" +
"<br>Based on the chosen IEP, the resources can be selected under the resource tab. The link would come in the IEP itself, once you click the link, it will take you to the website. You can buy the resources from website.</ br>" +
"<br><b>Progress Review-</b> You can review the progress of your patient through progress review tab.The progress can be viewed category,sub-category wise & time-line basis.</ br>" +
"<br><b>Progress-</b> You can fill the progress of your patient by selecting options- Accomplished (if the patient has acquired the skill that you introduced in your IEP), Emerging (If the skill is still not fully acquired) & No Improvement (if the skill is not acquired and needs more practice, thus can be reintroduced in your IEP). Once you select any of the three given options, please update the progress by clicking the, <b>update button</b> in order to save the progress of your patient.</br>";
Hashtable vHashtable = new Hashtable();
vHashtable.Add("IEPDT_ID", vID);
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_IEPDT_ID_NEW"));
if (vDR != null)
{
TXTID.Value = vDR["IEPDT_ID"].ToString();
DDLDIS.SelectedValue = vDR["IEPDT_DISID"].ToString();
DDLDIS.Enabled = false;
}
else
{
ShowMsg("Invalid IEP ID");
}
Hashtable vHashtable1 = new Hashtable();
vHashtable1.Add("IEPDT_ID", vID);
vHashtable1.Add("IEPAT_PTPID", CCID);
dt = DBManager.Get(vHashtable1, "GET_IEP_PATIENT");
if (dt.Rows.Count > 0)
{
ViewState["datagrid"] = dt;
BindGrid();
}
CCID = Request.QueryString["id1"];
Hashtable vHashtable2 = new Hashtable();
vHashtable2.Add("PTP_ID", CCID);
DataRow vDR1 = RetDR(DBManager.Get(vHashtable2, "GET_PATIENT_ID"));
if (vDR1 != null)
{
PTP_ID.Value = vDR1["PTP_ID"].ToString();
PATIENT_TXT.Text = vDR1["PTP_NAME"].ToString();
PATIENT_TXT.Enabled = false;
}
else
{
ShowMsg("Invalid IEP ID");
}
}
}
}
catch (Exception xe)
{
ShowMsg(xe);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
dt = new DataTable();
DataColumn coldisname = new DataColumn();
coldisname.DataType = Type.GetType("System.String");
coldisname.ColumnName = "DCAT_NAME";
dt.Columns.Add(coldisname);
DataColumn coltypgroup = new DataColumn();
coltypgroup.DataType = Type.GetType("System.String");
coltypgroup.ColumnName = "DSCAT_DESC";
dt.Columns.Add(coltypgroup);
DataColumn coltypgroup1 = new DataColumn();
coltypgroup1.DataType = Type.GetType("System.String");
coltypgroup1.ColumnName = "DOBS_DESC";
dt.Columns.Add(coltypgroup1);
DataColumn coldcname = new DataColumn();
coldcname.DataType = Type.GetType("System.String");
coldcname.ColumnName = "SCTR_PERCENTAGE";
dt.Columns.Add(coldcname);
DataColumn coldesc = new DataColumn();
coldesc.DataType = Type.GetType("System.String");
coldesc.ColumnName = "SCTR_SCALE";
dt.Columns.Add(coldesc);
DataColumn coldID = new DataColumn();
coldID.DataType = Type.GetType("System.String");
coldID.ColumnName = "AGDD_ID";
dt.Columns.Add(coldID);
DataColumn SCREEN = new DataColumn();
SCREEN.DataType = Type.GetType("System.String");
SCREEN.ColumnName = "SCTD_SCTPID";
dt.Columns.Add(SCREEN);
DataColumn SCREENT = new DataColumn();
SCREENT.DataType = Type.GetType("System.String");
SCREENT.ColumnName = "SCTR_SCTDID";
dt.Columns.Add(SCREENT);
DataColumn SCTR = new DataColumn();
SCTR.DataType = Type.GetType("System.String");
SCTR.ColumnName = "SCTR_ID";
dt.Columns.Add(SCTR);
DataColumn SCTR_DISID = new DataColumn();
SCTR_DISID.DataType = Type.GetType("System.String");
SCTR_DISID.ColumnName = "SCTR_DISID";
dt.Columns.Add(SCTR_DISID);
DataColumn SCTP_ID = new DataColumn();
SCTP_ID.DataType = Type.GetType("System.String");
SCTP_ID.ColumnName = "SCTP_ID";
dt.Columns.Add(SCTP_ID);
ViewState["datagrid"] = dt;
Templatenew.Visible = false;
btnSave.Visible = false;
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLAGE, DBManager.Get(new Hashtable(), "CMB_AGE_SCREEN_MASTER"), "Select Group Name", "AGRP_GROUP", "AGRP_ID", "0");//AGRP_ANMID=1 HARD
ATCommon.FillDrpDown(DDLDIS, DBManager.Get(new Hashtable(), "CMB_DIS_MASTER"), "Select Disorder Name", "DIS_NAME", "DIS_ID", "0");
if (vID != null)
{
TextBox SCTR_PERCENTAGE = (TextBox)FindControl("SCTR_PERCENTAGE");
TextBox SCTR_SCALE = (TextBox)FindControl("SCTR_SCALE");
if (vID != null)
{
Hashtable vHashtable4 = new Hashtable();
vHashtable4.Add("SCTP_ID", vID);
DataRow vDR4 = RetDR(DBManager.Get(vHashtable4, "GET_MASTER_DISID"));
if (vDR4 != null)
{
DDLDIS.SelectedItem.Text = vDR4["DIS_NAME"].ToString();
HiddenField1.Value = vDR4["SCTR_DISID"].ToString();
}
}
Hashtable vHashtable = new Hashtable();
vHashtable.Add("SCTP_ID", vID);
vHashtable.Add("SCTR_DISID", HiddenField1.Value);
vHashtable.Add("AGRP_ID", DDLAGE.SelectedValue);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_MASTER_SCREEN_ID"));
if (vDR != null)
{
TXTID.Value = vDR["SCTP_ID"].ToString();
SCREEN_TXT.Text = vDR["SCTP_NAME"].ToString();
DDLAGE.Text = vDR["AGRP_ID"].ToString();
SCREEN_TXT.Enabled = false;
DDLAGE.Enabled = false;
}
else
{
ShowMsg("Invalid Screen ID");
}
}
if (DDLAGE.SelectedValue != "0")
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("SCTP_ID", TXTID.Value);
vHashtable.Add("SCTR_DISID", HiddenField1.Value);
vHashtable.Add("AGRP_ID", DDLAGE.SelectedValue);
vHashtable.Add("TYPE", "GET");
DataTable dt4 = DBManager.Get(vHashtable, "GET_MASTER_SCREEN_NEW");
if (dt4.Columns.Count > 0)
{
GV_NEWTEMPLATE.Visible = true;
GV_NEWTEMPLATE.DataSource = dt4;
GV_NEWTEMPLATE.DataBind();
}
if (dt4.Columns.Count > 15)
{
if (Panel1.Visible == true)
{
for (int j = 0; j < GV_NEWTEMPLATE.Rows.Count; j++)
{
TextBox SCTR_PERCENTAGE = (TextBox)GV_NEWTEMPLATE.Rows[j].Cells[4].FindControl("SCTR_PERCENTAGE");
TextBox SCTR_SCALE = (TextBox)GV_NEWTEMPLATE.Rows[j].Cells[5].FindControl("SCTR_SCALE");
SCTR_PERCENTAGE.Text = dt4.Rows[j][23].ToString();
SCTR_SCALE.Text = dt4.Rows[j][24].ToString();
SCTR_PERCENTAGE.Enabled = false;
SCTR_SCALE.Enabled = false;
SCTR_ID.Value = dt4.Rows[j][21].ToString();
}
}
btnSave.Visible = false;
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
if (TXTID.Value == "0")
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("CUST_ID", TXTID.Value);
vHashtable.Add("CUST_VSOHQ_ID", "0");
vHashtable.Add("CUST_STA_ID", RegioanlHQ_DDL.SelectedValue.ToString());
vHashtable.Add("CUST_NAME", TXT_ORGANIZATION.Text);
vHashtable.Add("CUST_PROSPECTIVE", "");
vHashtable.Add("CUST_PREFIX", "");
vHashtable.Add("CUST_ADDRESS", TXT_ADDRESS.Text);
vHashtable.Add("CUST_COMP_NAME", TXT_ORGANIZATION.Text);
vHashtable.Add("CUST_DISTRICT", "0");
vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
vHashtable.Add("CUST_POST_OFFICE", "");
vHashtable.Add("CUST_STATE", "0");
vHashtable.Add("CUST_CATRGORY_ID", "");
vHashtable.Add("CUST_CONSULT_NAME", "");
vHashtable.Add("CUST_CONSULT_MOB", TXT_MOBILE_NO.Text);
vHashtable.Add("CUST_PIN", TXT_PIN.Text);
vHashtable.Add("CUST_PHONE", TXT_MOBILE_NO.Text);
vHashtable.Add("CUST_EMAIL", TXT_EMAIL.Text);
vHashtable.Add("CUST_MOBILE", TXT_MOBILE_NO.Text);
vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
vHashtable.Add("CUST_DESIGNATION", "");
vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
vHashtable.Add("CUST_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
vHashtable.Add("CUST_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
vHashtable.Add("CUST_VALUE", TXT_PATIENT.Text);
if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
{
if (HiddenField1.Value.Equals("0"))
{
try
{
string pwd = Create_Password();
Hashtable vHT = new Hashtable();
vHT.Add("ID", HiddenField1.Value);
vHT.Add("USR_LOGIN", TXT_MOBILE_NO.Text);
vHT.Add("USR_PASSWORD", pwd);
vHT.Add("USR_TYPE", DDL_USER_TYPE.SelectedValue);
vHT.Add("USR_COMPANY", vATSession.Company.ToString());
vHT.Add("USR_ZONE_ID", "0");
vHT.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
vHT.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
vHT.Add("USR_VSOHQ_ID", "0");
vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue.ToString());
vHT.Add("USR_CONT_NAME", "");
vHT.Add("USR_ADDRESS", TXT_ADDRESS.Text);
vHT.Add("USR_PIN", TXT_PIN.Text);
vHT.Add("USR_PHONE", TXT_MOBILE_NO.Text);
vHT.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
vHT.Add("USR_FAX", "");
vHT.Add("USR_EMAIL", TXT_EMAIL.Text);
vHT.Add("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
vHT.Add("USR_FROM_DATE", TXT_START.Text);
vHT.Add("USR_TO_DATE", TXT_END.Text);
vHT.Add("USR_SUBSCRIPTION_NUMBER", TXT_Sub.Text);
vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_PATIENT.Text);
vHT.Add("USR_CLINICAL_HEAD", "");
DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
ATApp vATApp = (ATApp)Application["Config"];
String vBody = "Dear " + "" + "\n\nLogin Details for NerdNerdy Web Application.\n\n";
vBody += "URL is: www.nerdnerdy.in\n";
vBody += "Login: "******"\nPassword:"******"\n\n";
vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
ATCommon.SendMail(TXT_EMAIL.Text, "Login Details for NerdNerdy Application.", vBody, vATApp);
ShowMsg(int.Parse(TXTID.Value));
Clear();
}
catch (Exception xe)
{
ShowMsg(xe);
}
}
else
{
Hashtable vHT1 = new Hashtable();
vHT1.Add("USR_LOGIN", TXT_MOBILE_NO.Text.Trim());
vHT1.Add("USR_ZONE_ID", "");
vHT1.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
vHT1.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
vHT1.Add("USR_VSOHQ_ID", "0");
vHT1.Add("USR_CONT_NAME", TXT_ORGANIZATION.Text);
vHT1.Add("USR_TYPE", "ORGANIZATION");
vHT1.Add("USR_EMAIL", TXT_EMAIL.Text);
vHT1.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
}
ShowMsg(int.Parse(TXTID.Value));
Clear();
Response.Redirect("User_AdminList.aspx");
}
}
else
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("CUST_ID", TXTID.Value);
vHashtable.Add("CUST_VSOHQ_ID", "0");
vHashtable.Add("CUST_STA_ID", RegioanlHQ_DDL.SelectedValue.ToString());
vHashtable.Add("CUST_NAME", TXT_ORGANIZATION.Text);
vHashtable.Add("CUST_PROSPECTIVE", "");
vHashtable.Add("CUST_PREFIX", "");
vHashtable.Add("CUST_ADDRESS", TXT_ADDRESS.Text);
vHashtable.Add("CUST_COMP_NAME", TXT_ORGANIZATION.Text);
vHashtable.Add("CUST_DISTRICT", "0");
vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
vHashtable.Add("CUST_POST_OFFICE", "");
vHashtable.Add("CUST_STATE", "0");
vHashtable.Add("CUST_CATRGORY_ID", "");
vHashtable.Add("CUST_CONSULT_NAME", "");
vHashtable.Add("CUST_CONSULT_MOB", TXT_MOBILE_NO.Text);
vHashtable.Add("CUST_PIN", TXT_PIN.Text);
vHashtable.Add("CUST_PHONE", TXT_MOBILE_NO.Text);
vHashtable.Add("CUST_EMAIL", TXT_EMAIL.Text);
vHashtable.Add("CUST_MOBILE", TXT_MOBILE_NO.Text);
vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
vHashtable.Add("CUST_DESIGNATION", "");
vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
vHashtable.Add("CUST_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
vHashtable.Add("CUST_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
vHashtable.Add("CUST_VALUE", TXT_PATIENT.Text);
if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
{
if (HiddenField1.Value.Equals("0"))
{
try
{
Hashtable vHT = new Hashtable();
vHT.Add("ID", HiddenField1.Value);
vHT.Add("USR_LOGIN", TXT_MOBILE_NO.Text);
vHT.Add("USR_PASSWORD", TXT_PASSWORD.Text);
vHT.Add("USR_TYPE", DDL_USER_TYPE.SelectedValue);
vHT.Add("USR_COMPANY", vATSession.Company.ToString());
vHT.Add("USR_ZONE_ID", "0");
vHT.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
vHT.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
vHT.Add("USR_VSOHQ_ID", "0");
vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue.ToString());
vHT.Add("USR_CONT_NAME", "");
vHT.Add("USR_ADDRESS", TXT_ADDRESS.Text);
vHT.Add("USR_PIN", TXT_PIN.Text);
vHT.Add("USR_PHONE", TXT_MOBILE_NO.Text);
vHT.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
vHT.Add("USR_FAX", "");
vHT.Add("USR_EMAIL", TXT_EMAIL.Text);
vHT.Add("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
vHT.Add("USR_FROM_DATE", TXT_START.Text);
vHT.Add("USR_TO_DATE", TXT_END.Text);
vHT.Add("USR_SUBSCRIPTION_NUMBER", TXT_Sub.Text);
vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_PATIENT.Text);
vHT.Add("USR_CLINICAL_HEAD", "");
DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
ATApp vATApp = (ATApp)Application["Config"];
String vBody = "Dear " + "" + "\n\nLogin Details for NerdNerdy Web Application.\n\n";
vBody += "URL is: www.nerdnerdy.in\n";
vBody += "Login: "******"\nPassword:"******"\n\n";
vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
ATCommon.SendMail(TXT_EMAIL.Text, "Login Details for NerdNerdy Application.", vBody, vATApp);
ShowMsg(int.Parse(TXTID.Value));
Clear();
}
catch (Exception xe)
{
ShowMsg(xe);
}
}
else
{
Hashtable vHT1 = new Hashtable();
vHT1.Add("USR_LOGIN", TXT_MOBILE_NO.Text.Trim());
vHT1.Add("USR_ZONE_ID", "");
vHT1.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
vHT1.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
vHT1.Add("USR_VSOHQ_ID", "0");
vHT1.Add("USR_CONT_NAME", TXT_ORGANIZATION.Text);
vHT1.Add("USR_TYPE", "ORGANIZATION");
vHT1.Add("USR_EMAIL", TXT_EMAIL.Text);
vHT1.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
}
ShowMsg(int.Parse(TXTID.Value));
Clear();
Response.Redirect("User_AdminList.aspx");
}
}
}
catch (Exception xe)
{
ShowMsg(xe);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
PTP_TXT.Text = vATSession.UserName;
if (vATSession.UserType == "ADMIN")
{
GridView1.Visible = true;
hidden1.Visible = true;
btnSave.Visible = false;
}
else
{
GridView1.Visible = true;
}
if (!IsPostBack)
{
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DEVCOND_ID, DBManager.Get(new Hashtable(), "CMB_DEVELOPMENT_MASTER"), "Select Development Condition Name", "DEV_NAME", "DEV_ID", "0");
if (vID != null)
{
PTP_ID.Value = vID;
Hashtable vHashtable = new Hashtable();
vHashtable.Add("PTP_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_PATIENT_DEVELOPMENT_NEW"));
if (vDR != null)
{
PTP_ID.Value = vID;
vID = vDR["PTP_ID"].ToString();
PTP_TXT.Text = vDR["PTP_NAME"].ToString();
Textarea1.Value = vDR["PTP_NAME"].ToString() + " " + "did/did not reach all the major developmental milestones on time. The developmental " +
"milestones were reported as within the normal range for ------------" + "<br />" +
"a) Physical development"+ "<br />" +
"b) Speech and language development"+ "<br />" +
"c) Cognitive development"+ "<br />" +
"d) Fine Motor development"+ "<br />" +
"e) Gross Motor Development."+ "<br />" + "However, he/she has poor----------" + "<br />" + "a) Physical development" + "<br />" + "b) Speech and language development"+ "<br />" +
"c) Cognitive development"+ "<br />" + "d) Fine Motor development"
+ "<br />" + "e) Gross Motor Development.";
Hashtable vHashtable2 = new Hashtable();
vHashtable2.Add("PTP_ID", vID);
DataRow vDR2 = RetDR(DBManager.Get(vHashtable2, "GET_PT_DEVELOPMENT_ID"));
if (vDR2 != null)
{
btnSave.Visible = false;
}
}
else
{
ShowMsg("Invalid Patient Development ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
dt = new DataTable();
DataColumn coldisname = new DataColumn();
coldisname.DataType = Type.GetType("System.String");
coldisname.ColumnName = "AGDD_AGDMID";
dt.Columns.Add(coldisname);
DataColumn coltypgroup = new DataColumn();
coltypgroup.DataType = Type.GetType("System.String");
coltypgroup.ColumnName = "AGDD_DOBSID";
dt.Columns.Add(coltypgroup);
DataColumn coltypgroup1 = new DataColumn();
coltypgroup1.DataType = Type.GetType("System.String");
coltypgroup1.ColumnName = "AGDD_DSCATID";
dt.Columns.Add(coltypgroup1);
DataColumn coldcname = new DataColumn();
coldcname.DataType = Type.GetType("System.String");
coldcname.ColumnName = "DCAT_NAME";
dt.Columns.Add(coldcname);
DataColumn coldesc = new DataColumn();
coldesc.DataType = Type.GetType("System.String");
coldesc.ColumnName = "DSCAT_DESC";
dt.Columns.Add(coldesc);
DataColumn coldobdes = new DataColumn();
coldobdes.DataType = Type.GetType("System.String");
coldobdes.ColumnName = "DOBS_DESC";
dt.Columns.Add(coldobdes);
DataColumn coldID = new DataColumn();
coldID.DataType = Type.GetType("System.String");
coldID.ColumnName = "AGDD_ID";
dt.Columns.Add(coldID);
ViewState["datagrid"] = dt;
BindGrid();
Clear();
DDLDIS.Enabled = true;
DDLAGE.Enabled = true;
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLDIS, DBManager.Get(new Hashtable(), "CMB_DIS_MASTER"), "Select Disorder Name", "DIS_NAME", "DIS_ID", "0");
ATCommon.FillDrpDown(DDLAGE, DBManager.Get(new Hashtable(), "CMB_AGE_GRP_MASTER"), "Select Group Name", "AGRP_GROUP", "AGRP_ID", "0");
ATCommon.FillDrpDown(DDLCAT, DBManager.Get(new Hashtable(), "CMB_DIS_CAT_MASTER"), "Select Category Name", "DCAT_NAME", "DCAT_ID", "0");
//ATCommon.FillDrpDown(DDLSUBCAT, DBManager.Get(new Hashtable(), "CMB_DIS_SUBCAT_MASTER"), "Select Sub Category Name", "DSCAT_DESC", "DSCAT_ID", "0");
ATCommon.FillDrpDown(DDLOBSER, DBManager.Get(new Hashtable(), "CMB_DIS_OBSV_MASTER"), "Select Observation Name", "DOBS_DESC", "DOBS_ID", "0");
ATCommon.FillDrpDown(ANALYSIS_DDL, DBManager.Get(new Hashtable(), "CMB_ANALYSIS_MASTER"), "Select Analysis Name", "ANM_NAME", "ANM_ID", "0");
if (vID != null)
{
Hashtable vHashtable1 = new Hashtable();
vHashtable1.Add("ID", vID);
dt = DBManager.Get(vHashtable1, "GET_AGDIS_DETAIL");
ViewState["datagrid"] = dt;
BindGrid();
Hashtable vHashtable = new Hashtable();
vHashtable.Add("AGDM_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_AGDIS_MASTER_NEW"));
if (vDR != null)
{
TXTID.Value = vDR["AGDM_ID"].ToString();
DDLDIS.SelectedValue = vDR["AGDM_DISID"].ToString();
DDLAGE.SelectedValue = vDR["AGDM_AGRPID"].ToString();
DDLAGE.SelectedItem.Text = vDR["AGRP_GROUP"].ToString();
ANALYSIS_DDL.SelectedValue = vDR["AGDM_ANMID"].ToString();
DDLAGE.Enabled = false;
DDLDIS.Enabled = false;
ANALYSIS_DDL.Enabled = false;
btnAdd.Visible = false;
btnSave.Visible = false;
AGE_GRP.Enabled = false;
}
else
{
ShowMsg("Invalid Age ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
