protected void btnSave_Click(object sender, EventArgs e)
{
var obj = new STORE();
obj.PROVINCE_ID = Convert.ToInt32(ddlProvince.SelectedValue);
obj.SECTOR_ID = Convert.ToInt32(ddlSector.SelectedValue);
obj.ROAD_ID = Convert.ToInt32(ddlRoad.SelectedValue);
obj.STORE_ADDR1 = txtAddress.Text;
obj.STORE_CODE = popTxtStoreCode.Text;
obj.STORE_DISTRICT = txtAmpur.Text;
obj.STORE_FAX = txtFax.Text;
obj.STORE_MOBILE = txtMobli.Text;
obj.STORE_NAME = poptxtStoreName.Text;
obj.STORE_POSTCODE = txtPostCode.Text;
obj.STORE_STREET = txtRoad.Text;
obj.STORE_SUBDISTRICT = txtTumbon.Text;
obj.STORE_TEL1 = txtTel1.Text;
obj.STORE_TEL2 = txtTel2.Text;
obj.ZONE_ID = Convert.ToInt32(ddlZone.SelectedValue);
var cmd = new StoreService(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.STORE_ID = Convert.ToInt32(ViewState["stoId"].ToString());
obj.UPDATE_DATE = DateTime.Now;
obj.UPDATE_EMPLOYEE_ID = 0;
obj.SYE_DEL = true;
cmd.Edit();
}
ViewState["stoId"] = null;
Response.Redirect("SearchStore.aspx");
}
public StoreService(STORE item)
{
_item = item;
}
public List<STORE> GetALL(STORE item)
{
using (var ctx = new SPWEntities())
{
var list = ctx.STORE.Where(x => x.STORE_CODE.Contains(item.STORE_CODE)).ToList();
return list;
}
}
private void InitialDataPopup()
{
var cmd = new SectorService();
var list = cmd.GetALL();
foreach (var item in list)
{
ddlSector.Items.Add(new ListItem(item.SECTOR_NAME, item.SECTOR_ID.ToString()));
}
var cmdPro = new ProvinceService();
ViewState["listProvince"] = cmdPro.GetALL();
foreach (var item in (List<PROVINCE>)ViewState["listProvince"])
{
ddlProvince.Items.Add(new ListItem(item.PROVINCE_NAME, item.PROVINCE_ID.ToString()));
}
var cmdRoad = new RoadService();
ViewState["listRoad"] = cmdRoad.GetALL();
foreach (var item in (List<ROAD>)ViewState["listRoad"])
{
ddlRoad.Items.Add(new ListItem(item.ROAD_NAME, item.ROAD_ID.ToString()));
}
var cmdZone = new ZoneService();
var listZone = cmdZone.GetALL();
foreach (var item in listZone)
{
ddlZone.Items.Add(new ListItem(item.ZONE_NAME, item.ZONE_ID.ToString()));
}
if (ViewState["stoId"] != null)
{
var cmdStore = new StoreService();
_store = cmdStore.Select(Convert.ToInt32(ViewState["stoId"].ToString()));
if (_store != null)
{
txtAddress.Text = _store.STORE_ADDR1;
txtAmpur.Text = _store.STORE_DISTRICT;
txtFax.Text = _store.STORE_FAX;
txtMobli.Text = _store.STORE_MOBILE;
txtPostCode.Text = _store.STORE_POSTCODE;
popTxtStoreCode.Text = _store.STORE_CODE;
poptxtStoreName.Text = _store.STORE_NAME;
txtTel1.Text = _store.STORE_TEL1;
txtTel2.Text = _store.STORE_TEL2;
txtTumbon.Text = _store.STORE_SUBDISTRICT;
ddlSector.SelectedValue = _store.SECTOR_ID.ToString();
ddlProvince.SelectedValue = _store.PROVINCE_ID.ToString();
ddlProvince.Enabled = true;
ddlZone.SelectedValue = _store.ZONE_ID.ToString();
//if (ddlProvince.SelectedItem.Text.Equals("กรุงเทพมหานคร"))
//{
ddlRoad.Visible = true;
ddlRoad.SelectedValue = _store.ROAD_ID.ToString();
txtRoad.Visible = false;
//}
//else
//{
// txtRoad.Text = _store.STORE_STREET;
// ddlRoad.Visible = false;
//}
flag.Text = "Edit";
}
}
}
private void InitialData()
{
_store = (STORE)Session["store"];
txtStoreCode.Text = _store.STORE_CODE;
txtStoreName.Text = _store.STORE_NAME;
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 cmd = new ProductService();
DataSouce = cmd.GetALLInclude().Where(x => x.PRODUCT_TYPE_CODE == 1).ToList();
DataSouceShowProduct = new List<ShowProduct>();
foreach (PRODUCT pro in DataSouce)
{
ShowProduct tmp = new ShowProduct();
tmp.PRODUCT_ID = pro.PRODUCT_ID;
tmp.PRODUCT_CODE = pro.PRODUCT_CODE;
tmp.PRODUCT_NAME = pro.PRODUCT_NAME;
tmp.PRICE = pro.PRODUCT_PRICELIST.Where(x => x.PRODUCT_ID == pro.PRODUCT_ID && x.ZONE_ID == _store.ZONE_ID).FirstOrDefault()
!= null ? (decimal)pro.PRODUCT_PRICELIST.Where(x => x.PRODUCT_ID == pro.PRODUCT_ID && x.ZONE_ID == _store.ZONE_ID).FirstOrDefault().PRODUCT_PRICE : 0;
tmp.CATEGORY_ID = pro.CATEGORY_ID;
DataSouceShowProduct.Add(tmp);
}
gridProduct.DataSource = DataSouceShowProduct;
gridProduct.DataBind();
if (lstOrderDetail.Count > 0)
{
lblPrice.Text = lstOrderDetail.Select(x => x.PRODUCT_TOTAL).Sum().ToString();
linkToOrder.Visible = true;
}
}