public static string GetQtyInStock(string MedName)
{
IssueDetails dtlsObj = new IssueDetails();
string qty = dtlsObj.GetQtyInStock(MedName);
return qty;
}
/// <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();
}
