protected void btnM6Save_Click(object sender, EventArgs e)
{
try
{
#region Validate
List <TransProductSerial> lstTPS = new List <TransProductSerial>();
if (Session["StockDetailHeadQSerial"] != null)
{
lstTPS = (List <TransProductSerial>)Session["StockDetailHeadQSerial"];
if ((lstTPS != null && lstTPS.Count == 0) || lstTPS == null)
{
ShowMessageBox("Add Serial Number First. !!");
ModalPopupExtender6.Show();
return;
}
}
else
{
ShowMessageBox("Add Serial Number First. !!");
ModalPopupExtender6.Show();
return;
}
#endregion
Int32 Amt = ToInt32(txtm5Amount.Text);
AddDetailFromSession(Amt);
//BindDataDetail();
//ModalPopupExtender6.Show();
}
catch (Exception ex)
{
}
}
protected void imgbtnDeleteSN_Click(object sender, ImageClickEventArgs e)
{
try
{
ImageButton imb = (ImageButton)sender;
List <StockDetail> lst = new List <StockDetail>();
if (Session["StockDetailHeadQ"] != null && imb != null)
{
lst = (List <StockDetail>)Session["StockDetailHeadQ"];
int productID = ToInt32(hddm5Index.Value);
productID = GetProductIDSerialByPackageHeaderID(productID);
StockDetail o = lst.FirstOrDefault(w => w.ProductID.Equals(productID));
if (o != null)
{
TransProductSerial tps = o.lstSerial.FirstOrDefault(w => w.SerialNumber.Equals(imb.CommandName));
if (tps != null)
{
o.lstSerial.Remove(tps);
}
//Binding
BindGridSerial(o.lstSerial, productID);
//Save Session
Session["StockDetailHeadQ"] = lst;
}
else
{
List <TransProductSerial> lstSN = new List <TransProductSerial>();
if (Session["StockDetailHeadQSerial"] != null)
{
lstSN = (List <TransProductSerial>)Session["StockDetailHeadQSerial"];
}
lstSN.RemoveAll(w => w.ProductID.Equals(productID));
//Binding
BindGridSerial(null, productID);
}
}
else
{
ShowMessageBox("Session Timeout. !!", this, "../Index.aspx");
}
ModalPopupExtender6.Show();
}
catch (Exception ex)
{
}
}
private void AddDetailFromSession(Int32 Amt)
{
try
{
List <TransProductSerial> lstTPS = new List <TransProductSerial>();
#region Validate
//if (Session["StockDetailHeadQSerial"] != null)
//{
// lstTPS = (List<TransProductSerial>)Session["StockDetailHeadQSerial"];
// if((lstTPS != null && lstTPS.Count == 0) || lstTPS == null)
// {
// ShowMessageBox("Add Serial Number First. !!");
// ModalPopupExtender6.Show();
// return;
// }
//}
//else
//{
// ShowMessageBox("Add Serial Number First. !!");
// ModalPopupExtender6.Show();
// return;
//}
#endregion
if (Session["StockDetailHeadQProduct"] != null)
{
List <MasProduct> lstDet = (List <MasProduct>)Session["StockDetailHeadQProduct"];
if (lstDet != null && lstDet.Count > 0)
{
StockDetail s = new StockDetail();
List <StockDetail> lst = new List <StockDetail>();
if (Session["StockDetailHeadQ"] != null)
{
lst = (List <StockDetail>)Session["StockDetailHeadQ"];
}
foreach (MasProduct item in lstDet)
{
s = lst.FirstOrDefault(w => w.ProductID.Equals(item.ProductID));
if (s == null)
{
s = new StockDetail();
s.ProductID = item.ProductID;
s.ProductCode = item.ProductCode;
s.ProductName = item.ProductName;
s.ProductTypeID = item.TypeID;
s.ProductTypeName = item.TypeName;
s.Amount = item.Amount * Amt;
if (item.ProductSN.ToLower() == "y" && Session["StockDetailHeadQSerial"] != null)
{
lstTPS = (List <TransProductSerial>)Session["StockDetailHeadQSerial"];
if (lstTPS != null && lstTPS.Count > 0)
{
lstTPS = lstTPS.Where(w => w.ProductID.Equals(item.ProductID)).ToList();
if (lstTPS != null && lstTPS.Count > 0)
{
if (lstTPS.Count == Amt)
{
s.lstSerial = lstTPS;
}
else
{
ShowMessageBox("Serial Number list dose not equal with Amount. !!");
ModalPopupExtender6.Show();
return;
}
}
}
}
lst.Add(s);
}
else // Found In List
{
s.Amount = s.Amount + (item.Amount * Amt);
}
}
Session["StockDetailHeadQ"] = lst;
BindDataDetail();
}
}
else
{
}
}
catch (Exception ex)
{
}
}
protected void btnM6Add_Click(object sender, EventArgs e)
{
try
{
//Validate
if (string.IsNullOrEmpty(txtM6SN.Text))
{
ShowMessageBox("Add Serial Number First. !!!");
ModalPopupExtender6.Show();
return;
}
string strTmp = txtM6SN.Text + ",";
string[] ArrSN = strTmp.Split(',');
if (ArrSN != null && ArrSN.Length > 0)
{
Int32 cnt = ArrSN.Where(w => !string.IsNullOrEmpty(w)).Count();
//Validate
if (cnt == 0)
{
ShowMessageBox("Add Serial Number First. !!!");
ModalPopupExtender6.Show();
return;
}
ArrSN = ArrSN.Where(w => !string.IsNullOrEmpty(w)).ToArray();
Int32 PackageHeaderID = ToInt32(hddm5Index.Value);
Int32 ProductID = GetProductIDSerialByPackageHeaderID(PackageHeaderID);
Int32 Amt = ToInt32(txtm5Amount.Text);
TransProductSerial tps = new TransProductSerial();
List <TransProductSerial> lst = new List <TransProductSerial>();
List <TransProductSerial> tmp = new List <TransProductSerial>();
if (Session["StockDetailHeadQSerial"] != null)
{
lst = (List <TransProductSerial>)Session["StockDetailHeadQSerial"];
}
#region Validate
//Check Amount
if (Amt <= lst.Count(w => w.ProductID.Equals(ProductID)) || Amt < lst.Count(w => w.ProductID.Equals(ProductID)) + cnt)
{
ShowMessageBox("Serial Number Too much.");
ModalPopupExtender6.Show();
return;
}
#endregion
//Pass All Validate
foreach (string arrsn in ArrSN)
{
//Check S/N Duplicate --> Lst
tps = lst.FirstOrDefault(w => w.ProductID.Equals(ProductID) && w.SerialNumber.Trim().Equals(arrsn.Trim()));
if (tps != null)
{
ShowMessageBox("Serial Number is duplicate. --> S/N : " + arrsn);
ModalPopupExtender6.Show();
return;
}
//Check S/N Duplicate --> tmp
tps = tmp.FirstOrDefault(w => w.ProductID.Equals(ProductID) && w.SerialNumber.Trim().Equals(arrsn.Trim()));
if (tps != null)
{
ShowMessageBox("Serial Number is duplicate. --> S/N : " + arrsn);
ModalPopupExtender6.Show();
return;
}
tps = new TransProductSerial();
tps.ProductID = ProductID;
tps.SerialNumber = arrsn.Trim();
tmp.Add(tps);
}
lst.AddRange(tmp);
BindGridSerial(lst, ProductID);
//Clear Txt
txtM6SN.Text = "";
//Save Session
Session["StockDetailHeadQSerial"] = lst;
}
ModalPopupExtender6.Show();
}
catch (Exception ex)
{
}
}
protected void btnm5OK_Click(object sender, EventArgs e)
{
try
{
Int32 Amt = ToInt32(txtm5Amount.Text);
Int32 ProductID = ToInt32(hddm5Index.Value);
if (string.IsNullOrEmpty(txtm5Amount.Text) || Amt == 0)
{
ModalPopupExtender3.Show();
ModalPopupExtender5.Show();
ShowMessageBox("Input Amount First. !!");
return;
}
if (Session["StockProductHeadQList"] != null)
{
List <MasPackageHeader> lstProduct = (List <MasPackageHeader>)Session["StockProductHeadQList"];
if (lstProduct != null && lstProduct.Count > 0)
{
MasPackageHeader o = lstProduct.FirstOrDefault(w => w.PackageHeaderID.Equals(ProductID));
if (o != null)
{
//Get Package Detail
var bal = PackageDal.Instance;
Int32 pSN = 0;
List <MasProduct> lstDet = bal.GetSearchPackageDetail(o);
if (lstDet != null && lstDet.Count > 0)
{
Session["StockDetailHeadQProduct"] = lstDet;
pSN = lstDet.Count(w => w.ProductSN.ToLower().Equals("y"));
if (pSN > 0 && hddType.Value.ToLower() == "t")
{
ClearModal6();
lbM6Header.Text = o.PackageName + " (" + Amt.ToString() + ")";
//hddM6ProductID.Value = hddm5Index.Value;
ModalPopupExtender6.Show();
}
else
{
AddDetailFromSession(Amt);
}
}
else
{
Session["StockDetailHeadQProduct"] = null;
ShowMessageBox("Detail Not found. !!");
}
}
}
}
else
{
ShowMessageBox("Session Timeout. !!", this, "../Index.aspx");
}
}
catch (Exception ex)
{
}
}
protected void executeQuery(object sender, EventArgs e)
{
//try
//{
Database db;
DataTable dt;
Label title = new Label();
if (connectionSelector.SelectedItem.Text == "local")
{
try
{
db = new Database();
dt = db.executeQueryLocal(queryString.Text);
}
catch (ODBC2KMLException ex)
{
ErrorHandler eh = new ErrorHandler(ex.errorText, errorPanel1);
eh.displayError();
return;
}
}
else
{
ConnInfo info = new ConnInfo();
try
{
db = new Database();
string query = "SELECT * FROM Connection WHERE ID=" + connectionSelector.SelectedItem.Value;
dt = db.executeQueryLocal(query);
if (dt.HasErrors)
{
throw new ODBC2KMLException("Unknown Database error");
}
}
catch (ODBC2KMLException ex)
{
ErrorHandler eh = new ErrorHandler(ex.errorText, errorPanel1);
eh.displayError();
return;
}
try
{
info = ConnInfo.getConnInfo(int.Parse(connectionSelector.SelectedItem.Value));
}
catch (ODBC2KMLException ex)
{
ErrorHandler eh = new ErrorHandler(ex.errorText, errorPanel1);
eh.displayError();
return;
}
db.setConnInfo(info);
try
{
dt = db.executeQueryRemote(queryString.Text);
}
catch (ODBC2KMLException ex)
{
ErrorHandler eh = new ErrorHandler(ex.errorText, errorPanel1);
eh.displayError();
return;
}
}
resultsPanel.Visible = true;
resultsPanel.Controls.Add(new LiteralControl("<span class=\"connectionStyle\"> Database Query Results</span>"));
resultsPanel.Controls.Add(new LiteralControl("<div class=\"mainBoxP\">"));
resultsPanel.Controls.Add(new LiteralControl("<table cellpadding=\"5\" cellspacing=\"0\" class=\"mainBox2\">"));
resultsPanel.Controls.Add(new LiteralControl("<tr><td>"));
resultsPanel.Controls.Add(new LiteralControl("<div class=\"omainBox4\">"));
resultsPanel.Controls.Add(new LiteralControl("<table class=\"omainBox5\" cellspacing=\"0\" cellpadding=\"0\">"));
resultsPanel.Controls.Add(new LiteralControl("<tr>"));
foreach (DataColumn dc in dt.Columns)
{
resultsPanel.Controls.Add(new LiteralControl("<td><b>" + dc.ColumnName + "<br/></b></td>"));
}
resultsPanel.Controls.Add(new LiteralControl("</tr><tr><td><br/></td></tr>"));
foreach (DataRow dr in dt.Rows)
{
resultsPanel.Controls.Add(new LiteralControl("<tr>"));
foreach (Object data in dr.ItemArray)
{
resultsPanel.Controls.Add(new LiteralControl("<td>" + data.ToString() + "</td>"));
}
resultsPanel.Controls.Add(new LiteralControl("</tr>"));
}
resultsPanel.Controls.Add(new LiteralControl("</table>"));
resultsPanel.Controls.Add(new LiteralControl("<div align=\"right\" style=\"padding-top: 20px;\">"));
resultsPanel.Controls.Add(new LiteralControl("<input type=\"submit\" ID=\"hideResults\" value=\"Hide Results\" class=\"button\" />"));
resultsPanel.Controls.Add(new LiteralControl("</div>"));
resultsPanel.Controls.Add(new LiteralControl("</td></tr>"));
resultsPanel.Controls.Add(new LiteralControl("</div>"));
resultsPanel.Controls.Add(new LiteralControl("</span>"));
ModalPopupExtender6.Show();
//}
/*catch(Exception exception)
* {
* errorPanel1.Visible = true;
* errorPanel1.Controls.Add(new LiteralControl("<div style=\"color: black\"><p>"+exception.Message+"</p></div>"));
* errorPanel1.Controls.Add(new LiteralControl("<script type=\"text/javascript\">$(\"#errorPanel1\").dialog('open')</script>"));
* }*/
}
protected void btnM6Add_Click(object sender, EventArgs e)
{
try
{
//Validate
if (string.IsNullOrEmpty(txtM6SN.Text))
{
ShowMessageBox("Add Serial Number First. !!!");
return;
}
Int32 Amt = ToInt32(txtm5Amount.Text);
int productID = ToInt32(hddM6ProductID.Value);
List <StockDetail> lst = new List <StockDetail>();
List <TransProductSerial> lstTPS = new List <TransProductSerial>();
TransProductSerial tps = new TransProductSerial();
if (Session["StockDetail"] != null)
{
lst = (List <StockDetail>)Session["StockDetail"];
StockDetail o = lst.FirstOrDefault(w => w.ProductID.Equals(productID));
if (o != null)
{
if (o.lstSerial == null)
{
o.lstSerial = new List <TransProductSerial>();
}
else
{
if (o.Amount <= o.lstSerial.Count)
{
ShowMessageBox("Serial Number Too much.");
ModalPopupExtender6.Show();
return;
}
}
//Check S/N Duplicate
tps = o.lstSerial.FirstOrDefault(w => w.SerialNumber.Trim().Equals(txtM6SN.Text.Trim()));
if (tps != null)
{
ShowMessageBox("Serial Number is duplicate.");
ModalPopupExtender6.Show();
return;
}
tps = new TransProductSerial();
tps.ProductID = productID;
tps.SerialNumber = txtM6SN.Text.Trim();
o.lstSerial.Add(tps);
//Binding
BindGridSerial(o.lstSerial);
}
else
{
if (Session["StockProductList"] != null)
{
List <MasProduct> lstProduct = (List <MasProduct>)Session["StockProductList"];
if (lstProduct != null && lstProduct.Count > 0)
{
MasProduct pd = lstProduct.FirstOrDefault(w => w.ProductID.Equals(productID));
if (pd != null)
{
lstTPS = new List <TransProductSerial>();
tps = new TransProductSerial();
tps.ProductID = productID;
tps.SerialNumber = txtM6SN.Text.Trim();
lstTPS.Add(tps);
lst.Add(new StockDetail()
{
ProductID = productID,
ProductCode = pd.ProductCode,
ProductName = pd.ProductName,
ProductTypeID = pd.TypeID,
ProductTypeName = pd.TypeName,
Amount = Amt,
lstSerial = lstTPS,
});
//Binding
BindGridSerial(lstTPS);
}
}
}
}
}
else
{
if (Session["StockProductList"] != null)
{
List <MasProduct> lstProduct = (List <MasProduct>)Session["StockProductList"];
if (lstProduct != null && lstProduct.Count > 0)
{
MasProduct pd = lstProduct.FirstOrDefault(w => w.ProductID.Equals(productID));
if (pd != null)
{
lstTPS = new List <TransProductSerial>();
tps = new TransProductSerial();
tps.ProductID = productID;
tps.SerialNumber = txtM6SN.Text.Trim();
lstTPS.Add(tps);
//Binding
BindGridSerial(lstTPS);
lst.Add(new StockDetail()
{
ProductID = productID,
ProductCode = pd.ProductCode,
ProductName = pd.ProductName,
ProductTypeID = pd.TypeID,
ProductTypeName = pd.TypeName,
Amount = Amt,
lstSerial = lstTPS,
});
}
}
}
}
//Clear Txt
txtM6SN.Text = "";
//Save Session
Session["StockDetail"] = lst;
ModalPopupExtender6.Show();
}
catch (Exception ex)
{
}
}
protected void btnm5OK_Click(object sender, EventArgs e)
{
try
{
Int32 Amt = ToInt32(txtm5Amount.Text);
Int32 ProductID = ToInt32(hddm5Index.Value);
if (Session["StockProductList"] != null)
{
List <MasProduct> lstProduct = (List <MasProduct>)Session["StockProductList"];
if (lstProduct != null && lstProduct.Count > 0)
{
MasProduct o = lstProduct.FirstOrDefault(w => w.ProductID.Equals(ProductID));
if (o != null)
{
if (o.ProductSN == "Y")
{
List <StockDetail> lst = new List <StockDetail>();
if (Session["StockDetail"] != null)
{
lst = (List <StockDetail>)Session["StockDetail"];
}
StockDetail s = lst.FirstOrDefault(w => w.ProductID.Equals(ProductID));
if (s != null)
{
s.lstSerial = new List <TransProductSerial>();
s.Amount = Amt;
}
ClearModal6();
lbM6Header.Text = o.ProductName + " (" + Amt.ToString() + ")";
hddM6ProductID.Value = hddm5Index.Value;
ModalPopupExtender6.Show();
}
else
{
List <StockDetail> lst = new List <StockDetail>();
if (Session["StockDetail"] != null)
{
lst = (List <StockDetail>)Session["StockDetail"];
}
StockDetail s = lst.FirstOrDefault(w => w.ProductID.Equals(ProductID));
if (s == null)
{
lst.Add(new StockDetail()
{
ProductID = ProductID,
ProductCode = o.ProductCode,
ProductName = o.ProductName,
ProductTypeID = o.TypeID,
ProductTypeName = o.TypeName,
Amount = Amt,
});
}
else // Found In List
{
s.Amount = s.Amount + Amt;
}
Session["StockDetail"] = lst;
BindDataDetail();
}
}
}
}
else
{
ShowMessageBox("Session Timeout. !!", this, "../Index.aspx");
}
#region Comment
//List<StockDetail> lst = new List<StockDetail>();
//if(Session["StockDetail"] != null)
// lst = (List<StockDetail>)Session["StockDetail"];
//if(Session["StockProductList"] != null)
//{
// List<MasProduct> lstProduct = (List<MasProduct>)Session["StockProductList"];
// if(lstProduct != null && lstProduct.Count > 0)
// {
// MasProduct o = lstProduct.FirstOrDefault(w => w.ProductID.Equals(ProductID));
// if(o != null)
// {
// StockDetail s = lst.FirstOrDefault(w => w.ProductID.Equals(ProductID));
// if(s == null)
// {
// lst.Add(new StockDetail()
// {
// ProductID = ProductID,
// ProductCode = o.ProductCode,
// ProductName = o.ProductName,
// ProductTypeID = o.TypeID,
// ProductTypeName = o.TypeName,
// Amount = Amt,
// });
// }
// else // Found In List
// {
// s.Amount = s.Amount + Amt;
// }
// Session["StockDetail"] = lst;
// BindDataDetail();
// }
// }
//}
//else
//{
// //ShowMessageBox("Session Timeout. !!", this, "../Index.aspx");
//}
#endregion
}
catch (Exception ex)
{
}
}
