public int InsertPurchaseInvoice(EntityDebitNote entPurchaseInvoice, List <EntityDebitNoteDetails> lstInvoice)
{
try
{
int?id = 0;
objData.STP_Insert_DebitNote(Convert.ToDateTime(entPurchaseInvoice.DNDate), Convert.ToInt32(entPurchaseInvoice.SupplierId), false, Convert.ToDecimal(entPurchaseInvoice.Amount), Convert.ToDecimal(entPurchaseInvoice.NetAmount), Convert.ToInt32(entPurchaseInvoice.Tax1), Convert.ToInt32(entPurchaseInvoice.Tax2), Convert.ToInt32(entPurchaseInvoice.Discount), ref id);
foreach (EntityDebitNoteDetails item in lstInvoice)
{
tblDebitNoteDetail obj = new tblDebitNoteDetail()
{
DNNo = id,
ProductCode = item.ProductCode,
Quantity = item.Quantity,
Price = item.Price,
Amount = item.Amount,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
IsDelete = false
};
tblStockDetail objStock = new tblStockDetail()
{
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
OutwardQty = item.Quantity,
OutwardPrice = item.Price,
DocumentNo = id,
IsDelete = false,
ProductId = Convert.ToInt32(item.ProductCode),
TransactionType = "DebitNote",
OutwardAmount = item.Amount
};
objData.tblStockDetails.InsertOnSubmit(objStock);
objData.tblDebitNoteDetails.InsertOnSubmit(obj);
}
int TId = new PatientInvoiceBLL().GetTransactionId();
tblCustomerTransaction objCust = new tblCustomerTransaction()
{
PayAmount = entPurchaseInvoice.NetAmount,
IsCash = false,
IsDelete = false,
SupplierId = entPurchaseInvoice.SupplierId,
ReceiptDate = entPurchaseInvoice.DNDate,
TransactionDocNo = id,
TransactionId = TId,
TransactionType = "DebitNote"
};
objData.tblCustomerTransactions.InsertOnSubmit(objCust);
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(1);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lbl.Text = "STOCK DETAIL REPORT";
lblFrom.Text = ddlProduct.SelectedItem.Text;
lblTo.Text = string.Format("{0:dd-MMM-yyyy}", DateTime.Now);
lblMessage.Text = string.Empty;
EntityProduct entPro = new CustomerTransactionBLL().GetUnitOfMeasurement(ddlProduct.SelectedValue);
lblUoM.Text = "U.O.M" + "-" + entPro.UOM;
List <tblStockDetail> lst = new CustomerTransactionBLL().GetProductTransByProductId(Convert.ToInt32(ddlProduct.SelectedValue));
tblStockDetail obj = new tblStockDetail()
{
};
lst.Add(obj);
tblStockDetail objReceived = new tblStockDetail()
{
TransactionType = "Total Inward Amount",
InwardAmount = Convert.ToDecimal(lst.Sum(p => p.InwardAmount))
};
lst.Add(objReceived);
tblStockDetail objBills = new tblStockDetail()
{
TransactionType = "Total Outward Amount",
OutwardAmount = Convert.ToDecimal(lst.Sum(p => p.OutwardAmount))
};
lst.Add(objBills);
tblStockDetail objIqty = new tblStockDetail()
{
TransactionType = "Total Inward Quntity",
InwardQty = Convert.ToInt32(lst.Sum(p => p.InwardQty))
};
lst.Add(objIqty);
tblStockDetail objOqty = new tblStockDetail()
{
TransactionType = "Total Outward Quntity",
OutwardQty = Convert.ToInt32(lst.Sum(p => p.OutwardQty))
};
lst.Add(objOqty);
tblStockDetail objFinal = new tblStockDetail()
{
TransactionType = "Balance Quntity",
InwardQty = objIqty.InwardQty - objOqty.OutwardQty
};
lst.Add(objFinal);
dgvTestParameter.DataSource = lst;
dgvTestParameter.DataBind();
Session["StockDetailsRep"] = ListConverter.ToDataTable(lst);
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
public int InsertPurchaseOrder(EntityIssueMaterial entInvoice, List <EntityIssueMaterialDetails> lstInvoice)
{
try
{
int?PO_ID = 0;
objData.STP_InsertIssueMaterial(Convert.ToDateTime(entInvoice.IssueDate), ref PO_ID, Convert.ToInt32(entInvoice.PatientId), Convert.ToDecimal(entInvoice.TotalAmount), Convert.ToInt32(entInvoice.EmpId));
foreach (EntityIssueMaterialDetails entPurchaseDetails in lstInvoice)
{
tblIssueDetail obj = new tblIssueDetail()
{
IssueId = PO_ID,
ProductId = Convert.ToInt32(entPurchaseDetails.ProductId),
Quantity = entPurchaseDetails.Quantity,
Rate = entPurchaseDetails.Rate,
Total = Convert.ToDecimal(entPurchaseDetails.Total),
IsDelete = false,
BatchNo = entPurchaseDetails.BatchNo,
ExpiryDate = entPurchaseDetails.ExpiryDate
};
objData.tblIssueDetails.InsertOnSubmit(obj);
tblStockDetail stock = new tblStockDetail()
{
ProductId = Convert.ToInt32(entPurchaseDetails.ProductId),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
BatchNo = entPurchaseDetails.BatchNo,
ExpiryDate = entPurchaseDetails.ExpiryDate,
OutwardQty = entPurchaseDetails.Quantity,
OutwardPrice = entPurchaseDetails.Rate,
OutwardAmount = entPurchaseDetails.Total,
TransactionType = "Issue",
DocumentNo = PO_ID,
};
objData.tblStockDetails.InsertOnSubmit(stock);
}
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public int?Save(tblPrescription tblins, List <EntityPrescriptionDetails> lst)
{
int?PrescriptionId = 0;
try
{
objData.STP_Insert_tblPrescription(Convert.ToInt32(tblins.AdmitId), Convert.ToInt32(tblins.DeptCategory), tblins.DeptDoctor, Convert.ToDateTime(tblins.Prescription_Date),
tblins.IsDressing, tblins.IsInjection, tblins.InjectionName, tblins.Investigation, tblins.Impression, tblins.AdviceNote, tblins.Remarks, ref PrescriptionId);
foreach (EntityPrescriptionDetails item in lst)
{
tblPrescriptionDetail tbl = new tblPrescriptionDetail()
{
ProductId = Convert.ToInt32(item.ProductId),
Morning = item.Morning,
Afternoon = item.Afternoon,
Night = item.Night,
NoOfDays = item.NoOfDays,
Quantity = item.Quantity,
Prescription_Id = Convert.ToInt32(PrescriptionId),
IsDelete = false
};
objData.tblPrescriptionDetails.InsertOnSubmit(tbl);
tblStockDetail stock = new tblStockDetail()
{
ProductId = Convert.ToInt32(item.ProductId),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
OutwardQty = Convert.ToInt32(item.Quantity),
TransactionType = "Issue",
DocumentNo = PrescriptionId,
};
objData.tblStockDetails.InsertOnSubmit(stock);
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(PrescriptionId);
}
public int Update(EntityPurchaseInvoice invoice, List<EntityPurchaseInvoiceDetails> lst)
{
int i = 0;
try
{
tblPurchaseInvoice objExistInvoice = (from tbl in objData.tblPurchaseInvoices
where tbl.IsDelete == false
&& tbl.PINo == invoice.PINo
select tbl).FirstOrDefault();
if (objExistInvoice != null)
{
bool flagISPOComplete = false;
if (invoice.PONo > 0)
{
if (objExistInvoice.PONo > 0)
{
List<tblPurchaseInvoiceDetail> lstExistedItems = (from tbl in objData.tblPurchaseInvoiceDetails
where tbl.PINo == invoice.PINo
&& tbl.IsDelete == false
select tbl).ToList();
if (lstExistedItems.Count > lst.Count)
{
foreach (tblPurchaseInvoiceDetail item in lstExistedItems)
{
int cnt = (from tbl in lst
where tbl.ProductCode == item.ProductCode
&& tbl.PurchaseInvoiceNo == item.PINo
select tbl).Count();
if (cnt == 0)
{
item.IsDelete = true;
}
tblPurchaseOrderDetail objOrder = (from tbl in objData.tblPurchaseOrderDetails
join tblPurchaseInv in objData.tblPurchaseInvoices
on tbl.PO_Id equals tblPurchaseInv.PONo
where tblPurchaseInv.PINo == item.PINo
&& tbl.IsDelete == false
&& tbl.Product_Id == item.ProductCode
select tbl).FirstOrDefault();
if (objOrder != null)
{
objOrder.InvoiceQuantity = 0;
}
}
objData.SubmitChanges();
}
#region Update Invoice Details
foreach (EntityPurchaseInvoiceDetails item in lst)
{
tblPurchaseInvoiceDetail invoiceItem = (from tbl in objData.tblPurchaseInvoiceDetails
where tbl.PINo == invoice.PINo
&& tbl.IsDelete == false
&& tbl.ProductCode == item.ProductCode
select tbl).FirstOrDefault();
if (invoiceItem != null)
{
invoiceItem.Amount = item.Amount;
invoiceItem.BatchNo = item.BatchNo;
invoiceItem.ExpiryDate = item.ExpiryDate;
invoiceItem.InvoicePrice = item.InvoicePrice;
invoiceItem.InvoiceQty = item.InvoiceQty;
invoiceItem.PINo = item.PurchaseInvoiceNo;
}
else
{
invoiceItem = new tblPurchaseInvoiceDetail()
{
PINo = invoice.PINo,
ProductCode = item.ProductCode,
InvoiceQty = item.InvoiceQty,
InvoicePrice = item.InvoicePrice,
Amount = item.Amount,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
IsDelete = false
};
objData.tblPurchaseInvoiceDetails.InsertOnSubmit(invoiceItem);
}
tblPurchaseOrderDetail orderItem = (from tbl in objData.tblPurchaseOrderDetails
where tbl.IsDelete == false
&& tbl.PO_Id == invoice.PONo
&& tbl.Product_Id == item.ProductCode
select tbl).FirstOrDefault();
if (orderItem != null)
{
if (orderItem.Quantity == item.InvoiceQty)
{
flagISPOComplete = true;
}
else
{
flagISPOComplete = false;
}
orderItem.InvoiceQuantity = item.InvoiceQty;
}
tblStockDetail stockItem = (from tbl in objData.tblStockDetails
where tbl.IsDelete == false
&& tbl.TransactionType.Equals("PInvoice")
&& Convert.ToInt32(tbl.DocumentNo) == invoice.PINo
&& tbl.ProductId == Convert.ToInt32(item.ProductCode)
select tbl).FirstOrDefault();
if (stockItem != null)
{
stockItem.ProductId = Convert.ToInt32(item.ProductCode);
stockItem.InwardQty = item.InvoiceQty;
stockItem.InwardPrice = item.InvoicePrice;
stockItem.BatchNo = item.BatchNo;
stockItem.ExpiryDate = item.ExpiryDate;
stockItem.InwardAmount = item.Amount;
}
else
{
stockItem = new tblStockDetail()
{
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
InwardPrice = item.InvoicePrice,
InwardQty = item.InvoiceQty,
DocumentNo = invoice.PINo,
IsDelete = false,
ProductId = Convert.ToInt32(item.ProductCode),
TransactionType = "PInvoice",
InwardAmount = item.Amount
};
}
}
#endregion
#region Update Status of Order and Transaction
tblCustomerTransaction transact = (from tbl in objData.tblCustomerTransactions
where tbl.SupplierId == invoice.SupplierId
&& tbl.IsDelete == false
&& tbl.TransactionDocNo == invoice.PINo
&& tbl.TransactionType.Equals("PInvoice")
select tbl).FirstOrDefault();
if (transact != null)
{
transact.BillAmount = invoice.Amount;
}
tblPurchaseOrder orderMain = (from tbl in objData.tblPurchaseOrders
where tbl.IsDelete == false
&& tbl.PO_Id == invoice.PONo
select tbl).FirstOrDefault();
if (orderMain != null)
{
if (GetPOProductForEdit(Convert.ToInt32(invoice.PONo)).Count == lst.Count)
{
flagISPOComplete = true;
}
else
{
flagISPOComplete = false;
}
orderMain.IsPOComplete = flagISPOComplete;
}
objExistInvoice.Amount = invoice.Amount;
objExistInvoice.Discount = invoice.Discount;
objExistInvoice.PIDate = invoice.PIDate;
objExistInvoice.Tax1 = invoice.Tax1;
objExistInvoice.Tax2 = invoice.Tax2;
objData.SubmitChanges();
#endregion
}
else
{
///Specifies that Current Invoice with PO
foreach (EntityPurchaseInvoiceDetails item in lst)
{
}
}
}
else if (objExistInvoice.PONo > 0)
{
List<tblPurchaseInvoiceDetail> lstExistedItems = (from tbl in objData.tblPurchaseInvoiceDetails
where tbl.PINo == invoice.PINo
&& tbl.IsDelete == false
select tbl).ToList();
if (lstExistedItems.Count > lst.Count)
{
foreach (tblPurchaseInvoiceDetail item in lstExistedItems)
{
int cnt = (from tbl in lst
where tbl.ProductCode == item.ProductCode
&& tbl.PurchaseInvoiceNo == item.PINo
select tbl).Count();
if (cnt == 0)
{
item.IsDelete = true;
}
tblPurchaseOrderDetail objOrder = (from tbl in objData.tblPurchaseOrderDetails
join tblPurchaseInv in objData.tblPurchaseInvoices
on tbl.PO_Id equals tblPurchaseInv.PONo
where tblPurchaseInv.PINo == item.PINo
&& tbl.IsDelete == false
&& tbl.Product_Id == item.ProductCode
select tbl).FirstOrDefault();
if (objOrder != null)
{
objOrder.InvoiceQuantity = 0;
}
}
objData.SubmitChanges();
}
if (invoice.PONo > 0)
{
#region Update Invoice Details
foreach (EntityPurchaseInvoiceDetails item in lst)
{
tblPurchaseInvoiceDetail invoiceItem = (from tbl in objData.tblPurchaseInvoiceDetails
where tbl.PINo == invoice.PINo
&& tbl.IsDelete == false
&& tbl.ProductCode == item.ProductCode
select tbl).FirstOrDefault();
if (invoiceItem != null)
{
invoiceItem.Amount = item.Amount;
invoiceItem.BatchNo = item.BatchNo;
invoiceItem.ExpiryDate = item.ExpiryDate;
invoiceItem.InvoicePrice = item.InvoicePrice;
invoiceItem.InvoiceQty = item.InvoiceQty;
invoiceItem.PINo = item.PurchaseInvoiceNo;
}
else
{
invoiceItem = new tblPurchaseInvoiceDetail()
{
PINo = invoice.PINo,
ProductCode = item.ProductCode,
InvoiceQty = item.InvoiceQty,
InvoicePrice = item.InvoicePrice,
Amount = item.Amount,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
IsDelete = false
};
objData.tblPurchaseInvoiceDetails.InsertOnSubmit(invoiceItem);
}
tblPurchaseOrderDetail orderItem = (from tbl in objData.tblPurchaseOrderDetails
where tbl.IsDelete == false
&& tbl.PO_Id == invoice.PONo
&& tbl.Product_Id == item.ProductCode
select tbl).FirstOrDefault();
if (orderItem != null)
{
if (orderItem.Quantity == item.InvoiceQty)
{
flagISPOComplete = true;
}
else
{
flagISPOComplete = false;
}
orderItem.InvoiceQuantity = item.InvoiceQty;
}
tblStockDetail stockItem = (from tbl in objData.tblStockDetails
where tbl.IsDelete == false
&& tbl.TransactionType.Equals("PInvoice")
&& Convert.ToInt32(tbl.DocumentNo) == invoice.PINo
&& tbl.ProductId == Convert.ToInt32(item.ProductCode)
select tbl).FirstOrDefault();
if (stockItem != null)
{
stockItem.ProductId = Convert.ToInt32(item.ProductCode);
stockItem.InwardQty = item.InvoiceQty;
stockItem.InwardPrice = item.InvoicePrice;
stockItem.BatchNo = item.BatchNo;
stockItem.ExpiryDate = item.ExpiryDate;
stockItem.InwardAmount = item.Amount;
}
else
{
stockItem = new tblStockDetail()
{
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
InwardPrice = item.InvoicePrice,
InwardQty = item.InvoiceQty,
DocumentNo = invoice.PINo,
IsDelete = false,
ProductId = Convert.ToInt32(item.ProductCode),
TransactionType = "PInvoice",
InwardAmount = item.Amount
};
}
}
#endregion
#region Update Status of PO and Transaction Update
tblCustomerTransaction transact = (from tbl in objData.tblCustomerTransactions
where tbl.SupplierId == invoice.SupplierId
&& tbl.IsDelete == false
&& tbl.TransactionDocNo == invoice.PINo
&& tbl.TransactionType.Equals("PInvoice")
select tbl).FirstOrDefault();
if (transact != null)
{
transact.BillAmount = invoice.Amount;
}
tblPurchaseOrder orderMain = (from tbl in objData.tblPurchaseOrders
where tbl.IsDelete == false
&& tbl.PO_Id == invoice.PONo
select tbl).FirstOrDefault();
if (orderMain != null)
{
if (GetPOProduct(Convert.ToInt32(invoice.PONo)).Count == lst.Count)
{
flagISPOComplete = true;
}
else
{
flagISPOComplete = false;
}
orderMain.IsPOComplete = flagISPOComplete;
}
objExistInvoice.Amount = invoice.Amount;
objExistInvoice.Discount = invoice.Discount;
objExistInvoice.PIDate = invoice.PIDate;
objExistInvoice.Tax1 = invoice.Tax1;
objExistInvoice.Tax2 = invoice.Tax2;
objData.SubmitChanges();
#endregion
}
else
{
///Specifies that Existing Invoice With PO and Current Not With PO
#region Update Invoice Details
foreach (EntityPurchaseInvoiceDetails item in lst)
{
tblPurchaseInvoiceDetail invoiceItem = (from tbl in objData.tblPurchaseInvoiceDetails
where tbl.PINo == invoice.PINo
&& tbl.IsDelete == false
&& tbl.ProductCode == item.ProductCode
select tbl).FirstOrDefault();
if (invoiceItem != null)
{
invoiceItem.Amount = item.Amount;
invoiceItem.BatchNo = item.BatchNo;
invoiceItem.ExpiryDate = item.ExpiryDate;
invoiceItem.InvoicePrice = item.InvoicePrice;
invoiceItem.InvoiceQty = item.InvoiceQty;
invoiceItem.PINo = item.PurchaseInvoiceNo;
}
else
{
invoiceItem = new tblPurchaseInvoiceDetail()
{
PINo = invoice.PINo,
ProductCode = item.ProductCode,
InvoiceQty = item.InvoiceQty,
InvoicePrice = item.InvoicePrice,
Amount = item.Amount,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
IsDelete = false
};
objData.tblPurchaseInvoiceDetails.InsertOnSubmit(invoiceItem);
}
tblPurchaseOrderDetail orderItem = (from tbl in objData.tblPurchaseOrderDetails
where tbl.IsDelete == false
&& tbl.PO_Id == objExistInvoice.PONo
&& tbl.Product_Id == item.ProductCode
select tbl).FirstOrDefault();
if (orderItem != null)
{
orderItem.InvoiceQuantity = 0;
}
tblStockDetail stockItem = (from tbl in objData.tblStockDetails
where tbl.IsDelete == false
&& tbl.TransactionType.Equals("PInvoice")
&& Convert.ToInt32(tbl.DocumentNo) == invoice.PINo
&& tbl.ProductId == Convert.ToInt32(item.ProductCode)
select tbl).FirstOrDefault();
if (stockItem != null)
{
stockItem.ProductId = Convert.ToInt32(item.ProductCode);
stockItem.InwardQty = item.InvoiceQty;
stockItem.InwardPrice = item.InvoicePrice;
stockItem.BatchNo = item.BatchNo;
stockItem.ExpiryDate = item.ExpiryDate;
stockItem.InwardAmount = item.Amount;
}
else
{
stockItem = new tblStockDetail()
{
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
InwardPrice = item.InvoicePrice,
InwardQty = item.InvoiceQty,
DocumentNo = invoice.PINo,
IsDelete = false,
ProductId = Convert.ToInt32(item.ProductCode),
TransactionType = "PInvoice",
InwardAmount = item.Amount
};
}
}
#endregion
#region Update Status of PO and Transaction Update
tblCustomerTransaction transact = (from tbl in objData.tblCustomerTransactions
where tbl.SupplierId == invoice.SupplierId
&& tbl.IsDelete == false
&& tbl.TransactionDocNo == invoice.PINo
&& tbl.TransactionType.Equals("PInvoice")
select tbl).FirstOrDefault();
if (transact != null)
{
transact.BillAmount = invoice.Amount;
}
tblPurchaseOrder orderMain = (from tbl in objData.tblPurchaseOrders
where tbl.IsDelete == false
&& tbl.PO_Id == objExistInvoice.PONo
select tbl).FirstOrDefault();
if (orderMain != null)
{
orderMain.IsPOComplete = false;
}
objExistInvoice.Amount = invoice.Amount;
objExistInvoice.Discount = invoice.Discount;
objExistInvoice.PIDate = invoice.PIDate;
objExistInvoice.Tax1 = invoice.Tax1;
objExistInvoice.Tax2 = invoice.Tax2;
objExistInvoice.PONo = invoice.PONo;
objData.SubmitChanges();
#endregion
}
}
}
i++;
}
catch (Exception ex)
{
i = 0;
throw ex;
}
return i;
}
public int InsertPurchaseInvoice(EntityPurchaseInvoice entPurchaseInvoice, List<EntityPurchaseInvoiceDetails> lstInvoice)
{
try
{
int? id = 0;
bool flagISPOComplete = false;
objData.STP_Insert_PurchaseInvoice(Convert.ToDateTime(entPurchaseInvoice.PIDate), Convert.ToInt32(entPurchaseInvoice.PONo), Convert.ToInt32(entPurchaseInvoice.SupplierId), false, Convert.ToDecimal(entPurchaseInvoice.Amount), Convert.ToInt32(entPurchaseInvoice.Tax1), Convert.ToInt32(entPurchaseInvoice.Tax2), Convert.ToInt32(entPurchaseInvoice.Discount), ref id);
foreach (EntityPurchaseInvoiceDetails item in lstInvoice)
{
tblPurchaseInvoiceDetail obj = new tblPurchaseInvoiceDetail()
{
PINo = id,
ProductCode = item.ProductCode,
InvoiceQty = item.InvoiceQty,
InvoicePrice = item.InvoicePrice,
Amount = item.Amount,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
IsDelete = false
};
tblPurchaseOrderDetail orderItem = (from tbl in objData.tblPurchaseOrderDetails
where tbl.IsDelete == false
&& tbl.PO_Id == entPurchaseInvoice.PONo
&& tbl.Product_Id == item.ProductCode
select tbl).FirstOrDefault();
if (orderItem != null)
{
if (orderItem.Quantity == item.InvoiceQty)
{
flagISPOComplete = true;
}
else
{
flagISPOComplete = false;
}
orderItem.InvoiceQuantity = item.InvoiceQty;
}
tblStockDetail objStock = new tblStockDetail()
{
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
InwardPrice = item.InvoicePrice,
InwardQty = item.InvoiceQty,
DocumentNo = id,
IsDelete = false,
ProductId = Convert.ToInt32(item.ProductCode),
TransactionType = "PInvoice",
InwardAmount = item.Amount
};
objData.tblStockDetails.InsertOnSubmit(objStock);
objData.tblPurchaseInvoiceDetails.InsertOnSubmit(obj);
}
int TId = new PatientInvoiceBLL().GetTransactionId();
tblPurchaseOrder po = (from tbl in objData.tblPurchaseOrders
where tbl.IsDelete == false
&& tbl.PO_Id == entPurchaseInvoice.PONo
select tbl).FirstOrDefault();
if (po != null)
{
List<EntityProduct> lstProducts = GetPOProduct(Convert.ToInt32(entPurchaseInvoice.PONo));
if (lstProducts.Count == lstInvoice.Count)
{
flagISPOComplete = true;
}
else
{
flagISPOComplete = false;
}
po.IsPOComplete = flagISPOComplete;
}
tblCustomerTransaction objCust = new tblCustomerTransaction()
{
BillAmount = entPurchaseInvoice.Amount,
IsCash = false,
IsDelete = false,
SupplierId = entPurchaseInvoice.SupplierId,
ReceiptDate = entPurchaseInvoice.PIDate,
TransactionDocNo = id,
TransactionId = TId,
TransactionType = "PInvoice"
};
objData.tblCustomerTransactions.InsertOnSubmit(objCust);
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return 1;
}
public int UpdateMaterialIssueDetails(EntityIssueMaterial lstEdited, List <EntityIssueMaterialDetails> lstUpdate)
{
try
{
tblIssueMaster objTest = (from tbl in objData.tblIssueMasters
where tbl.IsDelete == false &&
tbl.IssueId == lstEdited.IssueId
select tbl).FirstOrDefault();
if (objTest != null)
{
objTest.IssueId = Convert.ToInt32(lstEdited.IssueId);
objTest.TotalAmount = lstEdited.TotalAmount;
objTest.PatientId = lstEdited.PatientId;
objTest.EmpId = lstEdited.EmpId;
objTest.IssueDate = lstEdited.IssueDate;
}
foreach (EntityIssueMaterialDetails item in lstUpdate)
{
if (item.SR_No == 0)
{
tblIssueDetail objNewAdded = new tblIssueDetail()
{
IssueId = Convert.ToInt32(lstEdited.IssueId),
ProductId = Convert.ToInt32(item.ProductId),
Quantity = item.Quantity,
Rate = item.Rate,
Total = Convert.ToDecimal(item.Total),
IsDelete = false,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
};
objData.tblIssueDetails.InsertOnSubmit(objNewAdded);
tblStockDetail stock = new tblStockDetail()
{
ProductId = Convert.ToInt32(item.ProductId),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
OutwardQty = item.Quantity,
OutwardPrice = item.Rate,
OutwardAmount = item.Total,
TransactionType = "Issue",
IsDelete = false,
};
objData.tblStockDetails.InsertOnSubmit(stock);
}
else
{
tblIssueDetail cnt = (from tbl in objData.tblIssueDetails
where tbl.IsDelete == false &&
tbl.SR_No == item.SR_No
select tbl).FirstOrDefault();
if (cnt != null)
{
cnt.IssueId = Convert.ToInt32(item.IssueId);
cnt.BatchNo = item.BatchNo;
cnt.ExpiryDate = item.ExpiryDate;
cnt.ProductId = Convert.ToInt32(item.ProductId);
cnt.Quantity = item.Quantity;
cnt.Rate = item.Rate;
cnt.Total = Convert.ToDecimal(item.Total);
cnt.IsDelete = item.IsDelete;
}
tblStockDetail stock = (from tbl in objData.tblStockDetails
where tbl.IsDelete == false &&
tbl.DocumentNo == lstEdited.IssueId &&
tbl.ProductId == item.ProductId &&
tbl.TransactionType.Equals("Issue")
select tbl).FirstOrDefault();
if (stock != null)
{
stock.ProductId = Convert.ToInt32(item.ProductId);
stock.OpeningQty = 0;
stock.InwardQty = 0;
stock.InwardPrice = 0;
stock.InwardAmount = 0;
stock.BatchNo = item.BatchNo;
stock.ExpiryDate = item.ExpiryDate;
stock.OutwardQty = item.Quantity;
stock.OutwardPrice = item.Rate;
stock.OutwardAmount = item.Total;
stock.IsDelete = item.IsDelete;
}
}
}
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(tblPrescription obj, List <EntityPrescriptionDetails> lst)
{
try
{
tblPrescription objcurrent = (from tbl in objData.tblPrescriptions
where tbl.Prescription_Id == obj.Prescription_Id
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.AdmitId = obj.AdmitId;
objcurrent.DeptCategory = obj.DeptCategory;
objcurrent.DeptDoctor = obj.DeptDoctor;
objcurrent.Prescription_Date = obj.Prescription_Date;
objcurrent.InjectionName = obj.InjectionName;
objcurrent.IsDressing = obj.IsDressing;
objcurrent.IsInjection = obj.IsInjection;
objcurrent.Investigation = obj.Investigation;
objcurrent.Impression = obj.Impression;
objcurrent.AdviceNote = obj.AdviceNote;
objcurrent.Remarks = obj.Remarks;
}
foreach (EntityPrescriptionDetails item in lst)
{
tblPrescriptionDetail objsal = new tblPrescriptionDetail();
objsal = (from tbl in objData.tblPrescriptionDetails
where tbl.PrescriptionDetailId == item.PrescriptionDetailId &&
tbl.Prescription_Id == item.Prescription_Id && tbl.ProductId == item.ProductId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.ProductId = Convert.ToInt32(item.ProductId);
objsal.Morning = item.Morning;
objsal.Afternoon = item.Afternoon;
objsal.Night = item.Night;
objsal.NoOfDays = item.NoOfDays;
objsal.Quantity = item.Quantity;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblPrescriptionDetail()
{
ProductId = item.ProductId,
Morning = item.Morning,
Afternoon = item.Afternoon,
Night = item.Night,
NoOfDays = item.NoOfDays,
Quantity = item.Quantity,
Prescription_Id = Convert.ToInt32(obj.Prescription_Id),
IsDelete = false
};
objData.tblPrescriptionDetails.InsertOnSubmit(objsal);
}
tblStockDetail stock = (from tbl in objData.tblStockDetails
where tbl.IsDelete == false &&
tbl.DocumentNo == item.Prescription_Id &&
tbl.ProductId == item.ProductId &&
tbl.TransactionType.Equals("Issue")
select tbl).FirstOrDefault();
if (stock != null)
{
stock.ProductId = Convert.ToInt32(item.ProductId);
stock.OpeningQty = 0;
stock.InwardQty = 0;
stock.InwardPrice = 0;
stock.InwardAmount = 0;
stock.OutwardQty = Convert.ToInt32(item.Quantity);
stock.IsDelete = item.IsDelete;
}
else
{
tblStockDetail stock1 = new tblStockDetail()
{
ProductId = Convert.ToInt32(item.ProductId),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
OutwardQty = Convert.ToInt32(item.Quantity),
TransactionType = "Issue",
IsDelete = false,
};
objData.tblStockDetails.InsertOnSubmit(stock1);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(EntityDebitNote lstEdited, List <EntityDebitNoteDetails> lst)
{
int i = 0;
try
{
tblDebitNote objTest = (from tbl in objData.tblDebitNotes
where tbl.IsDelete == false &&
tbl.DNNo == lstEdited.DNNo
select tbl).FirstOrDefault();
if (objTest != null)
{
objTest.Amount = lstEdited.Amount;
objTest.NetAmount = lstEdited.NetAmount;
objTest.SupplierId = lstEdited.SupplierId;
objTest.DNDate = lstEdited.DNDate;
objTest.Discount = lstEdited.Discount;
objTest.Tax1 = lstEdited.Tax1;
objTest.Tax2 = lstEdited.Tax2;
}
foreach (EntityDebitNoteDetails item in lst)
{
if (item.DNSrNo == 0)
{
tblDebitNoteDetail objNewAdded = new tblDebitNoteDetail()
{
DNNo = lstEdited.DNNo,
ProductCode = item.ProductCode,
Quantity = item.Quantity,
Price = item.Price,
Amount = item.Amount,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
IsDelete = false
};
objData.tblDebitNoteDetails.InsertOnSubmit(objNewAdded);
tblStockDetail stock = new tblStockDetail()
{
ProductId = Convert.ToInt32(item.ProductCode),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
OutwardQty = item.Quantity,
OutwardPrice = item.Price,
OutwardAmount = item.Amount,
TransactionType = "DebitNote",
IsDelete = false,
};
objData.tblStockDetails.InsertOnSubmit(stock);
}
else
{
tblDebitNoteDetail cnt = (from tbl in objData.tblDebitNoteDetails
where tbl.IsDelete == false &&
tbl.DNSrNo == item.DNSrNo
select tbl).FirstOrDefault();
if (cnt != null)
{
cnt.BatchNo = item.BatchNo;
cnt.ExpiryDate = item.ExpiryDate;
cnt.ProductCode = Convert.ToInt32(item.ProductCode);
cnt.Quantity = item.Quantity;
cnt.Price = item.Price;
cnt.Amount = Convert.ToDecimal(item.Amount);
cnt.IsDelete = item.IsDelete;
}
tblStockDetail stock = (from tbl in objData.tblStockDetails
where tbl.IsDelete == false &&
tbl.DocumentNo == lstEdited.DNNo &&
tbl.ProductId == item.ProductCode &&
tbl.TransactionType.Equals("DebitNote")
select tbl).FirstOrDefault();
if (stock != null)
{
stock.ProductId = Convert.ToInt32(item.ProductCode);
stock.OpeningQty = 0;
stock.InwardQty = 0;
stock.InwardPrice = 0;
stock.InwardAmount = 0;
stock.BatchNo = item.BatchNo;
stock.ExpiryDate = item.ExpiryDate;
stock.OutwardQty = item.Quantity;
stock.OutwardPrice = item.Price;
stock.OutwardAmount = item.Amount;
stock.IsDelete = Convert.ToBoolean(item.IsDelete);
}
}
}
#region Update Status of Order and Transaction
tblCustomerTransaction transact = (from tbl in objData.tblCustomerTransactions
where tbl.SupplierId == lstEdited.SupplierId &&
tbl.IsDelete == false &&
tbl.TransactionDocNo == lstEdited.DNNo &&
tbl.TransactionType.Equals("DebitNote")
select tbl).FirstOrDefault();
if (transact != null)
{
transact.PayAmount = lstEdited.NetAmount;
transact.ReceiptDate = lstEdited.DNDate;
}
objData.SubmitChanges();
#endregion
i++;
}
catch (Exception ex)
{
i = 0;
throw ex;
}
return(i);
}
