public async Task <IActionResult> Create([Bind("Id,Gst,Sgst,Cgst,Igst,Comment,Name")] TblGst tblGst)
{
if (ModelState.IsValid)
{
_context.Add(tblGst);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblGst));
}
public async Task <IActionResult> Create([Bind("Id,DisplayName,Icon,Type,Ordinal,Path,ParentId,IsEnable")] TblMenu tblMenu)
{
if (ModelState.IsValid)
{
_context.Add(tblMenu);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblMenu));
}
public async Task <IActionResult> Create([Bind("ItemTypeId,ItemType")] TblItemType tblItemType)
{
if (ModelState.IsValid)
{
_context.Add(tblItemType);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblItemType));
}
public async Task <IActionResult> Create([Bind("Id,TableName,PreFix,RecordCount")] TblSequence tblSequence)
{
if (ModelState.IsValid)
{
_context.Add(tblSequence);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblSequence));
}
public async Task <IActionResult> Create([Bind("Id,Mode,Type,IsVisible")] TblPaymentMode tblPaymentMode)
{
if (ModelState.IsValid)
{
_context.Add(tblPaymentMode);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblPaymentMode));
}
public async Task <IActionResult> Create([Bind("MeasurintUnitId,MeasuringUnits")] TblItemUnits tblItemUnits)
{
if (ModelState.IsValid)
{
_context.Add(tblItemUnits);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblItemUnits));
}
public async Task <IActionResult> Create([Bind("AutoId,Id,PaymentDate,PartyName,Amount,PaymentMode,Remark,CreatedDatetime")] TblPayment tblPayment)
{
if (ModelState.IsValid)
{
_context.Add(tblPayment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PartyName"] = new SelectList(_context.TblVendor, "Id", "Id", tblPayment.PartyName);
return(View(tblPayment));
}
public async Task <IActionResult> Create([Bind("AutoId,Id,StockType,PurchaseId,SaleId,InvoiceNo,ItemId,Qty,PricePerUnit,ItemwiseDiscount,PricePerUnitAfterDiscount,TotalPriceBeforeTax,Sgst,Cgst,Igst,Gst,TotalPriceAfterTax,Mrp,ManufactureDate,Expirydate,BatchNo,CreatedDatetime")] TblItemStock tblItemStock)
{
if (ModelState.IsValid)
{
_context.Add(tblItemStock);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ItemId"] = new SelectList(_context.TblItems, "Id", "Id", tblItemStock.ItemId);
ViewData["PurchaseId"] = new SelectList(_context.TblPurchase, "Id", "Id", tblItemStock.PurchaseId);
ViewData["SaleId"] = new SelectList(_context.TblSale, "SaleId", "SaleId", tblItemStock.SaleId);
return(View(tblItemStock));
}
public async Task <IActionResult> Create([Bind("AutoId,Id,VendorId,PurchaseId,SalesId,EntryId,EntryDate,EntryType,Amount,Status,CreatedDatetime,TransactionType,TransactionRef,PaymentId")] TblTransaction tblTransaction)
{
if (ModelState.IsValid)
{
_context.Add(tblTransaction);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PaymentId"] = new SelectList(_context.TblPayment, "Id", "Id", tblTransaction.PaymentId);
ViewData["PurchaseId"] = new SelectList(_context.TblPurchase, "Id", "Id", tblTransaction.PurchaseId);
ViewData["SalesId"] = new SelectList(_context.TblSale, "SaleId", "SaleId", tblTransaction.SalesId);
ViewData["VendorId"] = new SelectList(_context.TblVendor, "Id", "Id", tblTransaction.VendorId);
return(View(tblTransaction));
}
public async Task <IActionResult> Create(
[Bind(
"AutoId,SaleId,InvoiceId,InvoiceDate,CustomerId,DiscountAfterTax,OtherChargeAfterTax,SubTotal,Tax,TotalValueafterTax,RoundOff,GrandTotal,CreatedDatetime,ReverseCharge,Remark")]
TblSale tblSale)
{
if (ModelState.IsValid)
{
_context.Add(tblSale);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CustomerId"] = new SelectList(_context.TblVendor, "Id", "Name", tblSale.CustomerId);
return(View(tblSale));
}
public async Task <IActionResult> Create(
[Bind(
"Id,PartyInvoiceDate,PurchaseDate,PartyInvoiceNo,PartyName,PaymentDueAfter,ReverseCharge,Remark,DiscountAmount,OtherCharge,TotalAmountBeforeTax,TaxAmount,TotalAmountAfterTax,RoundOff,GrandTotal,PurchaseBook,PaymentMode,ScanCopy,CreatedDatetime,Amount")]
TblPurchase tblPurchase)
{
if (ModelState.IsValid)
{
_context.Add(tblPurchase);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PartyName"] = new SelectList(_context.TblVendor, "Id", "Name", tblPurchase.PartyName);
ViewData["PaymentMode"] = new SelectList(_context.TblPaymentMode, "Id", "Mode", tblPurchase.PaymentMode);
return(View(tblPurchase));
}
public async Task <IActionResult> Create([Bind("AutoId,Id,Name,ContactPerson,ContactNo,PhoneNo,VendorType,Type,Place,Dob,Gstno,Tinno,Panno,Cinno,AdhaarNo,OpeningBalance,OpeningBalanceType,OpeningBalanceDate,CreditLimit,CreditPeriod,CreditInterestRate,DebitInterestRate,CreatedDatetime,Photo,Remark,SuretyPerson,SuretyPersonContactNo,SuretyPersonAddress")] TblVendor tblVendor)
{
if (ModelState.IsValid)
{
var saved = false;
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_context.Add(tblVendor);
if (tblVendor.VendorType == "Customer")
{
_context.UpdateNextSequence(SequenceTable.tbl_Customer);
}
else if (tblVendor.VendorType == "Supplier")
{
_context.UpdateNextSequence(SequenceTable.tbl_Supplier);
}
else
{
_context.UpdateNextSequence(SequenceTable.tbl_vendor);
}
await _context.SaveChangesAsync();
saved = true;
}
catch (Exception e)
{
throw new InvalidOperationException(e.Message);
}
finally
{
if (saved)
{
transaction.Commit();
}
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["Type"] = new SelectList(_context.TblVendorType, "Id", "Id", tblVendor.Type);
return(View(tblVendor));
}
public async Task <IActionResult> Create(
[Bind(
"Id,Name,HsnSacNo,Type,MeasuringUnit,Manufacture,BarCode,ItemUniqueDescription,Supplier,Photo,UseBatchNo,UseMfgDate,UseExpiryDate,CreatedDatetime,Gst")]
TblItems items, [Bind("OpeningStock")] int?openingStock)
{
if (ModelState.IsValid)
{
var saved = false;
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_context.Add(items);
//await _context.SaveChangesAsync();
_context.UpdateNextSequence(SequenceTable.tbl_Items);
//TblSequence NewSequenceValue = Helper.GenericHelper.GetNextUpdatedData("tbl_Items");
//_context.Entry(NewSequenceValue).State = EntityState.Modified;
//await _context.SaveChangesAsync();
if (openingStock > 0)
{
TblItemStock tbl_ItemStock = new TblItemStock()
{
Id = items.Id + "-" + Helper.GenericHelper.GetMaxValue("tbl_ItemStock") + "-1",
StockType = "IN",
InvoiceNo = "Opening Stock",
ItemId = items.Id,
Qty = openingStock,
CreatedDatetime = items.CreatedDatetime.ToString() ??
DateTime.Now.Date.ToString(CultureInfo.InvariantCulture)
};
_context.TblItemStock.Add(tbl_ItemStock);
//await _context.SaveChangesAsync();
_context.UpdateNextSequence(SequenceTable.tbl_ItemStock);
}
await _context.SaveChangesAsync();
saved = true;
}
catch (Exception e)
{
throw new InvalidOperationException(e.Message);
}
finally
{
if (saved)
{
transaction.Commit();
}
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["Gst"] = new SelectList(_context.TblGst, "Id", "Name", items.Gst);
ViewData["MeasuringUnit"] = new SelectList(_context.TblItemUnits, "MeasurintUnitId", "MeasuringUnits",
items.MeasuringUnit);
ViewData["Supplier"] = new SelectList(_context.TblVendor, "Id", "Name", items.Supplier);
ViewData["Type"] = new SelectList(_context.TblItemType, "ItemTypeId", "ItemType", items.Type);
return(View(items));
}