protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var dal = PackageDal.Instance;
List <MasProduct> lst = new List <MasProduct>();
string PackageCode = Request.QueryString.Get("PackageCode");
if (PackageCode != null)
{
Int32 PackageHeaderId = ToInt32(PackageCode);
MasPackageHeader Modeldata = dal.GetSearchMasPackageHeaderByID(PackageHeaderId);
txtPackageCode.Text = Modeldata.PackageCode;
txtPackageName.Text = Modeldata.PackageName;
txtPackageSellPrice.Text = Convert.ToDouble(Modeldata.SellPrice).ToString("#,###0.00");
hddID.Value = Modeldata.PackageHeaderID.ToString();
hddHeaderMode.Value = "Edit";
Modeldata = new MasPackageHeader();
Modeldata.PackageHeaderID = Convert.ToInt32(hddID.Value);
lst = dal.GetSearchPackageDetail(Modeldata);
}
Session["DetailProdcut"] = lst;
BindDataGrid();
}
}
protected void imgbtnDelete_Click(object sender, ImageClickEventArgs e)
{
try
{
var dal = PackageDal.Instance;
ImageButton imb = (ImageButton)sender;
MasPackageHeader DataHeader = new MasPackageHeader();
if (imb != null)
{
Int32 obj = ToInt32(imb.CommandArgument);
DataHeader.DMLFlag = "D";
DataHeader.PackageHeaderID = obj;
DataHeader.CreatedBy = GetUsername();
dal.InsUpdDelMasPackageHeader(DataHeader);
BindData();
}
else
{
SendMailError("imb is null", System.Reflection.MethodBase.GetCurrentMethod());
}
}
catch (Exception ex)
{
ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ.");
SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod());
}
}
private Int32 GetProductIDSerialByPackageHeaderID(Int32 PackageHeaderID)
{
Int32 result = 0;
try
{
#region Get Product ID
MasPackageHeader mph = new MasPackageHeader()
{
PackageHeaderID = PackageHeaderID
};
var bal = PackageDal.Instance;
List <MasProduct> lstProduct = bal.GetSearchPackageDetail(mph);
if (lstProduct != null && lstProduct.Count > 0)
{
MasProduct mp = lstProduct.FirstOrDefault(w => w.ProductSN.ToLower().Equals("y"));
if (mp != null)
{
result = mp.ProductID;
}
}
#endregion
}
catch (Exception ex)
{
}
return(result);
}
public List <MasPackageHeader> GetPackageAll()
{
List <MasPackageHeader> lst = new List <MasPackageHeader>();
try
{
List <SqlParameter> param = new List <SqlParameter>();
//DataSet ds = conn.GetDataSet("GetSearchItemInStock", param);
DataSet ds = conn.GetDataSet("GetSearchPackage", param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
MasPackageHeader o = new MasPackageHeader();
foreach (DataRow dr in ds.Tables[0].Rows)
{
o = new MasPackageHeader();
//o.StockID = Convert.ToInt32(dr["StockID"].ToString());
o.PackageHeaderID = Convert.ToInt32(dr["PackageHeaderID"].ToString());
o.PackageCode = dr["PackageCode"].ToString();
o.PackageName = dr["PackageName"].ToString();
o.SellPrice = Convert.ToDouble(dr["SellPrice"].ToString());
//o.UnitName = dr["UnitName"].ToString();
lst.Add(o);
}
}
}
catch (Exception ex)
{
}
return(lst);
}
protected void BindData()
{
var dal = PackageDal.Instance;
try
{
List <MasPackageHeader> lst = new List <MasPackageHeader>();
MasPackageHeader ModelSer = new MasPackageHeader();
ModelSer.PackageCode = txtCode.Text;
ModelSer.PackageName = txtName.Text;
lst = dal.GetSearchPackageHeader(ModelSer);
if (lst != null && lst.Count > 0)
{
gv.DataSource = lst;
}
else
{
gv.DataSource = null;
}
gv.DataBind();
}
catch (Exception ex)
{
SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
var dal = PackageDal.Instance;
try
{
if (txtPackageCode.Text == "")
{
ShowMessageBox("กรุณาระบุ รหัส Packag !!!");
return;
}
if (txtPackageName.Text == "")
{
ShowMessageBox("กรุณาระบุ ชื่อ Package !!!");
return;
}
if (txtPackageSellPrice.Text == "")
{
ShowMessageBox("กรุณาระบุ ราคาขาย !!!");
return;
}
MasPackageHeader DataHeader = new MasPackageHeader();
if (hddHeaderMode.Value == "Edit")
{
DataHeader.PackageHeaderID = Convert.ToInt32(hddID.Value);
}
DataHeader.PackageCode = txtPackageCode.Text;
DataHeader.PackageName = txtPackageName.Text;
DataHeader.SellPrice = Convert.ToDouble(txtPackageSellPrice.Text);
DataHeader.DMLFlag = hddHeaderMode.Value != "Edit" ? "I" : "U";
DataHeader.Active = "Y";
DataHeader.CreatedBy = GetUsername();
string ResultHearder = dal.InsUpdDelMasPackageHeader(DataHeader);
List <MasProduct> lst = (List <MasProduct>)Session["DetailProdcut"];
if (ResultHearder == "")
{
dal.InsUpdDelMasPackageDetail(lst, DataHeader.PackageHeaderID, "D");
string ResultDetail = dal.InsUpdDelMasPackageDetail(lst, DataHeader.PackageHeaderID);
if (ResultDetail == "")
{
ShowMessageBox("บันทึกข้อมูลสำเร็จ.", this.Page, "MasterPackageList.aspx");
}
else
{
ShowMessageBox(ResultDetail);
}
}
}
catch (Exception ex)
{
ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ.");
SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod());
}
}
public List <MasProduct> GetSearchPackageDetail(MasPackageHeader ModelSer)
{
MasProduct item = new MasProduct();
List <MasProduct> lstData = new List <MasProduct>();
try
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "PackageHeaderID", Value = ModelSer.PackageHeaderID, DbType = DbType.String
});
DataSet ds = conn.GetDataSet("GetSearchPackageDetail", param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
item = new MasProduct();
item.ProductID = string.IsNullOrEmpty(dr["ProductID"].ToString()) ? 0 : Convert.ToInt32(dr["ProductID"].ToString());
item.ProductCode = dr["ProductCode"].ToString();
item.ProductName = dr["ProductName"].ToString();
item.Amount = string.IsNullOrEmpty(dr["Amount"].ToString()) ? 0 : Convert.ToInt32(dr["Amount"].ToString());
item.Active = dr["Active"].ToString();
item.SellPrice = string.IsNullOrEmpty(dr["SellPrice"].ToString()) ? 0 : Convert.ToDouble(dr["SellPrice"].ToString());
item.CreatedBy = dr["CreatedBy"].ToString();
item.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString());
item.UpdatedBy = dr["UpdatedBy"].ToString();
item.UpdatedDate = Convert.ToDateTime(dr["UpdatedDate"].ToString());
item.CanChange = dr["CanChange"].ToString() == "Y" ? "Change" : "Fix";
item.DMLFlag = "I";
item.ProductSN = dr["ProductSN"].ToString();
item.IsFree = dr["IsFree"].ToString();
item.PackageDetailID = string.IsNullOrEmpty(dr["PackageDetailID"].ToString()) ? 0 : Convert.ToInt32(dr["PackageDetailID"].ToString());
lstData.Add(item);
}
}
}
catch (Exception ex)
{
}
return(lstData);
}
public string InsUpdDelMasPackageHeader(MasPackageHeader item)
{
string err = "";
try
{
List <SqlParameter> paramI = new List <SqlParameter>();
paramI.Add(new SqlParameter()
{
ParameterName = "PackageHeaderID", Value = item.PackageHeaderID
});
paramI.Add(new SqlParameter()
{
ParameterName = "PackageCode", Value = item.PackageCode
});
paramI.Add(new SqlParameter()
{
ParameterName = "PackageName", Value = item.PackageName
});
paramI.Add(new SqlParameter()
{
ParameterName = "SellPrice", Value = item.SellPrice, DbType = DbType.Double
});
paramI.Add(new SqlParameter()
{
ParameterName = "Active", Value = item.Active, DbType = DbType.String
});
paramI.Add(new SqlParameter()
{
ParameterName = "CreatedBy", Value = item.CreatedBy, DbType = DbType.String
});
paramI.Add(new SqlParameter()
{
ParameterName = "DMLFlag", Value = item.DMLFlag
});
conn.ExcuteNonQueryNClose("InsUpdDelMasPackageHeader", paramI, out err);
}
catch (Exception ex)
{
err = ex.Message;
}
return(err);
}
public List <MasPackageHeader> GetSearchPackageHeader(MasPackageHeader ModelSer)
{
MasPackageHeader item = new MasPackageHeader();
List <MasPackageHeader> lstData = new List <MasPackageHeader>();
try
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "PackageCode", Value = ModelSer.PackageCode, DbType = DbType.String
});
param.Add(new SqlParameter()
{
ParameterName = "PackageName", Value = ModelSer.PackageName, DbType = DbType.String
});
DataSet ds = conn.GetDataSet("GetSearchPackageHeader", param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
item = new MasPackageHeader();
item.PackageHeaderID = Convert.ToInt32(dr["PackageHeaderID"].ToString());
item.PackageCode = dr["PackageCode"].ToString();
item.PackageName = dr["PackageName"].ToString();
item.Active = dr["Active"].ToString();
item.SellPrice = string.IsNullOrEmpty(dr["SellPrice"].ToString()) ? 0 : Convert.ToDouble(dr["SellPrice"].ToString());
item.Remaining = string.IsNullOrEmpty(dr["Remaining"].ToString()) ? 0 : Convert.ToInt32(dr["Remaining"].ToString());
//item.CreatedBy = dr["CreatedBy"].ToString();
//item.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString());
//item.UpdatedBy = dr["UpdatedBy"].ToString();
//item.UpdatedDate = Convert.ToDateTime(dr["UpdatedDate"].ToString());
lstData.Add(item);
}
}
}
catch (Exception ex)
{
}
return(lstData);
}
protected void SearchItem()
{
try
{
string ProductCode = txtSearchItemCode.Text.ToLower();
string ProductName = txtSearchItemName.Text.ToLower();
MasPackageHeader o = new MasPackageHeader()
{
PackageCode = ProductCode, PackageName = ProductName
};
List <MasPackageHeader> lst = new List <MasPackageHeader>();
var dal = PackageDal.Instance; // ItemDal.Instance;
lst = dal.GetSearchPackageHeader(o);
if (lst != null)
{
//if (!string.IsNullOrEmpty(ProductCode))
// lst = lst.Where(w => w.ProductCode.ToLower().Contains(ProductCode)).ToList();
//if (!string.IsNullOrEmpty(ProductName))
//{
// lst = lst.Where(w => w.ProductName.ToLower().Contains(ProductName)).ToList();
//}
lst = lst.OrderBy(od => od.PackageName).ToList();
Session["StockProductHeadQList"] = lst;
gvItemSearch.DataSource = lst;
gvItemSearch.DataBind();
}
else
{
gvItemSearch.DataSource = null;
gvItemSearch.DataBind();
}
}
catch (Exception ex)
{
gvItemSearch.DataSource = null;
gvItemSearch.DataBind();
}
}
public MasPackageHeader GetSearchMasPackageHeaderByID(Int32 PackageHeaderID)
{
MasPackageHeader item = new MasPackageHeader();
try
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "PackageHeaderID", Value = PackageHeaderID, DbType = DbType.Int32
});
DataSet ds = conn.GetDataSet("GetMasPackageHeaderByID", param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
item.PackageHeaderID = Convert.ToInt32(dr["PackageHeaderID"].ToString());
item.PackageCode = dr["PackageCode"].ToString();
item.PackageName = dr["PackageName"].ToString();
item.Active = dr["Active"].ToString();
item.PurchasePrice = !dr.IsNull("PurchasePrice") ? Convert.ToDouble(dr["PurchasePrice"].ToString()) : 0;
item.SellPrice = Convert.ToDouble(dr["SellPrice"].ToString());
item.CreatedBy = dr["CreatedBy"].ToString();
item.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString());
item.UpdatedBy = dr["UpdatedBy"].ToString();
item.UpdatedDate = Convert.ToDateTime(dr["UpdatedDate"].ToString());
item.DMLFlag = "U";
break;
}
}
}
catch (Exception ex)
{
}
return(item);
}
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)
{
}
}
public string InsUpdDelMasPackageDetail(List <MasProduct> item, Int32 PackageID, string Model = "I")
{
string err = "";
try
{
MasPackageHeader DataMasPackageHeader = GetSearchMasPackageHeaderByID(PackageID);
if (Model == "D")
{
List <SqlParameter> paramI = new List <SqlParameter>();
paramI.Add(new SqlParameter()
{
ParameterName = "PackageHeaderID", Value = DataMasPackageHeader.PackageHeaderID
});
paramI.Add(new SqlParameter()
{
ParameterName = "DMLFlag", Value = Model
});
conn.ExcuteNonQueryNClose("InsUpdDelMasPackageDetail", paramI, out err);
return(err);
}
int rowOrder = 1;
foreach (MasProduct Data in item)
{
List <SqlParameter> paramI = new List <SqlParameter>();
paramI.Add(new SqlParameter()
{
ParameterName = "PackageHeaderID", Value = DataMasPackageHeader.PackageHeaderID
});
paramI.Add(new SqlParameter()
{
ParameterName = "ProductID", Value = Data.ProductID
});
paramI.Add(new SqlParameter()
{
ParameterName = "Amount", Value = Data.Amount, DbType = DbType.Int32
});
paramI.Add(new SqlParameter()
{
ParameterName = "OrderNo", Value = rowOrder, DbType = DbType.Int32
});
paramI.Add(new SqlParameter()
{
ParameterName = "Active", Value = Data.Active, DbType = DbType.String
});
paramI.Add(new SqlParameter()
{
ParameterName = "CreatedBy", Value = Data.CreatedBy, DbType = DbType.String
});
paramI.Add(new SqlParameter()
{
ParameterName = "DMLFlag", Value = Data.DMLFlag
});
paramI.Add(new SqlParameter()
{
ParameterName = "CanChange", Value = Data.CanChange == "Change" ? "Y" : "N"
});
paramI.Add(new SqlParameter()
{
ParameterName = "IsFree", Value = Data.IsFree
});
conn.ExcuteNonQueryNClose("InsUpdDelMasPackageDetail", paramI, out err);
rowOrder++;
}
}
catch (Exception ex)
{
err = ex.Message;
}
return(err);
}
