private Inv_RChallan ConvertTmpToRchallan(Inv_RChallan_Temp t)
{
Inv_RChallan c = new Inv_RChallan();
c.BalanceQty = t.BalanceQuanity;
c.Barcode = t.BarCode;
c.Brand = t.Brand;
c.ChallanDate = t.PurchaseDate;
c.ChallanNo = t.ChallanNo;
c.ChallanTotal = t.ChallanTotal;
c.CompanyCode = t.CompanyCode;
c.CompanyId = t.CompanyId;
c.CompanyName = t.CompanyName;
c.CPU = t.CPU;
c.DeliveryQty = t.DeliveryQty;
c.EditDate = t.EditDate;
c.EditUser = t.EditUser;
c.FloorName = t.FloorName;
c.Id = t.Id;
c.PurchaseDate = t.PurchaseDate;
c.Ocode = t.OCode;
c.ProductGroup = t.ProductGroup;
c.ProductId = t.ProductId;
c.ProductName = t.ProductName;
c.ReceiveQuantity = t.ReceiveQuantity;
c.RPU = t.RPU;
c.ExpireDate = t.ExpireDate;
c.StyleSize = t.StyleSize;
c.SupplierCode = t.SupplierCode;
c.SupplierReturnQty = t.SupplierReturnQty;
c.UnitName = t.UnitName;
// if neeeded
//c.VailPerPack = t.VailPerPack;
//c.TestPerVail = t.TestPerVail;
//c.TotalVailQty = t.TotalVailQty;
//c.BalanceStatus = t.BalanceStatus;
c.Item_Remarks = t.Item_Remarks;
c.PO_No = t.PO_No;
c.Mode_Of_Delivery = t.Mode_Of_Delivery;
c.Unit_Cheked = t.Unit_Cheked;
c.Reciept_Condition = t.Reciept_Condition;
c.Delivery_Type = t.Delivery_Type;
c.Senior_Packer_EID = t.Senior_Packer_EID;
c.Move_Coordinator = t.Move_Coordinator;
c.Project_Code = t.Project_Code;
c.Store_Id = t.Store_Id;
c.Store_Unit_Id = t.Store_Unit_Id;
return(c);
}
internal int Insert(Inv_RChallan_Temp purchase)
{
try
{
_context.Inv_RChallan_Temp.AddObject(purchase);
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
private Inv_RChallan ConvertTmpToRchallan(Inv_RChallan_Temp t)
{
Inv_RChallan c = new Inv_RChallan();
c.BalanceQty = t.BalanceQuanity;
c.Barcode = t.BarCode;
c.Brand = t.Brand;
c.ChallanDate = t.ChallanDate;
c.ChallanNo = t.ChallanNo;
c.ChallanTotal = t.ChallanTotal;
c.CompanyCode = t.CompanyCode;
c.CompanyId = t.CompanyId;
c.CompanyName = t.CompanyName;
c.CPU = t.CPU;
c.DeliveryQty = t.DeliveryQty;
c.EditDate = t.EditDate;
c.EditUser = t.EditUser;
c.FloorName = t.FloorName;
c.Id = t.Id;
c.PurchaseDate = t.PurchaseDate;
c.Ocode = t.OCode;
c.ProductGroup = t.ProductGroup;
c.ProductId = t.ProductId;
c.ProductName = t.ProductName;
c.ReceiveQuantity = t.ReceiveQuantity;
c.Remarks = t.Item_Remarks;
c.RPU = t.RPU;
c.ExpireDate = t.ExpireDate;
c.StyleSize = t.StyleSize;
c.FloorName = t.FloorName;
c.SupplierCode = t.SupplierCode;
c.SupplierId = t.SupplierId;
c.SupplierReturnQty = t.SupplierReturnQty;
c.UnitName = t.UnitName;
c.OrderNo = t.OrderNo;
// if neeeded
//c.VailPerPack = t.VailPerPack;
//c.TestPerVail = t.TestPerVail;
//c.TotalVailQty = t.TotalVailQty;
//c.BalanceStatus = t.BalanceStatus;
return(c);
}
internal int UpdateInv_MRRRChallan_Temp(string ChallanNo, int Id, Inv_RChallan_Temp purchase)
{
try
{
Inv_RChallan_Temp RchallanObj = _context.Inv_RChallan_Temp.First(x => x.ChallanNo == ChallanNo && x.Id == Id);
RchallanObj.ProductGroup = purchase.ProductGroup;
RchallanObj.ProductId = purchase.ProductId;
RchallanObj.ProductName = purchase.ProductName;
RchallanObj.ReceiveQuantity = purchase.ReceiveQuantity;
RchallanObj.ActualQty = purchase.ActualQty;
RchallanObj.Free_Qty = purchase.Free_Qty;
RchallanObj.Actual_Amount = purchase.Actual_Amount;
RchallanObj.FreeQty_Amount = purchase.FreeQty_Amount;
RchallanObj.UnitName = purchase.UnitName;
RchallanObj.Brand = purchase.Brand;
RchallanObj.FrmCurrency = purchase.FrmCurrency;
RchallanObj.CPU = purchase.CPU;
RchallanObj.TotalPrice = purchase.TotalPrice;
RchallanObj.ToCurrency = purchase.ToCurrency;
RchallanObj.Rate = purchase.Rate;
RchallanObj.TotalAppCost = purchase.TotalAppCost;
RchallanObj.Store_Code = purchase.Store_Code;
RchallanObj.SupplierCode = purchase.SupplierCode;
RchallanObj.RefNo_ChallanNo = purchase.RefNo_ChallanNo;
RchallanObj.SeasonID = purchase.SeasonID;
RchallanObj.OrderEId = purchase.OrderEId;
RchallanObj.MasterLCNo = purchase.MasterLCNo;
RchallanObj.PI_No = purchase.PI_No;
RchallanObj.B2BLCNo = purchase.B2BLCNo;
RchallanObj.BarCode = purchase.BarCode;
RchallanObj.BalanceQuanity = purchase.BalanceQuanity;
RchallanObj.PurchaseDate = purchase.PurchaseDate;
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
internal int Insert(Inv_RChallan_Temp purchase)
{
return(rChallanDal.Insert(purchase));
}
internal int UpdateInv_MRRRChallan_Temp(string ChallanNo, int Id, Inv_RChallan_Temp purchase)
{
return(rChallanDal.UpdateInv_MRRRChallan_Temp(ChallanNo, Id, purchase));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (btnSubmit.Text == "Add")
{
if (txtReceiveQty.Text == string.Empty || txtCPU.Text == string.Empty)
{
return;
}
SerialNo = SerialNo + 1;
Inv_RChallan_Temp purchase = new Inv_RChallan_Temp();
purchase.Id = SerialNo;
//foreach (DataRow dr in stCompany.Rows)
//{
// purchase.CompanyId = int.Parse(dr["CompanyId"].ToString());
// purchase.CompanyName = dr["CompanyName"].ToString();
// purchase.CompanyCode = dr["CompanyCode"].ToString();
//}
purchase.CompanyCode = ddlStore.SelectedValue.ToString();
purchase.CompanyName = GetCompanyNameByCode(purchase.CompanyCode);
purchase.CompanyId = int.Parse(GetCompanyIdByCode(ddlStore.SelectedValue.ToString()));
purchase.ChallanNo = txtChallanNo.Text.Trim();
purchase.ChallanDate = DateTime.Parse(txtDate.Text);
purchase.ProductId = int.Parse(ddlProductName.SelectedValue.ToString());//Convert.ToInt32(txtProductId.Text.Trim());
//purchase.Barcode = buyCentralBll.GetBarcode(int.Parse(purchase.ProductId.ToString()));
purchase.BarCode = txtbarcode.Text;
purchase.ProductGroup = int.Parse(ddlProductGroup.SelectedValue.ToString());
string pronductNameandBrand = ddlProductName.SelectedItem.ToString();
string[] values = pronductNameandBrand.Split('-');
purchase.ProductName = values[0].ToString();
purchase.UnitName = txtUnit.Text;
purchase.Brand = hdnBrand.Value;
purchase.StyleSize = hdnStyle.Value;
purchase.FloorName = txtFloorName.Text;
//purchase.StyleSize = txtStyleSize.Text;
purchase.DamageQty = 0;
purchase.DeliveryQty = 0;
purchase.SupplierReturnQty = 0;
purchase.OrderNo = txtOrderNo.Text;
try
{
purchase.PurchaseDate = DateTime.Parse(txtDate.Text);
}
catch
{
purchase.PurchaseDate = DateTime.Today;
}
purchase.ReceiveQuantity = Convert.ToInt32(txtReceiveQty.Text.Trim());
//if (chkBalanceStatus.Checked)
// purchase.BalanceStatus = "OpeningBalance";
//else
// purchase.BalanceStatus = "MRR";
decimal CPU = Convert.ToDecimal(txtCPU.Text.Trim());
purchase.CPU = CPU;
//if (txtRPU.Text == string.Empty)
//{
// purchase.RPU = Convert.ToInt32(float.Parse(txtCPU.Text));
//}
//else
//{
// purchase.RPU = Convert.ToInt32(float.Parse(txtRPU.Text));
//}
purchase.BalanceQuanity = Convert.ToInt32(txtBalanceQty.Text.Trim()) + purchase.ReceiveQuantity;
//purchase.SupplierId = 0; // obsolete; no longer used
purchase.SupplierCode = ddlSupplier.SelectedValue.ToString(); // identity of the supplier
purchase.EditDate = DateTime.Now;
purchase.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
purchase.OCode = OCODE;
//purchase.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
//purchase.Ocode = "8989";
var RChalan = rChallanBll.GetDataByInv_RChallan_Temp(txtChallanNo.Text, txtbarcode.Text, OCODE).ToList();
double ReceiveQty = Convert.ToDouble(txtReceiveQty.Text);
if (RChalan.Count > 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already in The List')", true);
return;
//var update = rChallanBll.UpdateInv_RChallan_Temp(txtChallanNo.Text, txtbarcode.Text, ReceiveQty, CPU);
//if (update == 1)
//{
// ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true);
// BindPurchaseGrid(txtChallanNo.Text.Trim());
// ClearProduct();
// return;
//}
//else
//{
//}
}
rChallanBll.Insert(purchase);
BindPurchaseGrid(purchase.ChallanNo);
ClearProduct();
//lblMessage.Text = "<font color='green'>Purchase information has been added temporarily. Please post.</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information has been added temporarily. Please post.')", true);
}
else
{
if (btnSubmit.Text == "Update")
{
double ReceiveQty = Convert.ToDouble(txtReceiveQty.Text);
decimal CPU = Convert.ToDecimal(txtCPU.Text.Trim());
decimal total = Convert.ToDecimal(txtTotalCost.Text.Trim());
var update = rChallanBll.UpdateInv_RChallan_Temp(txtChallanNo.Text, txtbarcode.Text, ReceiveQty);
if (update == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true);
BindPurchaseGrid(txtChallanNo.Text.Trim());
ClearProduct();
//lblTotal.Visible = true;
btnSubmit.Text = "Add";
return;
}
else
{
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
//private string GetCompanyCodeById(int Id)
//{
// return companyBll.GetCompanyCodeById(Id);
//}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (txtReceiveQty.Text == string.Empty || txtCPU.Text == string.Empty)
{
return;
}
SerialNo = SerialNo + 1;
Inv_RChallan_Temp purchase = new Inv_RChallan_Temp();
purchase.Id = SerialNo;
foreach (DataRow dr in stCompany.Rows)
{
purchase.CompanyId = int.Parse(dr["CompanyId"].ToString());
purchase.CompanyName = dr["CompanyName"].ToString();
purchase.CompanyCode = dr["CompanyCode"].ToString();
}
//purchase.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue);
//purchase.CompanyName = txtCompanyName.Text.Trim();
//purchase.CompanyCode = GetCompanyCodeById(int.Parse(purchase.CompanyId.ToString()));
purchase.ChallanNo = txtChallanNo.Text.Trim();
purchase.ChallanDate = DateTime.Parse(txtDate.Text);
purchase.ProductId = int.Parse(ddlProductName.SelectedValue.ToString());//Convert.ToInt32(txtProductId.Text.Trim());
//purchase.Barcode = buyCentralBll.GetBarcode(int.Parse(purchase.ProductId.ToString()));
purchase.BarCode = purchase.ProductId.ToString();
purchase.ProductGroup = int.Parse(ddlProductGroup.SelectedValue.ToString());
string productNameandBrand = ddlProductName.SelectedItem.ToString();
string[] values = productNameandBrand.Split(' ', '-');
purchase.ProductName = values[0].ToString();
purchase.UnitName = txtUnit.Text;
purchase.Brand = hdnBrand.Value;
purchase.StyleSize = hdnStyle.Value;
purchase.DamageQty = 0;
purchase.DeliveryQty = 0;
purchase.SupplierReturnQty = 0;
purchase.Item_Remarks = txtRemarks.Text;
try
{
purchase.PurchaseDate = DateTime.Parse(txtDate.Text);
}
catch
{
purchase.PurchaseDate = DateTime.Today;
}
purchase.ReceiveQuantity = Convert.ToInt32(txtReceiveQty.Text.Trim());
//if (chkBalanceStatus.Checked)
// purchase.BalanceStatus = "OpeningBalance";
//else
// purchase.BalanceStatus = "MRR";
purchase.CPU = Convert.ToDecimal(txtCPU.Text.Trim());
//if (txtRPU.Text == string.Empty)
//{
// purchase.RPU = Convert.ToInt32(float.Parse(txtCPU.Text));
//}
//else
//{
// purchase.RPU = Convert.ToInt32(float.Parse(txtRPU.Text));
//}
//decimal balanceQty = Convert.ToDecimal(txtBalanceQty.Text);
//string[] value = balanceQty.ToString().Split('-');
//decimal result = Convert.ToDecimal(value[0]);
//purchase.BalanceQty = Convert.ToDecimal(result) + purchase.ReceiveQuantity;
purchase.BalanceQuanity = Convert.ToDouble(txtBalanceQty.Text);
purchase.SupplierId = 0; // obsolete; no longer used
purchase.SupplierCode = ddlSupplier.SelectedValue.ToString(); // identity of the supplier
purchase.EditDate = DateTime.Now;
purchase.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
purchase.OCode = ((SessionUser)Session["SessionUser"]).OCode;
//purchase.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
//purchase.Ocode = "8989";
purchase.Item_Remarks = txtItemRemarks.Text;
purchase.PO_No = txtPONo.Text;
purchase.Mode_Of_Delivery = ddlModeofDelivery.SelectedItem.Text;
purchase.Unit_Cheked = ddlUMCheckedCondition.SelectedItem.Text;
purchase.Reciept_Condition = ddlRecieptCondition.SelectedItem.Text;
purchase.Delivery_Type = ddlDelivery.SelectedItem.Text;
purchase.Senior_Packer_EID = ddlSrpacker.SelectedValue;
purchase.Move_Coordinator = txtMoveOrdinator.Text;
purchase.Project_Code = ddlProject.SelectedValue;
purchase.Store_Id = Convert.ToInt16(ddlStoreName.SelectedValue);
purchase.Store_Unit_Id = Convert.ToInt16(ddlStoreUnit.SelectedValue);
rChallanBll.Insert(purchase);
BindPurchaseGrid(purchase.ChallanNo);
ClearProduct();
//lblMessage.Text = "<font color='green'>Purchase information has been added temporarily. Please post.</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information has been added temporarily. Please post.')", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
