public static string MedDetails(string MedName)
{
IssueHeaderDetails IssuedtlsObj = new IssueHeaderDetails();
UIClasses.Const Const = new UIClasses.Const();
ClinicDAL.UserAuthendication UA;
UA = (ClinicDAL.UserAuthendication)HttpContext.Current.Session[Const.LoginSession];
IssuedtlsObj.ClinicID = UA.ClinicID.ToString();
DataSet ds = IssuedtlsObj.GetMedicineDetailsByMedicineName(MedName);
string Unit = "";
string MedCode = "";
string Category = "";
string Qty = "";
if (ds.Tables[0].Rows.Count > 0)
{
Unit = Convert.ToString(ds.Tables[0].Rows[0]["Unit"]);
MedCode = Convert.ToString(ds.Tables[0].Rows[0]["MedCode"]);
Category = Convert.ToString(ds.Tables[0].Rows[0]["CategoryName"]);
Qty = Convert.ToString(ds.Tables[0].Rows[0]["Qty"]);
}
return String.Format("{0}" + "|" + "{1}" + " | " + "{2}" + " | " + "{3}", Unit, MedCode, Category, Qty);
}
public void bindpageload()
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
stok.ClinicID = UA.ClinicID.ToString();
//gridview binding for listing the Out of Stock Medicines
DataSet gds = stok.ViewOutofStockMedicines();
GridViewOutofStock.EmptyDataText = "No Records Found";
GridViewOutofStock.DataSource = gds;
GridViewOutofStock.DataBind();
//Binding Category ID and Name
stok.ClinicID = UA.ClinicID.ToString();
DataSet ds = stok.ViewCategories();
ddlCategory.DataSource = ds.Tables[0];
ddlCategory.DataValueField = "CategoryID";
ddlCategory.DataTextField = "Name";
ddlCategory.DataBind();
listFilter = null;
listFilter = BindName();
}
protected void Page_Load(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
rpt.ClinicID = UA.ClinicID.ToString();
GridViewStockIN();
}
public void BindOutOfStockGridview()
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
stockObj.ClinicID = UA.ClinicID.ToString();
//gridview binding for listing the Out of Stock Medicines
DataSet gds = stockObj.ViewOutofStockMedicines();
gvOutOfStock.EmptyDataText = "No Records Found";
gvOutOfStock.DataSource = gds;
gvOutOfStock.DataBind();
}
protected void btnsave_ServerClick(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
ClinicDAL.CaseFile.Visit VisitsObj = new ClinicDAL.CaseFile.Visit();
VisitsObj.DoctorID = Guid.Parse("469489AE-6237-47B3-B8CC-74B62EC81D77");
VisitsObj.ClinicID =Guid.Parse("2C7A7172-6EA9-4640-B7D2-0C329336F289");
VisitsObj.FileID = Guid.Parse("232CFE06-E9E9-42C1-B2F6-B992ABE0140A");
int feet = Convert.ToInt32(txtHeight.Value);
int inch = Convert.ToInt32(txtHeightinch.Value);
VisitsObj.Height = float.Parse(feet.ToString()+ "." +inch.ToString());
VisitsObj.Weight = float.Parse(txtWeight.Value);
VisitsObj.Symptoms =(symptoms.Value !=null)? symptoms.Value.ToString():null;
VisitsObj.Cardiovascular =(cardiovascular.Value !=null)? cardiovascular.Value.ToString():null;
VisitsObj.Nervoussystem = (nervoussystem.Value != null) ? nervoussystem.Value.ToString() : null;
VisitsObj.Musculoskeletal = (musculoskeletal.Value != null) ? musculoskeletal.Value.ToString() : null;
VisitsObj.Palloe = (palloe.Value!=null)? palloe.Value.ToString():null;
VisitsObj.Icterus = (icterus.Value!=null)? icterus.Value.ToString():null;
VisitsObj.Clubbing = (clubbing.Value!=null)? clubbing.Value.ToString():null;
VisitsObj.Cyanasis =(cyanasis.Value!=null)? cyanasis.Value.ToString():null;
VisitsObj.Edima = (edima.Value != null) ? edima.Value.ToString() : null;
VisitsObj.Bowel = (bowel.Value!=null)? bowel.Value.ToString():null;
VisitsObj.Appettie = (appettie.Value!=null)? appettie.Value.ToString():null;
VisitsObj.Micturation =(micturation.Value!=null)? micturation.Value.ToString():null;
VisitsObj.Sleep = (sleep.Value!=null)? sleep.Value.ToString():null;
VisitsObj.Diagnosys =(diagnosys.Value!=null)? diagnosys.Value.ToString():null;
VisitsObj.Remarks = (remarks.Value!=null)? remarks.Value.ToString():null;
VisitsObj.CreatedBy = "thomson";
VisitsObj.UpdatedBy = "thomson";
VisitsObj.Bp = (bp.Value != null) ? bp.Value.ToString() : null;
VisitsObj.Pulse = (pulse.Value!=null)? pulse.Value.ToString():null;
VisitsObj.Tounge = (tounge.Value!=null)? tounge.Value.ToString():null;
VisitsObj.Heart =(heart.Value!=null)? heart.Value.ToString():null;
VisitsObj.LymphGen = (lymphGen.Value!=null)? lymphGen.Value.ToString():null;
VisitsObj.LymphClinic =(lymphnodes.Value!=null)? lymphnodes.Value.ToString():null;
VisitsObj.RespRate = (resp_rate.Value!=null)? resp_rate.Value.ToString():null;
VisitsObj.Others = (others.Value != null) ? others.Value.ToString() : null;
if(VisitsObj.Diagnosys!="")
{
VisitsObj.AddVisits();
}
//Fetching values of prescription from Design throurh Hiddenfield
string values = HiddenField1.Value;
if (values != null)
{
string[] Invalue = values.Split('|');
int count = Invalue.Length - 1;
for (int i = 0; i < count; i = i + 4)
{
string w = Invalue[i], x = Invalue[i + 1], y = Invalue[i + 2], z = Invalue[i + 3];
}
}
}
public void AddNewCategory()
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
CategoryObj.CategoryName = txtCategoryName.Text;
CategoryObj.ClinicID = UA.ClinicID;
CategoryObj.CreatedBy = UA.userName;
CategoryObj.AddNewCategory();
}
public void BindCategory()
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
StockObj.ClinicID = UA.ClinicID.ToString();
ddlCategory.DataSource = StockObj.ViewCategories();
ddlCategory.DataTextField = "Name";
ddlCategory.DataValueField = "CategoryID";
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, "--Select--");
}
public void bindpageload()
{
listFilter = null;
listFilter = BindName();
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
ihd.ClinicID = UA.ClinicID.ToString();
idt.ClinicID = UA.ClinicID.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
receipt = Guid.Parse(Request.QueryString["ReceiptID"]);
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
rpt.ClinicID = UA.ClinicID.ToString();
GridViewReceiptDetails();
//assign value for receipt
}
public string UserLogin(string username, string password)
{
//return msg data initialization
DataSet ds = new DataSet();
DataTable loginMsg = new DataTable();
loginMsg.Columns.Add("Flag", typeof(Boolean));
loginMsg.Columns.Add("Message", typeof(String));
DataRow dr = loginMsg.NewRow();
ClinicDAL.CryptographyFunctions crypto = new ClinicDAL.CryptographyFunctions();
username = crypto.Decrypt(username);
password = crypto.Decrypt(password);
try
{
//user credentials checking
ClinicDAL.UserAuthendication UA = new ClinicDAL.UserAuthendication(username, password);
if (UA.ValidUser)
{
dr["Flag"] = true;
dr["Message"] = UIClasses.Messages.LoginSuccess;
loginMsg.Columns.Add("ClinicID", typeof(String));
dr["ClinicID"] = UA.ClinicID;
}
else
{
dr["Flag"] = false;
dr["Message"] = UIClasses.Messages.LoginFailed;
}
}
catch (Exception ex)
{
dr["Flag"] = false;
dr["Message"] = ex.Message; //exception message to be passed as JSON
}
finally
{
//returning data
loginMsg.Rows.Add(dr);
ds.Tables.Add(loginMsg);
}
return getDbDataAsJSON(ds);
}
//public Guid DoctorRoleID = new Guid("69668C0B-1231-4229-A7FA-5C0CD3744435");
#endregion Global Variables
#region Methods
//---* To USER *--//
#region User
#region Add User To User Table
public void AddUserToUserTable()
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
userObj.firstName = txtFirstName.Text;
userObj.loginName = txtLoginName.Text;
userObj.lastName = txtLastName.Text;
if (rdoActiveYes.Checked == true)
{
userObj.isActive = true;
}
else
{
if (rdoActiveNo.Checked == true)
{
userObj.isActive = false;
}
}
userObj.ClinicID = UA.ClinicID;
//userObj.ClinicID = new Guid("2c7a7172-6ea9-4640-b7d2-0c329336f289");
userObj.createdBy = UA.userName;
userObj.updatedBy = UA.userName;
userObj.passWord = CryptObj.Encrypt(txtPassword.Text);
userObj.Email = txtEmail.Text;
userObj.PhoneNo = txtPhoneNumber.Text;
if (btnSave.Text == "Save")
{
userObj.AddUser();
BindGriewWithDetailsOfAllUsers();
}
else
{
if (btnSave.Text == "Update")
{
userObj.UserID = Guid.Parse(hdnUserID.Value);
userObj.UpdateuserByUserID();
BindGriewWithDetailsOfAllUsers();
}
}
}
public static string GetMedicines(string searchTerm, int pageIndex)
{
ClinicDAL.UserAuthendication UA;
UIClasses.Const Const = new UIClasses.Const();
UA = (ClinicDAL.UserAuthendication)HttpContext.Current.Session[Const.LoginSession];
string query = "ViewAndFilterMedicine";
SqlCommand cmd = new SqlCommand(query);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = UA.ClinicID;
cmd.Parameters.AddWithValue("@SearchTerm", searchTerm);
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", PageSize);
cmd.Parameters.Add("@RecordCount", SqlDbType.Int).Direction = ParameterDirection.Output;
var xml = GetData(cmd, pageIndex).GetXml();
return xml;
}
public static string MedDetails(string MedName)
{
ClinicDAL.ReceiptDetails obj = new ClinicDAL.ReceiptDetails();
UIClasses.Const Const = new UIClasses.Const();
ClinicDAL.UserAuthendication UA;
UA = (ClinicDAL.UserAuthendication)HttpContext.Current.Session[Const.LoginSession];
obj.ClinicID = UA.ClinicID.ToString();
DataSet ds = obj.GetMedCodeUnitCategory(MedName);
string Unit = Convert.ToString(ds.Tables[0].Rows[0]["Unit"]);
string MedCode = Convert.ToString(ds.Tables[0].Rows[0]["MedCode"]);
string Category = Convert.ToString(ds.Tables[0].Rows[0]["CategoryName"]);
return String.Format("{0}" + "|" + "{1}" + " | " + "{2}", Unit, MedCode, Category);
}
public void AddNewMedicine()
{
if (txtmedicineName.Text.Contains("$") || txtmedicineName.Text.Contains("|"))
{
//Medicine Name is not valid as it contains $ ,|
}
else
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
StockObj.Name = txtmedicineName.Text;
StockObj.MedCode = txtCode.Text;
StockObj.CategoryID = ddlCategory.SelectedValue;
StockObj.ReOrderQty = Convert.ToInt32(txtOrderQuantity.Text);
StockObj.ClinicID = UA.ClinicID.ToString();
StockObj.CreatedBy = UA.userName;
StockObj.Unit = txtUnit.Text;
StockObj.InsertMedicines();
}
}
public void BindGridviewAndLabels()
{
string IssueID = string.Empty;
DataSet dsIssuehdr = null;
if (Request.QueryString["IssueID"] != null || hdnIssueID.Value != null)
{
if (Request.QueryString["IssueID"] != null)
{
hdnIssueID.Value = Request.QueryString["IssueID"].ToString();
IssueID = Request.QueryString["IssueID"].ToString();
}
else
{
if (hdnIssueID.Value != null || hdnIssueID.Value != string.Empty)
{
IssueID = hdnIssueID.Value;
}
}
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
Issuehdrobj.ClinicID = UA.ClinicID.ToString();
dsIssuehdr = Issuehdrobj.GetIssueDetailsByIssueNO(IssueID);
//dtgExistingIssueByIssueNo.DataSource = dsIssuehdr;
//dtgExistingIssueByIssueNo.DataBind();
foreach (DataRow dr in dsIssuehdr.Tables[0].Rows)
{
lblIssueNo.Text = dr["IssueNo"].ToString();
lblIssuedTo.Text = dr["IssuedTo"].ToString();
lblIssueDate.Text = ((DateTime)dr["Date"]).ToString("dd-MM-yyyy");
}
}
}
/// <summary>
/// To bind issue no textbox with generated issue no , and is changable
/// </summary>
public void BindTextboxByIssueNo()
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
IssuehdrObj.ClinicID = UA.ClinicID.ToString();
string IssueNumber = IssuehdrObj.Generate_Issue_Number();
txtIssueNO.Text = IssueNumber;
}
protected void btnSave_Click(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
roleObj.UserID = new Guid(ddlUsers.SelectedValue);
dtUsers = (DataTable)ViewState["dtUsers"];
//DataRow[] foundRow = dtUsers.Select("UserID = " + ddlUsers.SelectedValue);
roleObj.RoleID = new Guid(ddlRoles.SelectedValue);
//roleObj.ClinicID =UA.ClinicID;
roleObj.ClinicID = new Guid("2c7a7172-6ea9-4640-b7d2-0c329336f289");
roleObj.CreatedBy = UA.userName;
roleObj.AssignRole();
BindGriewWithDetailsOfAssignedRoles();
//string TotalRole = string.Empty; ;
//for (int i = 0; i < cblRoles.Items.Count - 1; i++)
//{
// if (cblRoles.Items[i].Selected)
// TotalRole += cblRoles.Items[i].Value.ToString() + ",";
//}
}
protected void Page_Load(object sender, EventArgs e)
{
BindListFilter();
txtDate.Attributes.Add("readonly", "readonly");
string issueID = string.Empty;
DataSet dsIssuehdr = null;
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
//---------- * Checking whether redirection to the page happened by clicking in gridview or by clicking the new issue button *----------//
if (Request.QueryString["issueID"] == null)
{
//-----*Redirection due to new issue button click*-----//
if (!IsPostBack)
{
BindTextboxByIssueNo();
}
}
else
{
//-----*Redirection due to Grid link click*-----//
hdnHdrInserted.Value = "True";
issueID = Request.QueryString["issueID"].ToString();
IssuehdrObj.ClinicID = UA.ClinicID.ToString();
DataSet dsHdr = IssuehdrObj.GetIssueHeaderByIssueID(issueID);
dtIssuehdr = dsHdr.Tables[0];
if (dtIssuehdr.Rows.Count > 0)
{
ViewState["IssueHdrID"] = Request.QueryString["issueID"].ToString();
//foreach (DataRow dr in dsIssuehdr.Tables[0].Rows)
//{
if (!IsPostBack)
{
txtIssueNO.Text = dtIssuehdr.Rows[0]["IssueNO"].ToString();
txtIssuedTo.Text = dtIssuehdr.Rows[0]["IssuedTo"].ToString();
txtDate.Text = ((DateTime)dtIssuehdr.Rows[0]["Date"]).ToString("dd-MM-yyyy");
}
//}
dsIssuehdr = IssuehdrObj.GetIssueDetailsByIssueID(issueID);
var xml = dsIssuehdr.GetXml();
hdnXmlData.Value = xml;
}
}
}
protected void btnReceipt_Click(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
rpt.CreatedBy = UA.userName;
rpt.Date = Convert.ToDateTime(txtDate.Text);
rpt.RefNo1 = txtBillNo.Text;
rpt.RefNo2 = txtRefNo2.Text;
rpt.ClinicID = UA.ClinicID.ToString();
rpt.InsertReceiptHeader();
string values = HiddenField1.Value;
string[] Invalue = values.Split('|');
int len= Invalue.Length;
len = len - 1;
for (int i = 0; i <len ; i = i + 5)
{
ReceiptDetails rptdt = new ReceiptDetails();
rptdt.MedicineName = Invalue[i];
rptdt.QTY= Convert.ToInt32(Invalue[i + 4]);
rptdt.Unit = Invalue[i+1];
rptdt.CreatedBy = UA.userName;
rptdt.ClinicID = UA.ClinicID.ToString();
rptdt.ReceiptID = rpt.ReceiptID;
rptdt.InsertReceiptDetails();
}
// to reLOad added DAta To fields
string str = rpt.ReceiptID.ToString();
ReloadInsertFields(str);
}
protected void btnStock_Click(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
// CHECKING MEDICINE ALREADY EXITS condition...
string Name = Request.Form["txtSearch"];
if (Name != "")
{
DataTable dt = stok.GetMedcineDetails(Name);
if (dt.Rows.Count == 0)
{
stok.ClinicID = UA.ClinicID.ToString();
stok.CategoryID = ddlCategory.SelectedValue;
stok.Name = Name;
stok.Qty = 0;
stok.Unit = txtUnit.Text;
stok.CreatedBy = UA.userName;
stok.ReOrderQty = 10;
stok.MedCode ="med";
//calling medicine insertion
stok.InsertMedicines();
HiddenFieldMedicineID.Value = stok.MedicineID.ToString();
}
}
//Receipt Header
rpt.RefNo1 = txtReference1.Text;
rpt.RefNo2 = txtReference2.Text;
rpt.Date = Convert.ToDateTime(txtDate.Text);
rpt.ClinicID = UA.ClinicID.ToString();
rpt.CreatedBy = UA.userName;
//rpt.InsertReceiptHeader();
//Receipt Details MUST BE IN LOOP
ReceiptDetails rptdt = new ReceiptDetails();
rptdt.QTY = Convert.ToInt32(txtQty.Text);
rptdt.Unit =txtUnit.Text;
rptdt.MedicineID = HiddenFieldMedicineID.Value;
rptdt.ClinicID = UA.ClinicID.ToString();
rptdt.CreatedBy =UA.userName;
//Calling insert functions
//passing foreign key value
rptdt.ReceiptID = rpt.ReceiptID;
rptdt.InsertReceiptDetails();
}
/// <summary>
/// To fill xml with saved data
/// </summary>
/// <param name="IssueID"></param>
/// <returns>Dataset of issue details by id</returns>
public DataSet GetIssueDetailsByIssueID(string IssueID)
{
DataSet dsIssue = null;
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
IssuehdrObj.ClinicID = UA.ClinicID.ToString();
dsIssue = IssuehdrObj.GetIssueDetailsByIssueID(IssueID);
return dsIssue;
}
//---* To USER-In-ROLES *--//
#region USER-In-ROLES
public void AddUserRole()
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
roleObj.ClinicID = UA.ClinicID;
roleObj.RoleID = Guid.Parse(GetRoleIDOFDoctor());
roleObj.CreatedBy = UA.userName;
DataTable dtUsers = roleObj.GetDetailsOfAllUsers();
foreach(DataRow dr in dtUsers.Rows)
{
if(dr["LoginName"].ToString() == txtLoginName.Text)
{
roleObj.UserID = Guid.Parse(dr["UserID"].ToString());
}
}
roleObj.AssignRole();
//roleObj.UserID = Guid.Parse(foundRow["UserID"].ToString());
}
//---* To DOCTOR *--//
#region DOCTOR
#region GetRoleIDOFDoctor
public string GetRoleIDOFDoctor()
{
string DoctorRoleID=string.Empty;
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
userObj.ClinicID = UA.ClinicID;
DoctorRoleID = userObj.GetRoleIDOfDoctor();
return DoctorRoleID;
}
/// <summary>
/// Insert,update,delete operations are handling in this case.
/// Case 1 : If removedId hiddenfield has value, case is delete.
/// Case 2 : If DetaildId hiddenfield has value, case is Update
/// Case 3 : If DetailId is empty , Case is insert
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
if (hdnRemovedIDs.Value != string.Empty )
{
//----------------- * CASE : DELETE *-----------------------------------//
string hdRemovedIDValue = hdnRemovedIDs.Value;
string[] RemovedIDs = hdRemovedIDValue.Split(',');
for (int i = 0; i < RemovedIDs.Length - 1; i++)
{
if ( (RemovedIDs[i] !="") || (RemovedIDs[i] != string.Empty) )
{
IssueDetails DetailObj = new IssueDetails();
string UniqueId = RemovedIDs[i].ToString();
//string medId = DetailObj.GetMedicineIDByUniqueID(Guid.Parse(UniqueId));
DetailObj.ClinicID = UA.ClinicID.ToString();
DetailObj.DeleteIssueDetails(UniqueId);
hdnRemovedIDs.Value = "";
}
}
}
if (hdnRemovedIDs.Value == string.Empty)
{
if(hdnTextboxValues.Value != "")
{
if ((txtIssueNO.Text != string.Empty) && (txtIssuedTo.Text != string.Empty) && (txtDate.Text != string.Empty))
{
IssuehdrObj.ClinicID = UA.ClinicID.ToString();
IssuehdrObj.IssuedTo = txtIssuedTo.Text;
IssuehdrObj.IssueNO = txtIssueNO.Text;
IssuehdrObj.CreatedBy = UA.userName;
IssuehdrObj.Date = Convert.ToDateTime(txtDate.Text);
if ( (hdnHdrInserted.Value == "") && (hdnTextboxValues.Value != ""))
{
IssuehdrObj.InsertIssueHeader();
hdnHdrInserted.Value = "True";
ViewState["IssueHdrID"] = IssuehdrObj.IssueID;
}
if (ViewState["IssueHdrID"] != null && ViewState["IssueHdrID"].ToString() != string.Empty)
{
string issueid = ViewState["IssueHdrID"].ToString();
IssuehdrObj.ClinicID = UA.ClinicID.ToString();
DataSet dsHdr = IssuehdrObj.GetIssueHeaderByIssueID(issueid);
dtIssuehdr = dsHdr.Tables[0];
if (dtIssuehdr.Rows.Count > 0)
{
string oldDate = ((DateTime)dtIssuehdr.Rows[0]["Date"]).ToString("dd-MM-yyyy");
string newDate = txtDate.Text;
if ((txtIssueNO.Text != dtIssuehdr.Rows[0]["IssueNO"].ToString()) || (txtIssuedTo.Text != dtIssuehdr.Rows[0]["IssuedTo"].ToString()) || (oldDate != newDate))
{
// ----------------- * Update header*-----------------------------------//
if (hdnTextboxValues.Value != "")
{
IssuehdrObj.ClinicID = UA.ClinicID.ToString();
IssuehdrObj.IssuedTo = txtIssuedTo.Text;
IssuehdrObj.Date = Convert.ToDateTime(txtDate.Text);
IssuehdrObj.UpdatedBy = UA.userName;
//IssuehdrObj.IssueNO = txtIssueNO.Text;
IssuehdrObj.UpdateIssueHeader(ViewState["IssueHdrID"].ToString());
}
}
}
}
string last = string.Empty;
string values = hdnTextboxValues.Value;
string[] Rows = values.Split('$');
for (int i = 0; i < Rows.Length - 1; i++)
{
IssueDetails IssuedtlObj = new IssueDetails(); //Object is created in loop as each entry should have different uniqueID
string[] tempRow = Rows;
last = tempRow[i].Split('|').Last();
string[] columns = tempRow[i].Split('|');
if (last == string.Empty || last == "")
{
//----------------- * CASE : INSERT *-----------------------------------//
if ((columns[0] != null) && (columns[4] != null))
{
IssuedtlObj.MedicineName = columns[0];
IssuedtlObj.Unit = columns[1];
IssuedtlObj.Qty = Convert.ToInt32(columns[4]);
IssuedtlObj.CreatedBy = UA.userName; ;
IssuedtlObj.ClinicID = UA.ClinicID.ToString();
if (ViewState["IssueHdrID"] != null && ViewState["IssueHdrID"].ToString() != string.Empty)
{
IssuedtlObj.IssueID = Guid.Parse(ViewState["IssueHdrID"].ToString());
}
IssuedtlObj.InsertIssueDetails();
}
}
if (last != string.Empty )
{
//----------------- * CASE : UPDATE *---------------------------------//
if ((columns[0] != null) && (columns[4] != null))
{
string uniqueID = last;
IssueDetails UpIssueDtlObj = new IssueDetails(new Guid(uniqueID));
UpIssueDtlObj.ClinicID = UA.ClinicID.ToString();
UpIssueDtlObj.Qty = Convert.ToInt32(columns[4]);
UpIssueDtlObj.UpdatedBy = UA.userName;
//string medicineID = IssuedtlObj.GetMedcineIDByMedicineName(columns[0]);
UpIssueDtlObj.UpdateIssueDetails(uniqueID);
}
}
}
hdnManageGridBind.Value = "True";
}
}
}
StoreXmlToHiddenField();
}
public void AddUserToDoctorTable()
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
mstrObj.loginName = txtLoginName.Text;
mstrObj.ClinicID = UA.ClinicID;
mstrObj.DoctorName = txtFirstName.Text;
mstrObj.DoctorPhone = txtPhoneNumber.Text;
mstrObj.DoctorEmail = txtEmail.Text;
mstrObj.createdBy = UA.userName;
mstrObj.updatedBy = UA.userName;
mstrObj.InsertDoctors();
}
protected void btnSave_Click(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
CaseFileObj.DoctorID = Guid.Parse("469489AE-6237-47B3-B8CC-74B62EC81D77");
CaseFileObj.FileID = Guid.Parse(HiddenField2.Value);
CaseFileObj.ClinicID = UA.ClinicID;
CaseFileObj.Height = float.Parse(txtHeight.Text);
CaseFileObj.Weight=float.Parse(txtWeight.Text);
CaseFileObj.Symptoms=txtSymptoms.Text;
CaseFileObj.Bowel=txtBowel.Text;
CaseFileObj.Appettie=txtAppettie.Text;
CaseFileObj.Micturation=txtMicturation.Text;
CaseFileObj.Sleep=txtSleep.Text;
CaseFileObj.Cardiovascular=txtCardiovascular.Text;
CaseFileObj.Nervoussystem=txtNervoussystem.Text;
CaseFileObj.Musculoskeletal=txtMicturation.Text;
CaseFileObj.Palloe=txtPalloe.Text;
CaseFileObj.Icterus=txtIcterus.Text;
CaseFileObj.Clubbing=txtClubbing.Text;
CaseFileObj.Cyanasis=txtCyanasis.Text;
CaseFileObj.LymphGen=txtLymphGen.Text;
CaseFileObj.Edima=txtEdima.Text;
CaseFileObj.Diagnosys=txtdiagnosis.Text;
CaseFileObj.Remarks=txtRemarks.Text;
CaseFileObj.Pulse=txtPulse.Text;
CaseFileObj.Bp=txtBp.Text;
CaseFileObj.Tounge=txtTounge.Text;
CaseFileObj.Heart=txtHeart.Text;
CaseFileObj.LymphClinic=txtLymphClinic.Text;
CaseFileObj.RespRate=txtRespRate.Text;
CaseFileObj.Others=txtOthers.Text;
CaseFileObj.CreatedBy = UA.userName;
CaseFileObj.UpdatedBy = UA.userName;
CaseFileObj.AddVisits();
string values = HiddenField1.Value;
}
protected void ImgBtnUpdate_Command(object sender, CommandEventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
string[] Users = e.CommandArgument.ToString().Split(new char[] { '|' });
Guid UserID = Guid.Parse(Users[0]);
userObj.UserID = UserID;
txtLoginName.Text = Users[1];
txtFirstName.Text = Users[2];
txtLastName.Text = Users[3];
bool isActive = Convert.ToBoolean(Users[4]);
txtPassword.Text = CryptObj.Decrypt(Users[5]);
txtEmail.Text = Users[6];
txtPhoneNumber.Text = Users[7];
if (isActive)
{
rdoActiveYes.Checked = true;
rdoActiveNo.Checked = false;
}
else
{
rdoActiveNo.Checked = true;
rdoActiveYes.Checked = false;
}
userObj.ClinicID = UA.ClinicID;
userObj.firstName = Users[2];
int DoctorCount = userObj.CheckUserIsDoctor();
if (DoctorCount == 1)
{
rdoDoctor.Checked = true;
rdoNotDoctor.Checked = false;
}
else
{
rdoNotDoctor.Checked = true;
rdoDoctor.Checked = false;
}
btnSave.Text = "Update";
hdnUserID.Value = UserID.ToString();
txtLoginName.ReadOnly = true;
}
protected void btntokenbooking_Click(object sender, EventArgs e)
{
btnnew.Visible = true;
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
tok.DoctorID = ddlDoctorName.SelectedValue;
tok.PatientID = HiddenField1.Value;
if(tok.PatientID=="")
{
tok.PatientID = PatientObj.GetPatientID(txtName.Text, txtAddress.Text, txtMobile.Text, txtEmail.Text).ToString();
}
tok.ClinicID = UA.ClinicID.ToString();
tok.CreateDate = DateTime.Now;
tok.DateTime = DateTime.Now;
tok.CreatedBy = UA.userName;
int tokenNo = tok.InsertToken();
lblTokencount.Text = ":" + tokenNo.ToString();
lblToken.Visible = true;
divDisplayNumber.Visible = true;
}
protected void btnSave_Click(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
PatientObj.ClinicID = UA.ClinicID;
DateTime _date = DateTime.Now;
if (txtAge.Text != "")
{
int age = Convert.ToInt32(txtAge.Text);
int year = _date.Year;
int DOB = year - age;
PatientObj.DOB = DateTime.Parse(DOB + "-01-01");
}
string clinID = UA.ClinicID.ToString();
PatientObj.Name = txtName.Text;
PatientObj.Address = txtAddress.Text;
PatientObj.Phone = txtMobile.Text;
PatientObj.Email = txtEmail.Text;
if (rdoMale.Checked == true)
{
PatientObj.Gender = "Male";
}
else
{
if (rdoFemale.Checked == true)
{
PatientObj.Gender = "Female";
}
}
if (rdoSingle.Checked == true)
{
PatientObj.MaritalStatus ="Single";
}
else if (rdoMarried.Checked == true)
{
PatientObj.MaritalStatus ="Married";
}
else if (rdoDivorced.Checked == true)
{
PatientObj.MaritalStatus = "Divorced";
}
PatientObj.Occupation = "BUSINESS";
PatientObj.CreatedBy = UA.userName;
PatientObj.UpdatedBy = UA.userName;
string filenum = "F"+clinID.Substring(0,4) + txtName.Text.Substring(0, 3) + txtMobile.Text.Substring(7,3);
PatientObj.FileNumber = filenum.Trim();
if (HiddenField1.Value=="")
{
if (FileUpload1.HasFile)
{
byte[] ImageByteArray = null;
ImageByteArray = ConvertImageToByteArray(FileUpload1);
PatientObj.Picupload = ImageByteArray;
PatientObj.ImageType = Path.GetExtension(FileUpload1.PostedFile.FileName);
}
Guid g = Guid.NewGuid();
PatientObj.PatientID = g;
PatientObj.AddPatientDetails();
PatientObj.AddFile();
var page = HttpContext.Current.CurrentHandler as Page;
}
else
{
PatientObj.PatientID = Guid.Parse(HiddenField1.Value);
PatientObj.UpdatePatientDetails();
var page = HttpContext.Current.CurrentHandler as Page;
}
gridDataBind();
lblFileCount.Text = PatientObj.FileNumber;
lblFile.Text = PatientObj.FileNumber;
lblName.Text = txtName.Text;
lblAge.Text = txtAge.Text;
lblPhone.Text = txtMobile.Text;
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "openModal();", true);
}
protected void ImgBtnUpdate_Command(object sender, CommandEventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
string[] ExistingStock = e.CommandArgument.ToString().Split(new char[] { '|' });
//if (ExistingStock.Length > 0)
//{
// string UniqueID = ExistingStock[0];
// string MedicineID = ExistingStock[1];
// IssuedtlObj.UniqueID = Guid.Parse( ExistingStock[0]);
// IssuedtlObj.ClinicID = UA.ClinicID.ToString();
// IssuedtlObj.MedicineID = ExistingStock[1];
//}
//IssuedtlObj.UpdateIssueDetails();
}
