protected void btnAddPromotion_Click(object sender, EventArgs e)
{
if (ViewState["PromotionId"] != null)
{
var cmd = new ProductPromotionService();
PRODUCT_PROMOTION item = new PRODUCT_PROMOTION();
item.PROMOTION_ID = Convert.ToInt32(ViewState["PromotionId"].ToString());
item.PRODUCT_CONDITION_QTY = Convert.ToInt32(txtQty.Text);
item.PRODUCT_FREE_QTY = Convert.ToInt32(txtFreeQty.Text);
item.ZONE_ID = Convert.ToInt32(ddlZonePromotion.SelectedValue);
item.UPDATE_DATE = DateTime.Now;
item.UPDATE_EMPLOYEE_ID = 0;
cmd.Edit(item);
}
else
{
var cmdZonePromotion = new ZoneService();
PRODUCT_PROMOTION item = new PRODUCT_PROMOTION();
item.Action = ActionEnum.Create;
item.PRODUCT_CONDITION_QTY = Convert.ToInt32(txtQty.Text);
item.PRODUCT_FREE_QTY = Convert.ToInt32(txtFreeQty.Text);
item.ZONE_ID = Convert.ToInt32(ddlZonePromotion.SelectedValue);
item.CREATE_DATE = DateTime.Now;
item.CREATE_EMPLOYEE_ID = 0;
item.UPDATE_DATE = DateTime.Now;
item.UPDATE_EMPLOYEE_ID = 0;
item.SYE_DEL = true;
listPromotion.Add(item);
}
InitialDataPopup();
this.popup.Show();
}
private void InitialDataPopupPromotion()
{
var cmdCat = new ZoneService();
var list = cmdCat.GetALL();
ddlZonePromotion.Items.Clear();
foreach (var item in list)
{
ddlZonePromotion.Items.Add(new ListItem(item.ZONE_NAME, item.ZONE_ID.ToString()));
}
if (ViewState["PromotionId"] != null)
{
flag2.Text = "Edit";
var cmdPro = new ProductPromotionService();
PRODUCT_PROMOTION promotion = cmdPro.Select(Convert.ToInt32(ViewState["PromotionId"].ToString()));
txtQty.Text = promotion.PRODUCT_CONDITION_QTY.ToString();
txtFreeQty.Text = promotion.PRODUCT_FREE_QTY.ToString();
ddlZonePromotion.SelectedValue = promotion.ZONE_ID.ToString();
}
else
{
txtQty.Text = "";
txtFreeQty.Text = "";
flag2.Text = "Add";
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
var obj = new PRODUCT();
obj.PRODUCT_CODE = popTxtProductCode.Text;
obj.PRODUCT_NAME = poptxtProductName.Text;
obj.PRODUCT_PACKING_QTY = Convert.ToInt32(txtPacking.Text);
if (ddlPakUDesc.SelectedValue != "กรุณาเลือก")
obj.PRODUCT_PACKING_PER_UDESC = ddlPakUDesc.SelectedValue;
if (ddlPakPDesc.SelectedValue != "กรุณาเลือก")
obj.PRODUCT_PACKING_PER_PDESC = ddlPakPDesc.SelectedValue;
obj.PRODUCT_PACKING_DESC = "(" + obj.PRODUCT_PACKING_QTY + " " + obj.PRODUCT_PACKING_PER_UDESC + "/" + obj.PRODUCT_PACKING_PER_PDESC + ")";
obj.PRODUCT_WEIGHT = Convert.ToDecimal(txtWeight.Text);
obj.PRODUCT_WEIGHT_DEFINE = txtUnit.Text;
obj.CATEGORY_ID = Convert.ToInt32(ddlCategory.SelectedValue);
obj.PRODUCT_TYPE_CODE = Convert.ToInt32(ddlkind.SelectedValue);
var cmd = new ProductService(obj);
if (flag.Text.Equals("Add"))
{
obj.Action = ActionEnum.Create;
obj.CREATE_DATE = DateTime.Now;
obj.CREATE_EMPLOYEE_ID = 0;
obj.UPDATE_DATE = DateTime.Now;
obj.UPDATE_EMPLOYEE_ID = 0;
obj.SYE_DEL = true;
cmd.Add();
}
else
{
obj.Action = ActionEnum.Update;
obj.PRODUCT_ID = Convert.ToInt32(ViewState["proId"].ToString());
obj.UPDATE_DATE = DateTime.Now;
obj.UPDATE_EMPLOYEE_ID = 0;
obj.SYE_DEL = true;
cmd.Edit();
}
if (FileUpload1.HasFile)
{
Stream fs = FileUpload1.PostedFile.InputStream;
if (!System.IO.Directory.Exists(HttpContext.Current.Server.MapPath("~") + "ImageProduct"))
System.IO.Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~") + "ImageProduct");
obj.PRODUCT_IMAGE_PATH = "~/ImageProduct/" + obj.PRODUCT_ID + "." + FileUpload1.FileName.Split('.').ToArray()[1];
FileUpload1.PostedFile.SaveAs(HttpContext.Current.Server.MapPath("~") + "ImageProduct\\" + obj.PRODUCT_ID + "." + FileUpload1.FileName.Split('.').ToArray()[1]);
}
cmd = new ProductService(obj);
cmd.Edit();
var listDetail = new List<PRODUCT_PRICELIST>();
int i = 0;
foreach (var item in DataSouceList)
{
var objDetail = new PRODUCT_PRICELIST();
objDetail.ZONE_ID = item.ZONE_ID;
objDetail.PRODUCT_PRICE = Convert.ToDecimal(((TextBox)(gridProductDetail.Rows[i++].Cells[2].FindControl("txtPrice"))).Text);
objDetail.SYE_DEL = true;
objDetail.UPDATE_DATE = DateTime.Now;
objDetail.UPDATE_EMPLOYEE_ID = 0;
if (item.PRODUCT_ID == 0)
{
objDetail.Action = ActionEnum.Create;
objDetail.PRODUCT_ID = obj.PRODUCT_ID;
objDetail.CREATE_DATE = DateTime.Now;
objDetail.CREATE_EMPLOYEE_ID = 0;
}
else
{
objDetail.Action = ActionEnum.Update;
objDetail.PRODUCT_ID = item.PRODUCT_ID;
}
listDetail.Add(objDetail);
}
if (listPromotion.Count > 0)
{
foreach (PRODUCT_PROMOTION item in listPromotion)
{
item.PRODUCT_ID = obj.PRODUCT_ID;
}
var cmdPromotion = new ProductPromotionService(listPromotion);
cmdPromotion.AddList();
}
var cmdDetail = new ProductPriceListService(listDetail);
cmdDetail.AddUpdateList();
ViewState["proId"] = null;
Response.Redirect("SearchProduct.aspx");
}
private void InitialDataPopup()
{
var cmdCat = new CategoryService();
var list = cmdCat.GetALL();
foreach (var item in list)
{
ddlCategory.Items.Add(new ListItem(item.CATEGORY_NAME, item.CATEGORY_ID.ToString()));
}
var cmdPro = new ProductService();
var listddlPakUDesc = cmdPro.GetUDescPacking();
foreach (var item in listddlPakUDesc)
{
ddlPakUDesc.Items.Add(new ListItem(item, item));
}
var listddlPakPDesc = cmdPro.GetPDescPacking();
foreach (var item in listddlPakPDesc)
{
ddlPakPDesc.Items.Add(new ListItem(item, item));
}
var cmd = new ZoneService();
var listZone = cmd.GetALL();
DataSouceList = new List<PRODUCT_PRICELIST>();
foreach (var item in listZone)
{
PRODUCT_PRICELIST pd = new PRODUCT_PRICELIST();
pd.ZONE_ID = item.ZONE_ID;
pd.ZONE = new ZONE();
pd.ZONE.ZONE_CODE = item.ZONE_CODE;
pd.ZONE.ZONE_NAME = item.ZONE_NAME;
DataSouceList.Add(pd);
}
if (ViewState["proId"] != null)
{
_product = cmdPro.Select(Convert.ToInt32(ViewState["proId"].ToString()));
popTxtProductCode.Text = _product.PRODUCT_CODE;
poptxtProductName.Text = _product.PRODUCT_NAME;
txtPacking.Text = _product.PRODUCT_PACKING_QTY.ToString();
//txtPackingDesc.Text = _product.PRODUCT_PACKING_DESC;
txtWeight.Text = _product.PRODUCT_WEIGHT.ToString();
txtUnit.Text = _product.PRODUCT_WEIGHT_DEFINE;
ddlCategory.SelectedValue = _product.CATEGORY_ID.ToString();
ddlkind.SelectedValue = _product.PRODUCT_TYPE_CODE.ToString();
//txtSize.Text = _product.PRODUCT_SIZE;
ddlPakUDesc.SelectedValue = _product.PRODUCT_PACKING_PER_UDESC;
ddlPakPDesc.SelectedValue = _product.PRODUCT_PACKING_PER_PDESC;
var cmdPD = new ProductPriceListService();
var listPD = cmdPD.Select(Convert.ToInt32(ViewState["proId"].ToString()));
foreach (var itemPD in listPD)
{
foreach (var itemDST in DataSouceList)
{
if (itemDST.ZONE_ID == itemPD.ZONE_ID)
{
itemDST.PRODUCT_PRICE = itemPD.PRODUCT_PRICE;
itemDST.PRODUCT_ID = itemPD.PRODUCT_ID;
break;
}
}
}
List<PRODUCT_PROMOTION> listPromotionItem = new List<PRODUCT_PROMOTION>();
var cmdPromotion = new ProductPromotionService();
DataSoucePromotion = cmdPromotion.GetALLIncludeZone(Convert.ToInt32(ViewState["proId"].ToString()));
listPromotionItem.AddRange(DataSoucePromotion);
listPromotionItem.AddRange(listPromotion);
gridPromotion.DataSource = listPromotionItem;
gridPromotion.DataBind();
flag.Text = "Edit";
}
gridProductDetail.DataSource = DataSouceList;
gridProductDetail.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ORDER_DETAIL obj = new ORDER_DETAIL();
obj.PRODUCT_ID = _product.PRODUCT_ID;
obj.PRODUCT_PRICE = Convert.ToDecimal(this.lblPriceProduct.Text);
obj.PRODUCT_QTY = Convert.ToInt32(this.txtQty.Text);
obj.PRODUCT_TOTAL = Convert.ToDecimal(this.lblPriceProduct.Text) * Convert.ToDecimal(this.txtQty.Text);
obj.PRODUCT_SEND_QTY = 0;
obj.CREATE_DATE = DateTime.Now;
obj.CREATE_EMPLOYEE_ID = 0;
obj.UPDATE_DATE = DateTime.Now;
obj.UPDATE_EMPLOYEE_ID = 0;
obj.SYE_DEL = true;
obj.IS_FREE = false;
lstOrderDetail.Add(obj);
int zoneID = _store.ZONE_ID.Value;
int productFree = 0;
int proQty = obj.PRODUCT_QTY.Value;
var cmd = new ProductPromotionService();
PRODUCT_PROMOTION cond = cmd.SelectByProductZone(obj.PRODUCT_ID, zoneID);
if (cond != null)
{
for (productFree = 0; (proQty - cond.PRODUCT_CONDITION_QTY) >= 0; productFree += cond.PRODUCT_FREE_QTY.Value)
{
proQty -= cond.PRODUCT_CONDITION_QTY.Value;
}
if (productFree != 0)
{
ORDER_DETAIL objFree = new ORDER_DETAIL();
objFree.PRODUCT_ID = _product.PRODUCT_ID;
objFree.PRODUCT_PRICE = 0;
objFree.PRODUCT_QTY = productFree;
objFree.PRODUCT_TOTAL = 0;
objFree.PRODUCT_SEND_QTY = 0;
objFree.CREATE_DATE = DateTime.Now;
objFree.CREATE_EMPLOYEE_ID = 0;
objFree.UPDATE_DATE = DateTime.Now;
objFree.UPDATE_EMPLOYEE_ID = 0;
objFree.SYE_DEL = true;
objFree.IS_FREE = true;
lstOrderDetail.Add(objFree);
}
}
Response.Redirect("OrderProduct.aspx");
}