protected void txtbarcode_TextChanged(object sender, EventArgs e)
{
try
{
if (hiddenCompanyType.Value.Trim() == "CENTRAL")
{
Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(txtbarcode.Text, ddlStore.SelectedValue.ToString());
if (buyCentral != null)
{
txtBalanceQty.Text = Convert.ToString(buyCentral.BalanceQuanity);
}
else
{
txtBalanceQty.Text = "0";
}
}
else
{
Inv_Buy invBuy = buyBll.GetBuyByCompanyAndBarcode(txtbarcode.Text, ddlStore.SelectedValue.ToString());
if (invBuy != null)
{
txtBalanceQty.Text = Convert.ToString(invBuy.BalanceQuanity);
}
else
{
txtBalanceQty.Text = "0";
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int UpdateBuyCentralByStore(int Id, Inv_BuyCentral inv_BuyCentralObj, string ProjectCode, int StoreID, int StoreUnitID)
{
try
{
Inv_BuyCentral buyCentralObj = _context.Inv_BuyCentral.First(x => x.Id == Id && x.Project_Code == ProjectCode && x.Store_Id == StoreID && x.Store_Unit_Id == StoreUnitID);
buyCentralObj.ChallanNo = inv_BuyCentralObj.ChallanNo;
buyCentralObj.PurchaseDate = inv_BuyCentralObj.PurchaseDate;
buyCentralObj.CompanyId = inv_BuyCentralObj.CompanyId;
buyCentralObj.CompanyCode = inv_BuyCentralObj.CompanyCode;
buyCentralObj.CompanyName = inv_BuyCentralObj.CompanyName;
buyCentralObj.BarCode = inv_BuyCentralObj.BarCode;
buyCentralObj.ProductId = inv_BuyCentralObj.ProductId;
buyCentralObj.ProductGroup = inv_BuyCentralObj.ProductGroup;
buyCentralObj.ProductName = inv_BuyCentralObj.ProductName;
buyCentralObj.Brand = inv_BuyCentralObj.Brand;
buyCentralObj.StyleSize = inv_BuyCentralObj.StyleSize;
buyCentralObj.FloorName = inv_BuyCentralObj.FloorName;
buyCentralObj.UnitName = inv_BuyCentralObj.UnitName;
buyCentralObj.ReceiveQuantity = inv_BuyCentralObj.ReceiveQuantity;
buyCentralObj.CPU = inv_BuyCentralObj.CPU;
buyCentralObj.RPU = inv_BuyCentralObj.RPU;
buyCentralObj.ExpireDate = inv_BuyCentralObj.ExpireDate;
buyCentralObj.BalanceQuanity = inv_BuyCentralObj.BalanceQuanity;
buyCentralObj.EditDate = inv_BuyCentralObj.EditDate;
buyCentralObj.OCode = inv_BuyCentralObj.OCode;
buyCentralObj.Item_Remarks = inv_BuyCentralObj.Item_Remarks;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal Inv_BuyCentral GetProductQtyformBuyCentral(productsDetails aitem)
{
string Barcode = aitem.ProductId.ToString();
Inv_BuyCentral buyCentral = _context.Inv_BuyCentral.FirstOrDefault(x => x.BarCode == Barcode);
return(buyCentral);
}
public Inv_BuyCentral GetBuyCentralByBarcodeAndComanyCode(string Barcode, string CompanyCode)
{
try
{
Inv_BuyCentral buyCentrl = _context.Inv_BuyCentral.Where(bc => bc.BarCode == Barcode && bc.CompanyCode == CompanyCode).FirstOrDefault <Inv_BuyCentral>();
return(buyCentrl);
}
catch (Exception ex)
{
throw ex;
}
}
public Inv_BuyCentral GetBuyForReturn(string Barcode, string StoreCode)
{
try
{
Inv_BuyCentral buyCentrl = _context.Inv_BuyCentral.Where(bc => bc.BarCode == Barcode && bc.Store_Code == StoreCode).FirstOrDefault <Inv_BuyCentral>();
return(buyCentrl);
}
catch (Exception ex)
{
throw ex;
}
}
public Inv_BuyCentral GetBuyCentralByBarcode_Store(string Barcode, int CompanyId, string ProjectCode, int StoreID, int StoreUnitID)
{
try
{
Inv_BuyCentral buyCentrl = _context.Inv_BuyCentral.Where(bc => bc.BarCode == Barcode && bc.CompanyId == CompanyId && bc.Project_Code == ProjectCode && bc.Store_Id == StoreID && bc.Store_Unit_Id == StoreUnitID).FirstOrDefault <Inv_BuyCentral>();
return(buyCentrl);
}
catch (Exception ex)
{
throw ex;
}
}
internal int Insert(Inv_BuyCentral inv_BuyCentralObj)
{
try
{
_context.Inv_BuyCentral.AddObject(inv_BuyCentralObj);
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal int Update_buyCentral(int id)
{
try
{
Inv_BuyCentral prodObj = _context.Inv_BuyCentral.First(x => x.Id == id);
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal Inv_BuyCentral GeBuyCentralListbyId(int fID)
{
try
{
Inv_BuyCentral Bi = (from b in _context.Inv_BuyCentral
where b.Id == fID
select b).FirstOrDefault();
return(Bi);
}
catch (Exception ex)
{
throw ex;
}
}
internal int Update_ForReturnBy_CentralToStore(int Id, string barcode, string StoreCode, string challanNo, Inv_BuyCentral inv_BuyCentralObj)
{
try
{
Inv_BuyCentral buyCentralObj = _context.Inv_BuyCentral.First(x => x.Id == Id && x.BarCode == barcode && x.ChallanNo == challanNo && x.Store_Code == StoreCode);
buyCentralObj.BalanceQuanity = inv_BuyCentralObj.BalanceQuanity;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
private void GetProductStatus()
{
try
{
string status = "";
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
string EID = ((SessionUser)Session["SessionUser"]).EID;
//List<Inv_Product> product1 = _productStatus.GetProductStatus(OCODE);
List <productsDetails> product = aProductBLL.GetAllGroupProductByEID(EID, OCODE);
foreach (productsDetails aitem in product)
{
Inv_BuyCentral _buyCentral = _productStatus.GetProductQtyformBuyCentral(aitem);
//productsDetails _buyCentral = _productStatus.GetAllStockProductByEID(EID, OCODE);
//var _buyCentral = lstproductsDetails.FirstOrDefault();
if (_buyCentral != null)
{
if (aitem.ReOrderQty == _buyCentral.BalanceQuanity)
{
status += "<b style='color:Black'><img src='img/tkupdown.gif' /> " + aitem.ProductName + "-" + _buyCentral.BalanceQuanity;
}
else if (aitem.ReOrderQty > _buyCentral.BalanceQuanity)
{
status += "<b style='color:Black'><img src='img/tkdown.gif' /> " + aitem.ProductName + "-" + _buyCentral.BalanceQuanity;
}
else if (aitem.ReOrderQty < _buyCentral.BalanceQuanity)
{
status += "<b style='color:Black'><img src='img/tkup.gif' /> " + aitem.ProductName + "-" + _buyCentral.BalanceQuanity;
}
}
}
lblitem.Text = status;
}
catch (Exception ex)
{
throw ex;
}
}
protected void ImgUnitEdit_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
ImageButton imgbtn = (ImageButton)sender;
GridViewRow row = (GridViewRow)imgbtn.NamingContainer;
ShowDiv.Visible = true;
try
{
Label lblBuyCentralId = (Label)grdUnit.Rows[row.RowIndex].FindControl("lblId");
int fID = Convert.ToInt16(lblBuyCentralId.Text);
Inv_BuyCentral _BuyCID = _buyCentralbll.GeBuyCentralListbyId(fID);
if (_BuyCID != null)
{
HidBuyCentralID.Value = _BuyCID.Id.ToString();
GetAllStore();
ddlStore.SelectedValue = _BuyCID.Store_Code;
FillSupplier();
ddlSupplier.SelectedValue = _BuyCID.SupplierCode;
txtRefNo.Text = _BuyCID.RefNo_ChallanNo;
txtDate.Text = _BuyCID.PurchaseDate.ToString();
txtPINo.Text = _BuyCID.PI_No;
txtMRRNo.Text = _BuyCID.ChallanNo;
txtMasterLCNo.Text = _BuyCID.MasterLCNo;
txtB2BLCNo.Text = _BuyCID.B2BLCNo;
txtReceiverEID.Text = _BuyCID.ReceiverEID;
LoadOrderNumber();
ddlOrder.SelectedValue = _BuyCID.OrderEId.ToString();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int Update(int Id, Inv_BuyCentral inv_BuyCentralObj)
{
try
{
Inv_BuyCentral buyCentralObj = _context.Inv_BuyCentral.First(x => x.Id == Id);
buyCentralObj.ChallanNo = inv_BuyCentralObj.ChallanNo;
buyCentralObj.CompanyId = inv_BuyCentralObj.CompanyId;
buyCentralObj.CompanyCode = inv_BuyCentralObj.CompanyCode;
buyCentralObj.CompanyName = inv_BuyCentralObj.CompanyName;
buyCentralObj.PurchaseDate = inv_BuyCentralObj.PurchaseDate;
buyCentralObj.BarCode = inv_BuyCentralObj.BarCode;
buyCentralObj.ProductId = inv_BuyCentralObj.ProductId;
buyCentralObj.ProductGroup = inv_BuyCentralObj.ProductGroup;
buyCentralObj.ProductName = inv_BuyCentralObj.ProductName;
buyCentralObj.Brand = inv_BuyCentralObj.Brand;
buyCentralObj.StyleSize = inv_BuyCentralObj.StyleSize;
buyCentralObj.FloorName = inv_BuyCentralObj.FloorName;
buyCentralObj.UnitName = inv_BuyCentralObj.UnitName;
buyCentralObj.ReceiveQuantity = inv_BuyCentralObj.ReceiveQuantity;
buyCentralObj.ActualQty = inv_BuyCentralObj.ActualQty;
buyCentralObj.Free_Qty = inv_BuyCentralObj.Free_Qty;
buyCentralObj.CPU = inv_BuyCentralObj.CPU;
buyCentralObj.PI_No = inv_BuyCentralObj.PI_No;
buyCentralObj.RPU = inv_BuyCentralObj.RPU;
buyCentralObj.ExpireDate = inv_BuyCentralObj.ExpireDate;
buyCentralObj.BalanceQuanity = inv_BuyCentralObj.BalanceQuanity;
buyCentralObj.PurchaseDate = inv_BuyCentralObj.PurchaseDate;
buyCentralObj.EditDate = inv_BuyCentralObj.EditDate;
buyCentralObj.OCode = inv_BuyCentralObj.OCode;
buyCentralObj.Item_Remarks = inv_BuyCentralObj.Item_Remarks;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal int UpdateBuyCentral(Inv_BuyCentral purchase, int pId)
{
try
{
Inv_BuyCentral prodObj = _context.Inv_BuyCentral.First(x => x.Id == pId);
prodObj.Store_Id = purchase.Store_Id;
prodObj.SupplierCode = purchase.SupplierCode;
prodObj.RefNo_ChallanNo = purchase.RefNo_ChallanNo;
//prodObj.SeasonID = purchase.SeasonID;
prodObj.OrderEId = purchase.OrderEId;
prodObj.PurchaseDate = purchase.PurchaseDate;
prodObj.ChallanNo = purchase.ChallanNo;
prodObj.MasterLCNo = purchase.MasterLCNo;
prodObj.B2BLCNo = purchase.B2BLCNo;
prodObj.PI_No = purchase.PI_No;
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
Inv_BuyCentral purchase = new Inv_BuyCentral();
//purchase.Store_Id = Convert.ToInt32(ddlStore.SelectedValue.ToString());
purchase.SupplierCode = ddlSupplier.SelectedItem.Text;
purchase.RefNo_ChallanNo = txtRefNo.Text;
//purchase.SeasonID = Convert.ToInt32(ddlSeason.SelectedValue.ToString());
purchase.OrderEId = Convert.ToInt32(ddlOrder.SelectedValue.ToString());
purchase.Store_Code = ddlStore.SelectedValue;
purchase.PurchaseDate = DateTime.Parse(txtDate.Text);
purchase.ChallanNo = txtMRRNo.Text.Trim();
purchase.MasterLCNo = txtMasterLCNo.Text;
purchase.B2BLCNo = txtB2BLCNo.Text;
purchase.PI_No = txtPINo.Text;
purchase.EditDate = DateTime.Now;
purchase.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
int pId = Convert.ToInt16(HidBuyCentralID.Value);
int result = rChallanBll.UpdateBuyCentral(purchase, pId);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true);
}
ShowDiv.Visible = false;
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int UpdateBuyCentralByStore(Inv_BuyCentral inv_BuyCentralObj, int Id, string ProjectCode, int StoreID, int StoreUnitID)
{
return(buyCentralDal.UpdateBuyCentralByStore(Id, inv_BuyCentralObj, ProjectCode, StoreID, StoreUnitID));
}
internal int Update(Inv_BuyCentral inv_BuyCentralObj, int Id)
{
return(buyCentralDal.Update(Id, inv_BuyCentralObj));
}
internal int Insert(Inv_BuyCentral inv_BuyCentralObj)
{
return(buyCentralDal.Insert(inv_BuyCentralObj));
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List <Inv_RChallan_Temp> staticPurchaseList = new List <Inv_RChallan_Temp>();
string challanNo = txtChallanNo.Text.Trim();
staticPurchaseList = rChallanBll.GetTempRChalan(((SessionUser)Session["SessionUser"]).OCode, challanNo);
//staticPurchaseList = rChallanBll.GetTempRChalan("8989", challanNo);
if (hiddenCompanyType.Value.Trim() == "CENTRAL")
{
foreach (Inv_RChallan_Temp rchallan in staticPurchaseList)
{
Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(rchallan.BarCode, rchallan.CompanyCode);
if (buyCentral == null)
{
// Insert New
Inv_BuyCentral newBuyCentral = new Inv_BuyCentral();
newBuyCentral.ChallanNo = rchallan.ChallanNo;
newBuyCentral.CompanyId = rchallan.CompanyId;
newBuyCentral.CompanyCode = rchallan.CompanyCode;
newBuyCentral.CompanyName = rchallan.CompanyName;
newBuyCentral.BarCode = rchallan.BarCode;
newBuyCentral.ProductId = Convert.ToInt32(rchallan.ProductId);
newBuyCentral.ProductGroup = rchallan.ProductGroup;
newBuyCentral.ProductName = rchallan.ProductName;
newBuyCentral.Brand = rchallan.Brand;
newBuyCentral.StyleSize = rchallan.StyleSize;
newBuyCentral.FloorName = rchallan.FloorName;
newBuyCentral.UnitName = rchallan.UnitName;
newBuyCentral.ReceiveQuantity = rchallan.ReceiveQuantity;
newBuyCentral.CPU = rchallan.CPU;
newBuyCentral.RPU = rchallan.RPU;
newBuyCentral.ExpireDate = rchallan.ExpireDate;
newBuyCentral.BalanceQuanity = rchallan.BalanceQuanity;
newBuyCentral.PurchaseDate = rchallan.PurchaseDate;
newBuyCentral.EditDate = rchallan.EditDate;
newBuyCentral.OCode = rchallan.OCode;
newBuyCentral.OrderNo = rchallan.OrderNo;
buyCentralBll.Insert(newBuyCentral);
}
else
{
buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + rchallan.ReceiveQuantity;
buyCentral.CPU = rchallan.CPU;
buyCentral.RPU = rchallan.RPU;
buyCentral.ExpireDate = rchallan.ExpireDate;
buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + rchallan.ReceiveQuantity;
//buyCentral.Id = Convert.ToInt16(hidId.Value);
buyCentralBll.Update(buyCentral, buyCentral.Id);
}
rChallanBll.Insert(ConvertTmpToRchallan(rchallan));
rChallanBll.DeleteTempChalanById(rchallan.Id);
//string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
//string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString();
//string Company_Code = "CMP201506051";
//string ModuleType = "Inventory";
//string VoucherType = "PAYMENT";
//rChallanBll.Enter_VoucherDetails(OCODE, Company_Code,Edit_User, ModuleType, VoucherType, ConvertTmpToRchallan(rchallan));
//lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
gvPurchase.DataSource = null;
gvPurchase.DataBind();
ddlChalanNo.Items.Clear();
}
ClearForm();
}
else // hiddenCompanyType = General
{
foreach (Inv_RChallan_Temp rchallan in staticPurchaseList)
{
Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(rchallan.BarCode, rchallan.CompanyCode);
if (buy == null)
{ // Insert New
Inv_Buy invBuy = new Inv_Buy();
invBuy.ChallanNo = rchallan.ChallanNo;
invBuy.CompanyId = rchallan.CompanyId;
invBuy.CompanyCode = rchallan.CompanyCode;
invBuy.CompanyName = rchallan.CompanyName;
invBuy.BarCode = rchallan.BarCode;
invBuy.ProductId = Convert.ToInt32(rchallan.ProductId);
invBuy.ProductGroup = rchallan.ProductGroup;
invBuy.ProductName = rchallan.ProductName;
invBuy.Brand = rchallan.Brand;
invBuy.StyleSize = rchallan.StyleSize;
invBuy.FloorName = rchallan.FloorName;
invBuy.UnitName = rchallan.UnitName;
invBuy.ReceiveQuantity = rchallan.ReceiveQuantity;
invBuy.CPU = rchallan.CPU;
invBuy.RPU = rchallan.RPU;
invBuy.ExpireDate = rchallan.ExpireDate;
invBuy.BalanceQuanity = rchallan.BalanceQuanity;
invBuy.PurchaseDate = rchallan.PurchaseDate;
invBuy.DeliveryQty = Convert.ToInt32(rchallan.DeliveryQty);
invBuy.EditDate = rchallan.EditDate;
invBuy.OCode = rchallan.OCode;
invBuy.OrderNo = rchallan.OrderNo;
buyBll.Insert(invBuy);
}
else
{
buy.BalanceQuanity = buy.BalanceQuanity + rchallan.ReceiveQuantity;
buy.CPU = rchallan.CPU;
buy.RPU = rchallan.RPU;
buy.ExpireDate = rchallan.ExpireDate;
buy.ReceiveQuantity = buy.ReceiveQuantity + rchallan.ReceiveQuantity;
int Id = Convert.ToInt16(hidId.Value);
buyBll.Update(buy, Id);
}
rChallanBll.Insert(ConvertTmpToRchallan(rchallan));
rChallanBll.DeleteTempChalanById(rchallan.Id);
// lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
ddlChalanNo.Items.Clear();
}
ClearForm();
}
// End of IF CENTRAL OR GENERAL
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
string challanNo = txtChalanNo.Text.Trim();
//string CType = hiddenCompanyType.Value;
string CType = "CENTRAL";
if (CType == "CENTRAL")
{
Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString());
if (buyCentral == null)
{ // Insert New
Inv_BuyCentral newBuyCentral = new Inv_BuyCentral();
newBuyCentral.ChallanNo = txtChalanNo.Text;
newBuyCentral.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue);
newBuyCentral.CompanyCode = HiddenCompanyCode.Value;
newBuyCentral.CompanyName = HiddenCompanyName.Value;
newBuyCentral.BarCode = hdnBarCode.Value;
newBuyCentral.ProductId = int.Parse(hdnBarCode.Value.ToString());
newBuyCentral.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString());
newBuyCentral.ProductName = txtProduct.Text;
newBuyCentral.Brand = txtBrand.Text;
//newBuyCentral.StyleSize = rchallan.StyleSize;
//newBuyCentral.FloorName = rchallan.FloorName;
newBuyCentral.UnitName = txtUnit.Text;
newBuyCentral.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim());
//newBuyCentral.CPU = rchallan.CPU;
//newBuyCentral.RPU = rchallan.RPU;
//newBuyCentral.ExpireDate = rchallan.ExpireDate;
//newBuyCentral.BalanceQuanity = rchallan.BalanceQty;
try
{
newBuyCentral.PurchaseDate = DateTime.Parse(txtDate.Text);
}
catch
{
newBuyCentral.PurchaseDate = DateTime.Today;
}
newBuyCentral.EditDate = DateTime.Now;
newBuyCentral.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
newBuyCentral.OCode = ((SessionUser)Session["SessionUser"]).OCode;
buyCentralBll.Insert(newBuyCentral);
}
else
{
buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim());
//buyCentral.CPU = rchallan.CPU;
//buyCentral.RPU = rchallan.RPU;
//buyCentral.ExpireDate = rchallan.ExpireDate;
buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim());
buyCentralBll.Update(buyCentral, Convert.ToInt32(buyCentral.Id));
}
Inv_RChallan rchallan = new Inv_RChallan();
rchallan.ChallanNo = txtChalanNo.Text;
rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue);
rchallan.CompanyCode = HiddenCompanyCode.Value;
rchallan.CompanyName = HiddenCompanyName.Value;
rchallan.Barcode = hdnBarCode.Value;
rchallan.ProductId = int.Parse(hdnBarCode.Value.ToString());
rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString());
rchallan.ProductName = txtProduct.Text;
rchallan.Brand = txtBrand.Text;
//rchallan.StyleSize = rchallan.StyleSize;
//rchallan.FloorName = rchallan.FloorName;
rchallan.UnitName = txtUnit.Text;
rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim());
//rchallan.CPU = rchallan.CPU;
//rchallan.RPU = rchallan.RPU;
//rchallan.ExpireDate = rchallan.ExpireDate;
//rchallan.BalanceQuanity = rchallan.BalanceQty;
try
{
rchallan.PurchaseDate = DateTime.Parse(txtDate.Text);
}
catch
{
rchallan.PurchaseDate = DateTime.Today;
}
rchallan.EditDate = DateTime.Now;
rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode;
rChallanBll.Insert(rchallan);
PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text);
LoadPurchaseOrders();
// lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
GenerateReport();
ClearForm();
}
else // obsolete // hiddenCompanyType = General
{
Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString());
if (buy == null)
{ // Insert New
Inv_Buy invBuy = new Inv_Buy();
invBuy.ChallanNo = txtChalanNo.Text;
invBuy.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue);
invBuy.CompanyCode = HiddenCompanyCode.Value;
invBuy.CompanyName = HiddenCompanyName.Value;
invBuy.BarCode = hdnBarCode.Value;
invBuy.ProductId = int.Parse(hdnBarCode.Value.ToString());
invBuy.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString());
invBuy.ProductName = txtProduct.Text;
invBuy.Brand = txtBrand.Text;
//newBuyCentral.StyleSize = rchallan.StyleSize;
//newBuyCentral.FloorName = rchallan.FloorName;
invBuy.UnitName = txtUnit.Text;
invBuy.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim());
//newBuyCentral.CPU = rchallan.CPU;
//newBuyCentral.RPU = rchallan.RPU;
//newBuyCentral.ExpireDate = rchallan.ExpireDate;
//newBuyCentral.BalanceQuanity = rchallan.BalanceQty;
try
{
invBuy.PurchaseDate = DateTime.Parse(txtDate.Text);
}
catch
{
invBuy.PurchaseDate = DateTime.Today;
}
invBuy.EditDate = DateTime.Now;
invBuy.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
invBuy.OCode = ((SessionUser)Session["SessionUser"]).OCode;
buyBll.Insert(invBuy);
}
else
{
buy.BalanceQuanity = buy.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim());
//buy.CPU = rchallan.CPU;
//buy.RPU = rchallan.RPU;
//buy.ExpireDate = rchallan.ExpireDate;
buy.ReceiveQuantity = buy.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim());
buyBll.Update(buy, Convert.ToInt32(buy.Id));
}
Inv_RChallan rchallan = new Inv_RChallan();
rchallan.ChallanNo = txtChalanNo.Text;
rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue);
rchallan.CompanyCode = HiddenCompanyCode.Value;
rchallan.CompanyName = HiddenCompanyName.Value;
rchallan.Barcode = hdnBarCode.Value;
rchallan.ProductId = int.Parse(hdnBarCode.Value.ToString());
rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString());
rchallan.ProductName = txtProduct.Text;
rchallan.Brand = txtBrand.Text;
//rchallan.StyleSize = rchallan.StyleSize;
//rchallan.FloorName = rchallan.FloorName;
rchallan.UnitName = txtUnit.Text;
rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim());
//rchallan.CPU = rchallan.CPU;
//rchallan.RPU = rchallan.RPU;
//rchallan.ExpireDate = rchallan.ExpireDate;
//rchallan.BalanceQuanity = rchallan.BalanceQty;
try
{
rchallan.PurchaseDate = DateTime.Parse(txtDate.Text);
}
catch
{
rchallan.PurchaseDate = DateTime.Today;
}
rchallan.EditDate = DateTime.Now;
rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode;
rChallanBll.Insert(rchallan);
PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text);
LoadPurchaseOrders();
//lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
}
ClearForm();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
try
{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString();
List <Inv_Damage_Temp> damageList = new List <Inv_Damage_Temp>();
string challanNo = txtChalanNo.Text.Trim();
damageList = rChallanBll.GetTempDanmage(((SessionUser)Session["SessionUser"]).OCode, challanNo);
foreach (Inv_Damage_Temp rchallan in damageList)
{
Inv_BuyCentral buycentral = _BuyCentral.GetBuyForReturn(rchallan.BarCode, rchallan.Store_Code);
if (buycentral != null)
{
// Kamruzzaman...........
Inv_Damage _damage = new Inv_Damage();
_damage.ChallanNo = txtChalanNo.Text;
_damage.Challan_No_To = rchallan.Challan_No_To;
_damage.BarCode = rchallan.BarCode;
_damage.ProductId = Convert.ToInt32(rchallan.ProductId);
_damage.ProductGroup = rchallan.ProductGroup;
_damage.ProductName = rchallan.ProductName;
_damage.Brand = rchallan.Brand;
_damage.StyleSize = rchallan.StyleSize;
_damage.FloorName = rchallan.FloorName;
_damage.UnitName = rchallan.UnitName;
_damage.ReceiveQuantity = rchallan.ReceiveQuantity;
_damage.CPU = rchallan.CPU;
_damage.RPU = rchallan.RPU;
_damage.ExpireDate = rchallan.ExpireDate;
_damage.BalanceQuanity = rchallan.BalanceQuanity;
_damage.PurchaseDate = rchallan.PurchaseDate;
_damage.EditDate = rchallan.EditDate;
_damage.OCode = rchallan.OCode;
_damage.Store_Code = rchallan.Store_Code;
_damage.SupplierReturnQty = rchallan.SupplierReturnQty;
_damage.CompanyCode = rchallan.CompanyCode;
_damage.PurchaseDate = rchallan.PurchaseDate;
_damage.EditDate = DateTime.Today;
_damage.EditUser = rchallan.EditUser;
_damage.DamageDate = DateTime.Today;
_damage.CompanyName = rchallan.CompanyName;
_damage.CompanyId = rchallan.CompanyId;
_damage.DamageQty = rchallan.DamageQty;
_damage.DamageCategory = rchallan.DamageCategory;
_damage.Remarks = rchallan.Remarks;
_BuyCentral.InsertDamage(_damage);
buycentral.BalanceQuanity = buycentral.BalanceQuanity - rchallan.DamageQty;
buycentral.SupplierReturnQty = buycentral.DamageQty + rchallan.DamageQty;
//buyCentral.Id = Convert.ToInt16(hidId.Value);
_BuyCentral.Update_ForReturn(buycentral.Id, buycentral.BarCode, buycentral.Store_Code, buycentral.ChallanNo, buycentral);
_BuyCentral.DeleteDamage_Temp(rchallan.Id);
}
else
{
}
}
grdDamage.DataSource = null;
grdDamage.DataBind();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Product damage information inserted successfully!')", true);
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
public Inv_BuyCentral GetBuyCentralByBarcodeAndStoreCode(string barcode, string StoreCode)
{
Inv_BuyCentral buyCentral = buyCentralDal.GetBuyCentralByBarcodeAndStoreCode(barcode, StoreCode);
return(buyCentral);
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
try
{
DateTime date = DateTime.Today;
GetNewChallanNo(date);
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString();
Guid UserId = ((SessionUser)Session["SessionUser"]).UserId;
List <Inv_Return_Temp> ReturnList = new List <Inv_Return_Temp>();
string challanNo = txtChalanNoReturn.Text.Trim();
ReturnList = rChallanBll.GetTempReturn(((SessionUser)Session["SessionUser"]).OCode, UserId);
foreach (Inv_Return_Temp rchallan in ReturnList)
{
if (ddlStoreName.SelectedValue == "CNT")
{
Inv_BuyCentral buyCentral = _BuyCentral.GetBuyForReturn(rchallan.BarCode, rchallan.Store_Code);
if (buyCentral != null)
{
// Kamruzzaman...........
Inv_Return _return = new Inv_Return();
_return.ChallanNo = txtChalanNoReturn.Text;
_return.ChallanNo_To = rchallan.ChallanNo_To;
_return.BarCode = rchallan.BarCode;
_return.ProductId = Convert.ToInt32(rchallan.ProductId);
_return.ProductGroup = rchallan.ProductGroup;
_return.ProductName = rchallan.ProductName;
_return.Remarks = rchallan.Remarks;
_return.Brand = rchallan.Brand;
_return.StyleSize = rchallan.StyleSize;
_return.FloorName = rchallan.FloorName;
_return.UnitName = rchallan.UnitName;
_return.ReceiveQuantity = rchallan.ReceiveQuantity;
_return.CPU = rchallan.CPU;
_return.RPU = rchallan.RPU;
_return.ExpireDate = rchallan.ExpireDate;
_return.BalanceQuanity = rchallan.BalanceQuanity;
_return.PurchaseDate = rchallan.PurchaseDate;
_return.EditDate = rchallan.EditDate;
_return.OCode = rchallan.OCode;
_return.Store_Code = rchallan.Store_Code;
_return.SupplierReturnQty = rchallan.SupplierReturnQty;
_return.SupplierCode = rchallan.SupplierCode;
_return.CurrentCompanyCode = rchallan.CurrentCompanyCode;
_return.PurchaseDate = rchallan.PurchaseDate;
_return.EditDate = DateTime.Today;
_return.EditUser = rchallan.EditUser;
_return.OldCompanyCode = rchallan.OldCompanyCode;
_return.ReturnDate = DateTime.Today;
_return.ERetQty = rchallan.ERetQty;
_return.OldCompanyName = rchallan.OldCompanyName;
_return.OldCompanyId = rchallan.OldCompanyId;
_return.ReturnType = "StoreToCentral";
_return.EID = rchallan.EID;
_return.DPT_CODE = rchallan.DPT_CODE;
_return.ProgramId = rchallan.ProgramId;
_BuyCentral.InsertReturn(_return);
// buy.BalanceQuanity = buy.BalanceQuanity - rchallan.ERetQty;
buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + rchallan.ERetQty;
//buyCentral.Id = Convert.ToInt16(hidId.Value);
// _BuyCentral.Update_Return_DptWise(buy.Id, buy.BarCode, buy.Store_Code, buy.ChallanNo, buy);
_BuyCentral.Update_ForReturnBy_CentralToStore(buyCentral.Id, buyCentral.BarCode, buyCentral.Store_Code, buyCentral.ChallanNo, buyCentral);
_BuyCentral.DeleteReturn_Temp(rchallan.Id);
}
else
{
}
}
else
{
Inv_Buy buy = _BuyCentral.GetBuy_DPT_Return(rchallan.BarCode, rchallan.Store_Code, rchallan.ChallanNo_To);
if (buy != null)
{
// Kamruzzaman...........
Inv_Return _return = new Inv_Return();
_return.ChallanNo = txtChalanNoReturn.Text;
_return.ChallanNo_To = rchallan.ChallanNo_To;
_return.BarCode = rchallan.BarCode;
_return.ProductId = Convert.ToInt32(rchallan.ProductId);
_return.ProductGroup = rchallan.ProductGroup;
_return.ProductName = rchallan.ProductName;
_return.Brand = rchallan.Brand;
_return.StyleSize = rchallan.StyleSize;
_return.FloorName = rchallan.FloorName;
_return.UnitName = rchallan.UnitName;
_return.ReceiveQuantity = rchallan.ReceiveQuantity;
_return.CPU = rchallan.CPU;
_return.Remarks = rchallan.Remarks;
_return.RPU = rchallan.RPU;
_return.ExpireDate = rchallan.ExpireDate;
_return.BalanceQuanity = rchallan.BalanceQuanity;
_return.PurchaseDate = rchallan.PurchaseDate;
_return.EditDate = rchallan.EditDate;
_return.OCode = rchallan.OCode;
_return.Store_Code = rchallan.Store_Code;
_return.SupplierReturnQty = rchallan.SupplierReturnQty;
_return.SupplierCode = rchallan.SupplierCode;
_return.CurrentCompanyCode = rchallan.CurrentCompanyCode;
_return.PurchaseDate = rchallan.PurchaseDate;
_return.EditDate = DateTime.Today;
_return.EditUser = rchallan.EditUser;
_return.OldCompanyCode = rchallan.OldCompanyCode;
_return.ReturnDate = DateTime.Today;
_return.ERetQty = rchallan.ERetQty;
_return.OldCompanyName = rchallan.OldCompanyName;
_return.OldCompanyId = rchallan.OldCompanyId;
_return.ReturnType = "StoreToStore";
_return.EID = rchallan.EID;
_return.DPT_CODE = rchallan.DPT_CODE;
_return.ProgramId = rchallan.ProgramId;
_BuyCentral.InsertReturn(_return);
// buy.BalanceQuanity = buy.BalanceQuanity - rchallan.ERetQty;
buy.BalanceQuanity = buy.BalanceQuanity + rchallan.ERetQty;
//buyCentral.Id = Convert.ToInt16(hidId.Value);
_BuyCentral.Update_Return_DptWise(buy.Id, buy.BarCode, buy.Store_Code, buy.ChallanNo, buy);
// _BuyCentral.Update_ForReturnBy_CentralToStore(buyCentral.Id, buyCentral.BarCode, buyCentral.Store_Code, buyCentral.ChallanNo, buyCentral);
_BuyCentral.DeleteReturn_Temp(rchallan.Id);
}
else
{
}
}
}
grdTransfer.DataSource = null;
grdTransfer.DataBind();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Returned Successfully')", true);
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
public Inv_BuyCentral GetBuyCentralByBarcode_Store(string barcode, int CompanyId, string ProjectCode, int StoreID, int StoreUnitID)
{
Inv_BuyCentral buyCentral = buyCentralDal.GetBuyCentralByBarcode_Store(barcode, CompanyId, ProjectCode, StoreID, StoreUnitID);
return(buyCentral);
}
public Inv_BuyCentral GetBuyCentralByCompanyCodeAndBarcode(string barcode, string CompanyCode)
{
Inv_BuyCentral buyCentral = buyCentralDal.GetBuyCentralByBarcodeAndComanyCode(barcode, CompanyCode);
return(buyCentral);
}
internal int UpdateBuyCentral(Inv_BuyCentral purchase, int pId)
{
return(rChallanDal.UpdateBuyCentral(purchase, pId));
}
internal int Update_ForReturn(int Id, string barcode, string StoreCode, string challanNo, Inv_BuyCentral inv_BuyCentralObj)
{
return(buyCentralDal.Update_ForReturn(Id, barcode, StoreCode, challanNo, inv_BuyCentralObj));
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List <Inv_RChallan_Temp> staticPurchaseList = new List <Inv_RChallan_Temp>();
string challanNo = txtChallanNo.Text.Trim();
staticPurchaseList = rChallanBll.GetTempRChalan(((SessionUser)Session["SessionUser"]).OCode, challanNo);
//staticPurchaseList = rChallanBll.GetTempRChalan("8989", challanNo);
if (gvPurchase.Rows.Count == 0)
{
//lblMessage.Text = "<font color='red'>Item list is empty!</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item list is empty!')", true);
return;
}
//if (hiddenCompanyType.Value == "CENTRAL")
//{
foreach (Inv_RChallan_Temp rchallan in staticPurchaseList)
{
Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByBarcode_Store(rchallan.BarCode, Convert.ToInt32(rchallan.CompanyId), rchallan.Project_Code, Convert.ToInt32(rchallan.Store_Id), Convert.ToInt32(rchallan.Store_Unit_Id));
if (buyCentral == null)
{
// Insert New
Inv_BuyCentral newBuyCentral = new Inv_BuyCentral();
newBuyCentral.ChallanNo = rchallan.ChallanNo;
newBuyCentral.CompanyId = rchallan.CompanyId;
newBuyCentral.CompanyCode = rchallan.CompanyCode;
newBuyCentral.CompanyName = rchallan.CompanyName;
newBuyCentral.BarCode = rchallan.BarCode;
newBuyCentral.ProductId = Convert.ToInt32(rchallan.ProductId);
newBuyCentral.ProductGroup = rchallan.ProductGroup;
newBuyCentral.ProductName = rchallan.ProductName;
newBuyCentral.Brand = rchallan.Brand;
newBuyCentral.StyleSize = rchallan.StyleSize;
newBuyCentral.FloorName = rchallan.FloorName;
newBuyCentral.UnitName = rchallan.UnitName;
newBuyCentral.ReceiveQuantity = rchallan.ReceiveQuantity;
newBuyCentral.CPU = rchallan.CPU;
newBuyCentral.RPU = rchallan.RPU;
newBuyCentral.ExpireDate = rchallan.ExpireDate;
newBuyCentral.BalanceQuanity = rchallan.BalanceQuanity;
newBuyCentral.PurchaseDate = rchallan.PurchaseDate;
newBuyCentral.EditDate = rchallan.EditDate;
newBuyCentral.OCode = rchallan.OCode;
newBuyCentral.Item_Remarks = rchallan.Item_Remarks;
newBuyCentral.Project_Code = rchallan.Project_Code;
newBuyCentral.Store_Id = rchallan.Store_Id;
newBuyCentral.Store_Unit_Id = rchallan.Store_Unit_Id;
buyCentralBll.Insert(newBuyCentral);
}
else
{
buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + rchallan.ReceiveQuantity;
buyCentral.CPU = rchallan.CPU;
buyCentral.RPU = rchallan.RPU;
buyCentral.ExpireDate = rchallan.ExpireDate;
buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + rchallan.ReceiveQuantity;
//buyCentral.Id = Convert.ToInt16(hidId.Value);
buyCentralBll.UpdateBuyCentralByStore(buyCentral, Convert.ToInt32(buyCentral.Id), buyCentral.Project_Code, Convert.ToInt32(buyCentral.Store_Id), Convert.ToInt32(buyCentral.Store_Unit_Id));
}
rChallanBll.Insert(ConvertTmpToRchallan(rchallan));
rChallanBll.DeleteTempChalanById(rchallan.Id);
//lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
gvPurchase.DataSource = null;
gvPurchase.DataBind();
ddlChalanNo.Items.Clear();
}
ClearForm();
//}
//else // hiddenCompanyType = General
//{
// foreach (Inv_RChallan_Temp rchallan in staticPurchaseList)
// {
// Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(rchallan.Barcode, Convert.ToInt32(rchallan.CompanyId));
// if (buy == null)
// { // Insert New
// Inv_Buy invBuy = new Inv_Buy();
// invBuy.ChallanNo = rchallan.ChallanNo;
// invBuy.CompanyId = rchallan.CompanyId;
// invBuy.CompanyCode = rchallan.CompanyCode;
// invBuy.CompanyName = rchallan.CompanyName;
// invBuy.BarCode = rchallan.Barcode;
// invBuy.ProductId = Convert.ToInt32(rchallan.ProductId);
// invBuy.ProductGroup = rchallan.ProductGroup;
// invBuy.ProductName = rchallan.ProductName;
// invBuy.Brand = rchallan.Brand;
// invBuy.StyleSize = rchallan.StyleSize;
// invBuy.FloorName = rchallan.FloorName;
// invBuy.UnitName = rchallan.UnitName;
// invBuy.ReceiveQuantity = rchallan.ReceiveQuantity;
// invBuy.CPU = rchallan.CPU;
// invBuy.RPU = rchallan.RPU;
// invBuy.ExpireDate = rchallan.ExpireDate;
// invBuy.BalanceQuanity = rchallan.BalanceQty;
// invBuy.PurchaseDate = rchallan.PurchaseDate;
// invBuy.DeliveryQty = Convert.ToInt32(rchallan.DeliveryQty);
// invBuy.EditDate = rchallan.EditDate;
// invBuy.OCode = rchallan.Ocode;
// buyBll.Insert(invBuy);
// }
// else
// {
// buy.BalanceQuanity = buy.BalanceQuanity + rchallan.ReceiveQuantity;
// buy.CPU = rchallan.CPU;
// buy.RPU = rchallan.RPU;
// buy.ExpireDate = rchallan.ExpireDate;
// buy.ReceiveQuantity = buy.ReceiveQuantity + rchallan.ReceiveQuantity;
// int Id = Convert.ToInt16(hidId.Value);
// buyBll.Update(buy, Id);
// }
// rChallanBll.Insert(ConvertTmpToRchallan(rchallan));
// rChallanBll.DeleteTempChalanById(rchallan.Id);
// lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
// ddlChalanNo.Items.Clear();
// }
// ClearForm();
//}// End of IF CENTRAL OR GENERAL
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
