/// <summary>
/// Adds a purchase to the database.
/// </summary>
/// <param name="purchase">The PurchaseModel entity instance to add.</param>
/// <returns>A fully populated PurchaseModel entity instance.</returns>
public PurchaseModel Add(PurchaseModel purchase)
{
try
{
using (Context context = new Context())
{
AbstractBookModel book = context.AbstractBooks.Find(purchase.AbstractBookId);
purchase.TotalPrice = (book.DiscountPercentage / 100) * book.Price;
context.Purchases.Add(purchase);
context.SaveChanges();
return(context.Purchases.Include(p => p.AbstractBook).Include(p => p.Customer).Include(p => p.Employee).FirstOrDefault(p => p.Id == purchase.Id));
}
}
catch (Exception e)
{
logsRepository.Add(e.Message);
}
return(null);
}
private void btn_Save_Click(object sender, RoutedEventArgs e)
{
List <StockModel> newStocks = new List <StockModel>();
List <PurchaseStockModel> Stocks = lstPurchase.Items.Cast <PurchaseStockModel>().Select(x => x).ToList();
if (Stocks.Any(x => x.ProductCode > 0 && x.Quantity > 0))
{
decimal? nullval = null;
DateTime?nulldate = null;
dynamic row = new PurchaseModel(_purchaseData.PurchaseId, _purchaseData.PurchaseDate, string.IsNullOrEmpty(supplier_name.Text) ? null : _supplierCode, string.IsNullOrEmpty(purchase_cashdiscount.Text) ? nullval : Convert.ToDecimal(purchase_cashdiscount.Text), string.IsNullOrEmpty(purchase_cashdiscountDoller.Text) ? nullval : Convert.ToDecimal(purchase_cashdiscountDoller.Text), string.IsNullOrEmpty(purchase_deliveryDate.Text) ? nulldate : CommonFunctions.ParseDateToFinclave(purchase_deliveryDate.Text), string.IsNullOrEmpty(purchase_expiryDate.Text) ? nulldate : CommonFunctions.ParseDateToFinclave(purchase_expiryDate.Text)
, string.IsNullOrEmpty(purchase_cashSubChargeAmo.Text) ? nullval : Convert.ToDecimal(purchase_cashSubChargeAmo.Text)
, string.IsNullOrEmpty(_taxValue) ? nullval : Convert.ToDecimal(_taxValue), _purchaseData.CreatedBy, _purchaseData.CreatedDate, _purchaseData.CompanyCode, _purchaseData.BranchCode, _purchaseData.SuplierName);
var result = purchaseController.SaveUpdateDirectPurchase(row);
newStocks.AddRange(Stocks.Where(z => z.ProductCode > 0 && z.Quantity > 0).Select(x =>
{
return(new StockModel(x.StockId == null ? 0 : x.StockId, _purchaseData.PurchaseId.Value, x.Quantity, x.CostPrice, x.SellingPrice, x.MRP, x.Discount, x.BatchNo, x.ProductCode, null));
// newStocks.Add(stock);
}).ToList());
purchaseController.UpdateStocks(newStocks, _deletestocks);
// ConfirmationPopup form = new ConfirmationPopup((string)myResourceDictionary["purchase_updated"], header, false);
// form.ShowDialog();
Common.Notification((string)Application.Current.Resources["purchase_updated"], header, false);
ClearData();
DirectPurchase form1 = new DirectPurchase();
NavigationService.Navigate(form1);
}
else
{
ConfirmationPopup form = new ConfirmationPopup((string)Application.Current.Resources["purchase_requiredFields"], header, false);
form.ShowDialog();
// Common.ErrorNotification((string)myResourceDictionary["purchase_requiredFields"], header, false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.PreviousPage != null)
{
try
{
Label label = new Label
{
Text = "Your purchase is successful, the total price is" + Request.Form["LiteralTotal"]
};
Panel1.Controls.Add(label);
var cart = Session[User.Identity.GetUserId()] as List <Purchase>;
PurchaseModel model = new PurchaseModel();
model.MarkOrdersAsPaid(cart);
Session[User.Identity.GetUserId()] = null;
}
catch (Exception ex)
{
Literal1.Text = ex.ToString();
}
}
}
private async Task <Purchase> ModelToPurchase(PurchaseModel model)
{
logger.Debug("StorageService: converting purchase storage model to purchase");
if (model == null)
{
return(null);
}
return(new Purchase
{
Id = (int)model.Id,
Date = new DateTime(model.Timestamp),
Name = model.ProductName,
ItemCost = model.ItemCost,
TotalCost = model.TotalCost,
ItemsNumber = model.ItemsNumber,
PurchaseComment = model.Comment,
StoreComment = model.StoreComment,
PurchaseRate = model.Rate,
StoreName = model.StoreName,
IsMonthly = model.IsMonthly,
Type = await ResolveProductType(model.TypeId),
SubType = await ResolveProductSubType(model.SubTypeId)
});
}
private void lbAutoInvoice_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
lbAutoSupplierName.Visibility = Visibility.Collapsed;
if (lbAutoInvoiceNo.SelectedIndex != -1)
{
if (purchaseType == (int)CommonEnum.PurchaseTypes.PO)
{
PurchaseOrderModel purchaseOrder = new PurchaseOrderModel();
purchaseOrder = _purchaseOrder.FirstOrDefault(x => x.PurchaseId == Convert.ToInt32(lbAutoInvoiceNo.SelectedItem));
GetTotalAmount(Convert.ToInt32(lbAutoInvoiceNo.SelectedItem));
}
else
{
PurchaseModel purchase = new PurchaseModel();
purchase = _directPurchase.FirstOrDefault(x => x.PurchaseId == Convert.ToInt32(lbAutoInvoiceNo.SelectedItem));
GetTotalAmount(Convert.ToInt32(lbAutoInvoiceNo.SelectedItem));
}
GetPaidAmount(Convert.ToInt32(lbAutoInvoiceNo.SelectedItem), purchaseType);
invoiceNo_.Text = Convert.ToString(lbAutoInvoiceNo.SelectedItem);
totalAmount_.Text = Convert.ToString(TotalCostPrice);
paidAmount_.Text = Convert.ToString(PaidAmount);
pendingAmount_.Text = Convert.ToString(TotalCostPrice - PaidAmount);
}
}
public ActionResult ProcessDonation(PurchaseModel purchaseModel)
{
try
{
var contact = _contactService.Find(purchaseModel.ContactId);
_donationService.CreateDonation(new Donation
{
Currency = purchaseModel.Currency,
Customer = purchaseModel.CustomerName,
CustomerEmail = purchaseModel.CustomerEmailAddress,
DonationDescription = purchaseModel.Description,
DonatedOn = DateTime.Now,
DonationAmount = purchaseModel.Amount
}, contact);
return(Json(new { success = true }));
}
catch (Exception ex)
{
_logger.Error($"SupportController => ProcessDonation => Error: {ex.GetFullErrorMessage()}");
return(Json(new { success = false, error = ex.Message }));
}
}
public PurchaseModel GetById(int Id)
{
PurchaseModel purchaseModel = (from a in _serverContext.Purchases
select new
{
a.Id,
a.SubsidiaryLedgerAccountId,
a.PurchaseReferenceNo,
a.PurchaseDate,
a.PurchaseDueDate,
a.Description,
a.PurchaseModeOfPayment,
a.ChartOfAccountId
}).ToList()
.Where(x => x.Id == Id)
.Select(x => new PurchaseModel
{
Id = x.Id,
Vendor = new Vendor {
Value = x.SubsidiaryLedgerAccountId
},
Date = x.PurchaseDate,
DueDate = x.PurchaseDueDate,
Description = x.Description,
ReferenceNo = x.PurchaseReferenceNo,
ModeOfPayment = x.PurchaseModeOfPayment,
ChartOfAccounts = new ChartOfAccounts {
Value = x.ChartOfAccountId
},
Items = (from a in _serverContext.PurchaseDetails
join b in _serverContext.TaxRates
on a.PurchaseTaxRateId equals b.Id
select new
{
Id = a.Id,
PurchaseId = a.PurchaseId,
InventoryItem = new InventoryItem {
Value = a.PurchaseInventoryId
},
ChartOfAccountItem = new ChartOfAccountItem {
Value = a.ChartOfAccountId
},
Description = a.PurchaseDetailDescription,
Quantity = a.PurchaseQuantity,
UnitPrice = a.PurchaseUnitPrice,
TaxRateItem = new PurchaseTaxRate {
Value = a.PurchaseTaxRateId, Rate = b.Rate
}
}).ToList()
.Where(x => x.PurchaseId == Id)
.Select(x => new PurchaseItemModel
{
Id = x.Id,
InventoryItem = x.InventoryItem,
ChartOfAccountItem = x.ChartOfAccountItem,
Description = x.Description,
Quantity = x.Quantity,
UnitPrice = x.UnitPrice,
TaxRateItem = x.TaxRateItem,
Amount = Math.Round((x.Quantity * x.UnitPrice), 2).ToString("#,##0.00")
}).ToList()
}).FirstOrDefault();
return(purchaseModel);
}
protected void Page_Load(object sender, EventArgs e)
{
string Userid = Context.User.Identity.GetUserId();
Session["Userid"] = Userid;
PurchaseModel model = new PurchaseModel();
ProductModel productmodel = new ProductModel();
if (Userid != null)
{
if (!string.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int value = 1;
int quan = 0;
if (!string.IsNullOrWhiteSpace(Request.QueryString["quan"]))
{
value = Convert.ToInt32(Request.QueryString["quan"]);
}
if (!string.IsNullOrWhiteSpace(Request.QueryString["quantity"]))
{
quan = Convert.ToInt32(Request.QueryString["quantity"]);
}
Purchase cart = new Purchase
{
Quantity = value,
UsersID = Userid,
DateTime = Convert.ToString(DateTime.Now),
ProductID = id
};
int purchaseid = model.check_order_product(Userid, id);
int purchasequantity = model.check_order_quantity(Userid, id);
int purchaseproductid = model.check_order_productid(Userid, id);
available_quantity = productmodel.available_quantity_product(id);
//Session["avail_quantity"] = available_quantity;
if (value > available_quantity && available_quantity == 0 || quan > available_quantity && available_quantity == 0)
{
//MessageBox.Show("Sorry Product is Out of Stock");
string script = "alert('Sorry Product is Out of Stock');";
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);
string site = String.Format("product_detail.aspx?id={0}", id);
Response.Redirect(site);
}
else if (purchaseid == 0)
{
model.insert_purchase(cart);
}
else if (quan != 0)
{
if (quan > available_quantity)
{
string script = "alert('Quantity selected is more than Available Quantity');";
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);
}
else
{
update_quantity(purchaseid, quan);
}
}
else if (purchasequantity == available_quantity)
{
string script = "alert('Product Quantity is already equal to Available Quantity');";
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);
}
else
{
update_quantity(purchaseid, purchasequantity + 1);
}
}
else if (!string.IsNullOrWhiteSpace(Request.QueryString["del"]))
{
int id = Convert.ToInt32(Request.QueryString["del"]);
model.delete_purchase(id);
Response.Redirect("cart.aspx");
}
//else if (!string.IsNullOrWhiteSpace(Request.QueryString["pur_id"]))
//{
// int id = Convert.ToInt32(Request.QueryString["pur_id"]);
// int value = Convert.ToInt32(Request.QueryString["quan"]);
// string userId = Convert.ToString(HttpContext.Current.Session["Userid"]);
// if (value > available_quantity)
// {
// System.Windows.Forms.MessageBox.Show("Quantity selected is more than Available Quantity");
// }
// else
// {
// }
//}
}
else
{
Response.Redirect("loginPage.aspx");
}
}
public ActionResult PurchaseFoodMenu(PurchaseModel purchaseModel, string Cancel)
{
purchaseModel.SupplierList = _iDropDownService.GetSupplierList();
purchaseModel.StoreList = _iDropDownService.GetStoreList();
purchaseModel.EmployeeList = _iDropDownService.GetEmployeeList();
string purchaseMessage = string.Empty;
if (!ModelState.IsValid)
{
string errorString = this.ValidationPurchase(purchaseModel);
if (!string.IsNullOrEmpty(errorString))
{
return(Json(new { error = true, message = errorString, status = 201 }));
}
}
if (purchaseModel.PurchaseDetails != null)
{
if (purchaseModel.PurchaseDetails.Count > 0)
{
purchaseModel.InventoryType = 1;
if (purchaseModel.Id > 0)
{
int result = _iPurchaseService.UpdatePurchaseFoodMenu(purchaseModel);
if (result > 0)
{
purchaseMessage = _locService.GetLocalizedHtmlString("EditSuccss");
ClientModel clientModel = new ClientModel();
clientModel = _iPurchaseService.GetClientDetail();
_iEmailService.SendEmailToForFoodMenuPurchase(Convert.ToInt32(purchaseModel.Id), clientModel);
// if (purchaseModel.IsSendEmail)
// {
// if (!string.IsNullOrEmpty(purchaseModel.SupplierEmail))
// {
// _iEmailService.SendEmailToForFoodMenuPurchase(purchaseModel, purchaseModel.SupplierEmail);
// }
// }
}
}
else
{
//purchaseModel.Date = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset);
purchaseModel.ReferenceNo = _iPurchaseService.ReferenceNumberFoodMenu().ToString();
string result = _iPurchaseService.InsertPurchaseFoodMenu(purchaseModel);
if (result != "")
{
int purchaseId = 0;
purchaseMessage = _locService.GetLocalizedHtmlString("SaveSuccess") + " Reference No is: " + result.ToString();
ClientModel clientModel = new ClientModel();
clientModel = _iPurchaseService.GetClientDetail();
purchaseId = _iPurchaseService.GetPurchaseIdByReferenceNo(result);
_iEmailService.SendEmailToForFoodMenuPurchase(purchaseId, clientModel);
//if (purchaseModel.IsSendEmail)
//{
// if (!string.IsNullOrEmpty(purchaseModel.SupplierEmail))
// {
// _iEmailService.SendEmailToForFoodMenuPurchase(purchaseModel, clientModel);
// }
//}
}
}
}
else
{
purchaseMessage = _locService.GetLocalizedHtmlString("ValidPurchaseDetails");
return(Json(new { error = true, message = purchaseMessage, status = 201 }));
}
}
else
{
purchaseMessage = _locService.GetLocalizedHtmlString("ValidPurchaseDetails");
return(Json(new { error = true, message = purchaseMessage, status = 201 }));
}
// return View(purchaseModel);
return(Json(new { error = false, message = purchaseMessage, status = 200 }));
//return View();
}
public DataTable FillShippingAddress(PurchaseModel ObjPurchaseModel)
{
DataTable dtShippingAddress = objPurchaseDA.FillShippingAddress(ObjPurchaseModel);
return(dtShippingAddress);
}
public DataSet FillItemPurchaseRate(PurchaseModel ObjPurchaseModel)
{
DataSet ItemList = objPurchaseDA.FillItemPurchaseRate(ObjPurchaseModel);
return(ItemList);
}
public DataTable FillGistnNo(PurchaseModel ObjPurchaseModel)
{
DataTable IncomeHeadList = objPurchaseDA.FillGistnNo(ObjPurchaseModel);
return(IncomeHeadList);
}
internal DataTable SavePurchase(PurchaseModel ObjPurchaseModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPPurchaseVoucherChange";
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjPurchaseModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjPurchaseModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", ObjPurchaseModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", ObjPurchaseModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjPurchaseModel.ByCashSale);
ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjPurchaseModel.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjPurchaseModel.PartyGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjPurchaseModel.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjPurchaseModel.WareHouseID);
ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjPurchaseModel.PONo);
ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillNo", ObjPurchaseModel.PurchaseBillNo);
ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillDate", ObjPurchaseModel.PurchaseBillDate);
ClsCon.cmd.Parameters.AddWithValue("@GRNNo", ObjPurchaseModel.GRNNo);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", ObjPurchaseModel.VoucherDate);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", ObjPurchaseModel.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", ObjPurchaseModel.IDARefNo);//ida Ref No.
ClsCon.cmd.Parameters.AddWithValue("@BrokerageID", ObjPurchaseModel.BrokerageID);
ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", ObjPurchaseModel.BrokerageRate);
ClsCon.cmd.Parameters.AddWithValue("@BrokerageGSTIN", ObjPurchaseModel.BrokerageGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@BrokerageAmount", ObjPurchaseModel.BrokerageAmount);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchase", ObjPurchaseModel.DtPurchase);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseItems", ObjPurchaseModel.DtItems);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseSundries", ObjPurchaseModel.DtSundries);
ClsCon.cmd.Parameters.AddWithValue("@TblAdvanceDetail", ObjPurchaseModel.DtAdjAdvance);
ClsCon.cmd.Parameters.AddWithValue("@DeptID", ObjPurchaseModel.DeptID);
ClsCon.cmd.Parameters.AddWithValue("@SubDeptID", ObjPurchaseModel.SubDeptID);
ClsCon.cmd.Parameters.AddWithValue("@IsFinal", ObjPurchaseModel.IsFinal);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtPurchase = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtPurchase);
dtPurchase.TableName = "success";
}
catch (Exception)
{
dtPurchase = new DataTable();
dtPurchase.TableName = "error";
return(dtPurchase);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtPurchase);
}
private void AddPurchaseStock(SqlTransaction trans, PurchaseModel model, string modifyStockAction)
{
this.UpdatePurchaseplanStockDataSource();
DataTable dataTable = this.ViewState["resource"] as DataTable;
if (modifyStockAction == "add")
{
DataRow[] array = dataTable.Select("pscode=" + model.pcode);
for (int i = 0; i < array.Length; i++)
{
DataRow dataRow = array[i];
ModifyStockModel modifyStockModel = new ModifyStockModel();
modifyStockModel.Id = Guid.NewGuid().ToString();
modifyStockModel.ModifyId = this.hfldModifyId.Value.Trim();
if (!string.IsNullOrEmpty(dataRow["psid"].ToString()))
{
modifyStockModel.PurchaseId = dataRow["psid"].ToString();
}
else
{
modifyStockModel.PurchaseId = Guid.NewGuid().ToString();
}
modifyStockModel.Scode = dataRow["ResourceCode"].ToString();
modifyStockModel.Pscode = dataRow["pscode"].ToString();
modifyStockModel.Quantity = Convert.ToDecimal(dataRow["number"]);
modifyStockModel.Sprice = Convert.ToDecimal(dataRow["sprice"]);
modifyStockModel.Corp = dataRow["corp"].ToString();
if (dataRow["ArrivalDate"] != DBNull.Value)
{
modifyStockModel.ArrivalDate = new DateTime?(Convert.ToDateTime(dataRow["ArrivalDate"]));
}
else
{
modifyStockModel.ArrivalDate = null;
}
this.modifyStock.Add(trans, modifyStockModel);
}
return;
}
if (modifyStockAction == "edit")
{
DataRow[] array2 = dataTable.Select("pscode=" + model.pcode + "and ModifyStockId<>''");
for (int j = 0; j < array2.Length; j++)
{
DataRow dataRow2 = array2[j];
ModifyStockModel modifyStockModel2 = new ModifyStockModel();
modifyStockModel2.Id = dataRow2["ModifyStockId"].ToString();
modifyStockModel2.ModifyId = this.hfldModifyId.Value.Trim();
modifyStockModel2.PurchaseId = dataRow2["psid"].ToString();
modifyStockModel2.Pscode = dataRow2["pscode"].ToString();
modifyStockModel2.Quantity = Convert.ToDecimal(dataRow2["number"]);
modifyStockModel2.Sprice = Convert.ToDecimal(dataRow2["sprice"]);
modifyStockModel2.Corp = dataRow2["corp"].ToString();
this.modifyStock.Update(trans, modifyStockModel2);
}
if (this.ViewState["modifyStockIds"] != null)
{
List <string> ids = (List <string>) this.ViewState["modifyStockIds"];
this.modifyStock.Delete(trans, ids);
}
DataRow[] array3 = dataTable.Select("pscode=" + model.pcode);
for (int k = 0; k < array3.Length; k++)
{
DataRow dataRow3 = array3[k];
if (string.IsNullOrEmpty(dataRow3["ModifyStockId"].ToString()))
{
ModifyStockModel modifyStockModel3 = new ModifyStockModel();
modifyStockModel3.Id = Guid.NewGuid().ToString();
modifyStockModel3.ModifyId = this.hfldModifyId.Value.Trim();
modifyStockModel3.PurchaseId = Guid.NewGuid().ToString();
modifyStockModel3.Scode = dataRow3["ResourceCode"].ToString();
modifyStockModel3.Pscode = dataRow3["pscode"].ToString();
modifyStockModel3.Quantity = Convert.ToDecimal(dataRow3["number"]);
modifyStockModel3.Sprice = Convert.ToDecimal(dataRow3["sprice"]);
modifyStockModel3.Corp = dataRow3["corp"].ToString();
if (dataRow3["ArrivalDate"] != DBNull.Value)
{
modifyStockModel3.ArrivalDate = new DateTime?(Convert.ToDateTime(dataRow3["ArrivalDate"]));
}
else
{
modifyStockModel3.ArrivalDate = null;
}
this.modifyStock.Add(trans, modifyStockModel3);
}
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Logger.Info("Payment information save start.");
Dictionary <string, string> salesInfo = new Dictionary <string, string>();
int purchaseBillingID = 0;
if (toggleBilling.Checked)
{
Logger.Info("Save purchase information start.");
PurchaseModel purchaseModel = new PurchaseModel();
purchaseModel.SupplierID = Convert.ToInt32((cmbFirmName.SelectedItem as DropDown).Value);
purchaseModel.ExiseDuty = 0;
purchaseModel.GrandTotal = !String.IsNullOrEmpty(txtGrandTotal.Text) ? Convert.ToDouble(txtGrandTotal.Text) : 0;
purchaseModel.InvoiceNumber = Convert.ToInt32(txtInvoiceNo.Text);
purchaseModel.OnCredit = !String.IsNullOrEmpty(txtCreditAmount.Text) ? Convert.ToDouble(txtCreditAmount.Text) : 0;
purchaseModel.Paid = String.IsNullOrEmpty(txtPayAmount.Text) ? 0 : Convert.ToDouble(txtPayAmount.Text);
purchaseModel.SubTotal = !String.IsNullOrEmpty(txtAmount.Text) ? Convert.ToDouble(txtAmount.Text) : 0;
purchaseModel.Tax = !String.IsNullOrEmpty(txtGst.Text) ? Convert.ToDouble(txtGst.Text) : 0;
purchaseModel.Trans_Date = dtpBillingDate.Value;
purchaseBillingID = purchaseReciever.SavePurchaseInvoice(purchaseModel);
Logger.Info("Save purchase information success.");
Logger.Info("Save purchase items information start.");
foreach (BillingItemModel item in ovlItems.Objects)
{
PurchaseItemModel purchaseItemModel = new PurchaseItemModel();
purchaseItemModel.InvoiceNumber = Convert.ToInt32(txtInvoiceNo.Text);
purchaseItemModel.Price = item.Rate;
purchaseItemModel.Quantity = item.Quantity;
purchaseItemModel.PurchaseID = purchaseBillingID;
purchaseItemModel.SubItemID = Convert.ToInt32(item.ProductValue);
purchaseItemModel.Total = item.Total;
purchaseReciever.SavePurchaseItemDetails(purchaseItemModel);
}
Logger.Info("Save purchase items information success.");
}
else
{
Logger.Info("Save sales information start.");
// Save sales details
SalesModel sales = new SalesModel();
sales.CustomerID = Convert.ToInt32((cmbFirmName.SelectedItem as DropDown).Value);
sales.TransactionDate = dtpBillingDate.Value;
sales.Amount = !String.IsNullOrEmpty(txtAmount.Text) ? Convert.ToDouble(txtAmount.Text) : 0;
sales.Carton = 0;
sales.Discount = String.IsNullOrEmpty(txtRound.Text) ? 0 : Convert.ToDouble(txtRound.Text);
sales.GrandTotal = !String.IsNullOrEmpty(txtGrandTotal.Text) ? Convert.ToDouble(txtGrandTotal.Text) : 0;
sales.GST = !String.IsNullOrEmpty(txtGst.Text) ? Convert.ToDouble(txtGst.Text) : 0;
sales.OnCredit = !String.IsNullOrEmpty(txtCreditAmount.Text) ? Convert.ToDouble(txtCreditAmount.Text) : 0;
sales.Paid = String.IsNullOrEmpty(txtPayAmount.Text) ? 0 : Convert.ToDouble(txtPayAmount.Text);
sales.TransportationID = transportationModel != null ? transportationModel.TransportationID : 0;
salesInfo = salesReciever.SaveSales(sales);
Logger.Info("Save sales information success.");
Logger.Info("Save sales items information start.");
// Add sales Items details
foreach (BillingItemModel item in ovlItems.Objects)
{
SalesItemDetailsModel salesDetails = new SalesItemDetailsModel();
salesDetails.InvoiceNumber = Convert.ToInt32(salesInfo.ElementAt(1).Value);
salesDetails.SalesID = Convert.ToInt32(salesInfo.ElementAt(0).Value);
salesDetails.SubItemID = Convert.ToInt32(item.ProductValue);
salesDetails.Quantity = item.Quantity;
salesDetails.Rate = item.Rate;
salesDetails.Total = item.Total;
salesReciever.SaveSalesDetails(salesDetails);
Logger.Info(string.Format("Sales item {0} added and amount is {1}.", salesDetails.SubItemID, salesDetails.Total));
}
Logger.Info("Save sales items information success.");
if (transportationModel != null)
{
if (!String.IsNullOrEmpty(transportationModel.TEmployeeName) && !String.IsNullOrEmpty(transportationModel.TVehicleNumber))
{
Logger.Info("Save tranportation information start.");
transportationModel.SalesID = Convert.ToInt32(salesInfo.ElementAt(0).Value);
salesReciever.SaveTransportDetails(transportationModel);
Logger.Info("Save tranportation information success.");
}
}
}
if (paymentTransactionModel != null)
{
var sales = toggleBilling.Checked ? false : true;
if (paymentTransactionModel.AccountID > 0 && paymentTransactionModel.PaymentModeID > 0)
{
Logger.Info("Payment information save start.");
SalesPayment salesPayment = new SalesPayment();
salesPayment.PaymentModeID = paymentTransactionModel.PaymentModeID;
salesPayment.TransactionDetailNo = paymentTransactionModel.TransactionNumber;
salesPayment.BillingID = sales ? Convert.ToInt32(salesInfo.ElementAt(0).Value) : purchaseBillingID;
salesPayment.ToAcc = paymentTransactionModel.AccountID.ToString();
salesPayment.TransactionDate = dtpBillingDate.Value;
salesPayment.Description = paymentTransactionModel.Description;
salesPayment.InvoieType = sales ? "S" : "P";
salesReciever.SavePaymentDetails(salesPayment);
Logger.Info("Payment information save success.");
}
}
ResetItem();
ResetBillingInformation();
ResetItemList();
ResetTransportationDetails();
ResetPaymentMode();
MessageBox.Show("Billing invoice saved successfully.", "Success", MessageBoxButtons.OK);
}
catch (Exception ex)
{
Logger.Error("Error in billing invoice submit.", ex);
}
}
public DataTable FillLocation(PurchaseModel ObjPurchaseModel)
{
DataTable dtFillLocation = objPurchaseDA.Filllocation(ObjPurchaseModel);
return(dtFillLocation);
}
public DataTable FillHeadName(PurchaseModel ObjPurchaseModel)
{
DataTable dtFillHeadName = objPurchaseDA.FillHeadName(ObjPurchaseModel);
return(dtFillHeadName);
}
public DataTable SavePurchase(PurchaseModel ObjPurchaseModel)
{
DataTable dtShippingAddress = objPurchaseDA.SavePurchase(ObjPurchaseModel);
return(dtShippingAddress);
}
public DataSet FillGistnNoWithDetail(PurchaseModel ObjPurchaseModel)
{
DataSet dsFillGistnNoWithDetail = objPurchaseDA.FillGistnNoWithDetail(ObjPurchaseModel);
return(dsFillGistnNoWithDetail);
}
public DataTable LastVoucherNo(PurchaseModel ObjPurchaseModel)
{
DataTable AccHeadList = objPurchaseDA.LastVoucherNo(ObjPurchaseModel);
return(AccHeadList);
}
public DataTable LoadNarration(PurchaseModel ObjPurchaseModel)
{
DataTable NarrationList = objPurchaseDA.LoadNarration(ObjPurchaseModel);
return(NarrationList);
}
public DataSet BindAll(PurchaseModel ObjPurchaseModel)
{
DataSet dsBindAll = objPurchaseDA.BindAll(ObjPurchaseModel);
return(dsBindAll);
}
public JsonResult CancelBill(PurchaseModel purchasemodel)
{
var result = purchaseService.cancelbill(purchasemodel);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public DataSet CheckGSTIN_Number(PurchaseModel ObjPurchaseModel)
{
DataSet GSTINList = objPurchaseDA.CheckGSTIN_Number(ObjPurchaseModel);
return(GSTINList);
}
public void ClearView()
{
Purchase = new PurchaseModel();
}
public DataTable CheckBudgetHead(PurchaseModel ObjPurchaseModel)
{
DataTable AccHeadList = objPurchaseDA.CheckBudgetHead(ObjPurchaseModel);
return(AccHeadList);
}
public void Spawn(PurchaseModel purchaseModel, GameObject sectionGameObject,
ProductClickHandlerScript productClickHandlerScript)
{
WarshipPowerPointsProductModel model = purchaseModel.productModel;
int increment = model.Increment;
InGameCurrencyCostModel costModel =
ZeroFormatterSerializer.Deserialize <InGameCurrencyCostModel>(purchaseModel.productModel.CostModel
.SerializedCostModel);
//Создать объект на сцене
GameObject wppPrefab = Resources.Load <GameObject>("Prefabs/LobbyShop/Image_WarshipPowerPointsItem");
GameObject wppGo = Object.Instantiate(wppPrefab, sectionGameObject.transform, false);
//Установить название обьекта
wppGo.name += " " + increment;
//Заполнить картинку
Image itemPreview = wppGo.transform.Find("Image_WarshipPreview")
.GetComponentInChildren <Image>();
itemPreview.sprite = Resources.Load <Sprite>("SkinPreview/" + purchaseModel.productModel.PreviewImagePath);
//Заполнить текущий показатель силы
Text currentPowerValue = wppGo.transform.Find("Empty_PowerValueRoot/Text").GetComponent <Text>();
currentPowerValue.text = $"{model.SupportClientModel.StartValue}/{model.SupportClientModel.MaxValueForLevel}";
//Установить значение слайдера
Slider slider = wppGo.transform.Find("Empty_PowerValueRoot/Slider").GetComponent <Slider>();
slider.value = 1f * model.SupportClientModel.StartValue / model.SupportClientModel.MaxValueForLevel;
//Заполнить прибавку к очкам силы
Text incrementText = wppGo.transform.Find("Text").GetComponent <Text>();
// log.Debug($"increment = "+increment);
incrementText.text = $"+{increment}";
//Заполнить цену
Text itemCost = wppGo.transform.Find("Image_Cost/Text_Amount").GetComponent <Text>();
itemCost.text = costModel.Cost.ToString(CultureInfo.InvariantCulture);
var darkLayer = wppGo.transform.Find("Image_Disabled").gameObject;
darkLayer.SetActive(purchaseModel.productModel.IsDisabled);
var boughtText = wppGo.transform.Find("Image_Cost/Text_Bought").gameObject;
boughtText.SetActive(purchaseModel.productModel.IsDisabled);
var costText = wppGo.transform.Find("Image_Cost/Text_Amount").gameObject;
costText.SetActive(!purchaseModel.productModel.IsDisabled);
if (dictionary.ContainsKey(purchaseModel.productModel.Id))
{
dictionary.Remove(purchaseModel.productModel.Id);
}
dictionary.Add(purchaseModel.productModel.Id, new StubWppUi()
{
boughtText = boughtText,
costText = costText,
darkLayer = darkLayer
});
//Установить обработчик нажатия
Button itemButton = wppGo.GetComponent <Button>();
itemButton.onClick.RemoveAllListeners();
itemButton.onClick.AddListener(() =>
{
productClickHandlerScript.Product_OnClick(purchaseModel);
});
}
public DataTable ExpenseHead(PurchaseModel ObjPurchaseModel)
{
DataTable IncomeHeadList = objPurchaseDA.LoadExpenseHead(ObjPurchaseModel);
return(IncomeHeadList);
}
int UpdatePurchase(PurchaseModel purchaseModel, bool addMode)
{
Purchase purchase = null;
if (addMode)
{
purchase = new Purchase
{
SubsidiaryLedgerAccountId = purchaseModel.Vendor.Value,
PurchaseModeOfPayment = purchaseModel.ModeOfPayment,
ChartOfAccountId = purchaseModel.ModeOfPayment == "PD" ? purchaseModel.ChartOfAccounts.Value : null,
PurchaseReferenceNo = purchaseModel.ReferenceNo,
PurchaseAmount = purchaseModel.Amount,
PurchaseDate = purchaseModel.Date,
PurchaseDueDate = purchaseModel.DueDate,
Description = purchaseModel.Description,
PurchaseCreatedDate = DateTime.Now
};
_serverContext.Purchases.Add(purchase);
_serverContext.SaveChanges();
}
else
{
purchase = _serverContext.Purchases.Find(purchaseModel.Id);
purchase.SubsidiaryLedgerAccountId = purchaseModel.Vendor.Value;
purchase.PurchaseModeOfPayment = purchaseModel.ModeOfPayment;
purchase.ChartOfAccountId = purchaseModel.ModeOfPayment == "PD" ? purchaseModel.ChartOfAccounts.Value : null;
purchase.PurchaseAmount = purchaseModel.Amount;
purchase.PurchaseReferenceNo = purchaseModel.ReferenceNo;
purchase.Description = purchaseModel.Description;
purchase.PurchaseDate = purchaseModel.Date;
purchase.PurchaseDueDate = purchaseModel.DueDate;
_serverContext.SaveChanges();
}
if (!addMode)
{
foreach (var item in _serverContext.PurchaseDetails.Where(x => x.PurchaseId == purchaseModel.Id).ToList())
{
PurchaseDetail purchaseDetail = new PurchaseDetail();
purchaseDetail = _serverContext.PurchaseDetails.Find(item.Id);
if (purchaseDetail != null)
{
_serverContext.PurchaseDetails.Remove(purchaseDetail);
_serverContext.SaveChanges();
}
}
}
foreach (PurchaseItemModel item in purchaseModel.Items)
{
PurchaseDetail purchaseDetail = new PurchaseDetail();
purchaseDetail.PurchaseId = purchase.Id;
if (item.InventoryItem != null)
{
purchaseDetail.PurchaseInventoryId = item.InventoryItem.Value;
}
purchaseDetail.ChartOfAccountId = item.ChartOfAccountItem.Value;
purchaseDetail.PurchaseTaxRateId = item.TaxRateItem.Value;
purchaseDetail.PurchaseDetailDescription = item.Description;
purchaseDetail.PurchaseQuantity = item.Quantity;
purchaseDetail.PurchaseUnitPrice = item.UnitPrice;
_serverContext.PurchaseDetails.Add(purchaseDetail);
_serverContext.SaveChanges();
}
if (!addMode)
{
var tempGl = _serverContext.GeneralLedgers.Where(x => x.PurchaseId == purchaseModel.Id).SingleOrDefault();
_serverContext.GeneralLedgers.Remove(tempGl);
}
return(purchase.Id);
}
public DataTable PurchaseFrom(PurchaseModel ObjPurchaseModel)
{
DataTable dtSalesTo = objPurchaseDA.PurchaseFrom(ObjPurchaseModel);
return(dtSalesTo);
}
