protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Load_Data_Grid();
load_dropdown();
SaleInvoice s = new SaleInvoice();
tblSaleInvoice salesinvoice = new tblSaleInvoice();
int maxid = s.GetId();
lblInvoiceNo.Text = (maxid + 1).ToString();
}
}
public bool Add(tblSaleInvoice obj)
{
try
{
repository.tblSaleInvoices.Add(obj);
repository.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Delete(int id)
{
try
{
tblSaleInvoice result = Get(id);
if (result != null)
{
result.Deleted = true;
repository.SaveChanges();
return(true);
}
return(false);
}
catch (Exception)
{
return(false);
}
}
public bool Update(tblSaleInvoice obj)
{
try
{
tblSaleInvoice result = Get(obj.InvoiceId);
if (result != null)
{
repository.Entry(result).CurrentValues.SetValues(obj);
repository.SaveChanges();
return(true);
}
return(false);
}
catch (Exception)
{
return(false);
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue == "0")
{
this.ShowErrorNotification("Please select proper id");
}
else
{
Load_Data_Grid();
lblCustName.Visible = true;
gridProduct1.Visible = true;
lblTotal1.Visible = true;
txtDiscount1.Visible = true;
txtTax1.Visible = true;
lblNetTotal1.Visible = true;
SaleInvoice repository = new SaleInvoice();
tblSaleInvoice saleInvoice = repository.Get(Convert.ToInt32(DropDownList1.SelectedValue));
Customer c = new Customer();
tblCustomer cust = c.Get(saleInvoice.CustomerId);
lblCustName.Text = cust.Firstname + " " +cust.Lastname;
lblTotal1.Text= saleInvoice.TotalSale.ToString();
txtTax1.Text= saleInvoice.Tax.ToString();
txtDiscount1.Text=saleInvoice.Discount.ToString();
lblNetTotal1.Text=saleInvoice.NetSale.ToString();
SaleInvoiceDetail repo = new SaleInvoiceDetail();
tblSaleInvoiceDetail sid = new tblSaleInvoiceDetail();
IEnumerable<tblSaleInvoiceDetail> enume= repo.GetOnInvoiceId(Convert.ToInt32(saleInvoice.InvoiceId));
var enumer= enume.GetEnumerator();
while (enumer.MoveNext())
{
int rowindex = enumer.Current.ProductId - 1;
CheckBox cb = (CheckBox)gridProduct1.Rows[rowindex].FindControl("chkbox1");
cb.Checked = true;
TextBox txt = (TextBox)gridProduct1.Rows[rowindex].FindControl("txtQuantity");
txt.Visible = true;
txt.Text = enumer.Current.Quantity.ToString();
}
total = Convert.ToDouble(lblTotal1.Text);
}
}
public bool Bulk_Insert(tblSaleInvoice order, List <tblSaleInvoiceDetail> orderDetails)
{
try
{
foreach (var item in orderDetails)
{
order.tblSaleInvoiceDetails.Add(item);
}
repository.tblSaleInvoices.Add(order);
repository.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public SavingResult SaveRecord(SaleInvoiceViewModel ViewModel)
{
SavingResult res = new SavingResult();
using (dbUltraCoralEntities db = new dbUltraCoralEntities())
{
if (ViewModel.SaleInvoiceID != 0 && CheckDuplicate(ViewModel.SaleInvoiceID, ViewModel.InvoiceNo))
{
res.ExecutionResult = eExecutionResult.ValidationError;
res.ValidationError = "Can not accept duplicate values. The Cultivation Type name is already exists.";
return(res);
}
else
{
//var x = from p in db.tblProducts
// join ps in db.tblProductSizes on p.SizeID equals ps.ProductSizeID
// join vm in ViewModel.Products on p.ProductID equals vm.ProductID
// where (ps.QuanReq ?? false) == true && vm.Qty == 0
// select new { count = 1 };
if (ViewModel.Products.Count(r => r.IsQtyReq && r.Qty == 0) > 0)
{
res.ExecutionResult = eExecutionResult.ValidationError;
res.ValidationError = "Please enter quantity in per plyp and per head size products.";
return(res);
}
}
tblSaleInvoice SaveModel = null;
if (ViewModel.SaleInvoiceID == 0)
{
SaveModel = new tblSaleInvoice()
{
InvoiceNo = GenerateNextInvoiceNo(db),
rcdt = DateTime.Now,
rcuid = Common.Props.LoginUser.UserID
};
db.tblSaleInvoices.Add(SaveModel);
//if((ViewModel.SaleOrderID ?? 0) != 0)
//{
// tblSaleOrder SaleOrder = db.tblSaleOrders.Find(ViewModel.SaleOrderID);
// SaleOrder.tblSaleInvoice = SaveModel;
// db.tblSaleOrders.Attach(SaleOrder);
// db.Entry(SaleOrder).State = System.Data.Entity.EntityState.Modified;
//}
}
else
{
SaveModel = db.tblSaleInvoices.FirstOrDefault(r => r.SaleInvoiceID == ViewModel.SaleInvoiceID);
if (SaveModel == null)
{
res.ExecutionResult = eExecutionResult.ValidationError;
res.ValidationError = "Selected user has been deleted over network. Can not find user's details. Please retry.";
return(res);
}
SaveModel.redt = DateTime.Now;
SaveModel.reuid = Common.Props.LoginUser.UserID;
db.tblSaleInvoices.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
foreach (tblSaleInvoiceProductDetail SIPD in SaveModel.tblSaleInvoiceProductDetails)
{
tblProduct Product = db.tblProducts.Find(SIPD.ProductID);
if (Product != null)
{
Product.CurrentStock += SIPD.Quan;
db.tblProducts.Attach(Product);
db.Entry(Product).State = System.Data.Entity.EntityState.Modified;
}
}
db.tblSaleInvoiceProductDetails.RemoveRange(db.tblSaleInvoiceProductDetails.Where(r => r.SaleInvoiceID == ViewModel.SaleInvoiceID));
}
//SaveModel.SaleOrderID = ViewModel.SaleOrderID;
SaveModel.InvoiceDate = ViewModel.InvoiceDate;
SaveModel.InvoiceNo = ViewModel.InvoiceNo;
SaveModel.SaleInvoiceStatusID = ViewModel.SaleInvoiceStatusID;
SaveModel.CustomerID = ViewModel.CustomerID;
SaveModel.BusinessName = ViewModel.BusinessName;
SaveModel.ContactName = ViewModel.ContactName;
SaveModel.Address = ViewModel.Address;
SaveModel.City = ViewModel.City;
SaveModel.Postcode = ViewModel.Postcode;
SaveModel.Country = ViewModel.Country;
SaveModel.IntPhoneNo = ViewModel.IntPhoneNo;
SaveModel.EmailContact = ViewModel.EMailContact;
SaveModel.AirportDestCity = ViewModel.AirportDestCity;
SaveModel.ShippingDate = ViewModel.ShippingDate;
SaveModel.ArrivalDate = ViewModel.ArrivalDate;
SaveModel.DomesticFlight = ViewModel.DomesticFlight;
SaveModel.InternationalFlight = ViewModel.InternationalFlight;
//SaveModel.EstDelDate = ViewModel.EstDelDate;
//SaveModel.FreightAWBNo = ViewModel.AWBNo;
//SaveModel.FreightAWBNo = ViewModel.AWBNo ?? "";
//SaveModel.FreightFlight1 = ViewModel.Flight1 ?? "";
//SaveModel.FreightFlight2 = ViewModel.Flight2 ?? "";
SaveModel.TotalQuan = (ViewModel.Products.Sum(r => (decimal?)r.Qty) ?? 0);
SaveModel.TotalGAmt = (ViewModel.Products.Sum(r => (decimal?)r.Amt) ?? 0);
SaveModel.EstBoxes = ViewModel.EstBoxes;
SaveModel.BoxCharges = ViewModel.BoxCharges;
SaveModel.DomesticFreightCharges = ViewModel.DomesticFreightCharges;
SaveModel.IntFreightCharges = ViewModel.IntFreightCharges;
SaveModel.TTFee = ViewModel.TTFee;
SaveModel.TotalFreight = ViewModel.TotalFreight;
SaveModel.PreviousCredit = ViewModel.PreviousCredit;
SaveModel.TotalPayableAmt = ViewModel.TotalPayableAmt;
foreach (SaleInvoiceProducDetailViewModel rp in ViewModel.Products.Where(r => r.Qty != 0))
{
SaveModel.tblSaleInvoiceProductDetails.Add(new tblSaleInvoiceProductDetail()
{
//tblSaleInvoice = SaveModel,
ProductID = rp.ProductID,
Rate = rp.Rate,
Quan = rp.Qty,
Amt = rp.Amt
});
tblProduct Product = db.tblProducts.Find(rp.ProductID);
if (Product != null)
{
Product.CurrentStock -= rp.Qty;
db.tblProducts.Attach(Product);
db.Entry(Product).State = System.Data.Entity.EntityState.Modified;
}
}
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.SaleInvoiceID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
ex = Common.Functions.FindFinalError(ex);
res.ExecutionResult = eExecutionResult.ErrorWhileExecuting;
res.Exception = ex;
}
}
return(res);
}
