/// <summary> /// This method is used to save category contents with associated category /// </summary> /// <param name="content"></param> public void SaveCategoryContent(ContentModel content) { using (SASEntitiesEDM objCategoryEntities = new SASEntitiesEDM()) { var obj = objCategoryEntities.CategoriesContents.Where(x => x.Cat_Id == content.CategoryID && x.IsDeleted != true && x.Set_Default == true && content.IsSelected == true).FirstOrDefault(); if (obj != null) { obj.Set_Default = false; objCategoryEntities.SaveChanges(); } try { CategoriesContent catContent = new CategoriesContent(); catContent.Cat_Contents = content.ContentName.Trim(); catContent.Content_Limit = content.Limit; catContent.Cat_Id = content.CategoryID; catContent.IsDeleted = false; catContent.Set_Default = content.IsSelected; catContent.CreatedDate = DateTime.Now; objCategoryEntities.CategoriesContents.Add(catContent); objCategoryEntities.SaveChanges(); } catch (Exception ex) { throw ex; } } }
public int AddEditCashBank(CashBankDetailEntity cashbankentity) { try { var cashbank = entites.Accounts.Where(x => x.ID == cashbankentity.AccountID).FirstOrDefault(); var checkduplicate = entites.Accounts.Where(x => x.Acc_Name.ToLower() == cashbankentity.AccountName.ToLower() && x.IsDeleted != true).FirstOrDefault(); //if (checkduplicate != null) //{ // return 2; //} //else //{ if (cashbank != null) { cashbank.Acc_Name = cashbankentity.AccountName; cashbank.Acc_Open_Bal = cashbankentity.AccountOpeningBal == null ? null as decimal? : Convert.ToDecimal(cashbankentity.AccountOpeningBal); cashbank.Acc_Inactive = cashbankentity.IsInActivestring; entites.SaveChanges(); return(1); } else { if (checkduplicate != null) { return(2); } Account AccDetail = new Account() { Acc_Name = cashbankentity.AccountName, Acc_Open_Bal = cashbankentity.AccountOpeningBal == null ? null as decimal? : Convert.ToDecimal(cashbankentity.AccountOpeningBal), Acc_Inactive = cashbankentity.IsInActivestring }; if (cashbankentity.AccountName.ToLower().Trim() == "cash") { //var accType = entites.AccountTypes.Where(x => x.Acc_Type_Code == "CAB").FirstOrDefault(); //if (accType != null) // AccDetail.Acc_Type = accType.ID; return(2); } else { var accType = entites.AccountTypes.Where(x => x.Acc_Type_Code == "ACB").FirstOrDefault(); if (accType != null) { AccDetail.Acc_Type = accType.ID; } } entites.Accounts.Add(AccDetail); entites.SaveChanges(); return(1); } //} } catch (Exception ex) { return(3); throw ex; } }
public void UpdateRefreshData(int psID) { try { using (SASEntitiesEDM objEntities = new SASEntitiesEDM()) { ProductsAndService pands = objEntities.ProductsAndServices.Where(p => p.ID == psID).SingleOrDefault(); if (pands != null) { pands.IsRefresh = true; pands.RefreshDate = DateTime.Now.Date; objEntities.SaveChanges(); } List <ProductsAndService> pandsOther = objEntities.ProductsAndServices.Where(e => e.ID != psID).ToList(); if (pandsOther != null) { foreach (var item in pandsOther) { item.IsRefresh = false; item.RefreshDate = null; objEntities.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }
public bool RefreshCustomer(int custId) { bool result = false; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var obj = entities.Customers.Where(x => x.IsRefreshed == true).FirstOrDefault(); if (obj != null) { obj.IsRefreshed = false; entities.SaveChanges(); } var obj2 = entities.Customers.Where(x => x.ID == custId).FirstOrDefault(); if (obj2 != null) { obj2.IsRefreshed = true; obj2.RefreshedDate = System.DateTime.UtcNow; entities.SaveChanges(); } } result = true; } catch { result = false; } return(result); }
public bool SaveSearchJson(string jsonSearch, int ScreenId, string ScreenName) { try { var result = entities.LastSelectionHistories.Where(x => x.Screen_Id == ScreenId).FirstOrDefault(); if (result != null) { result.Last_Selection = jsonSearch; result.Last_Updated = DateTime.Now; entities.SaveChanges(); return(true); } else { LastSelectionHistory lastSelection = new LastSelectionHistory() { Screen_Id = ScreenId, Screen_Name = ScreenName, Last_Selection = jsonSearch, Last_Updated = DateTime.Now }; entities.LastSelectionHistories.Add(lastSelection); entities.SaveChanges(); return(true); } } catch { return(false); } }
public int UpdateRefundFromSupplier(RefundFromSupplierForm psForm) { try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { foreach (var item in psForm.RefundFromSupplierDetails) { CashAndBankTransaction obj = entities.CashAndBankTransactions.Where(e => e.Cash_Cheque_No == psForm.RefundFromSupplier.CashChequeNo && e.SO_CN_PO_DN_No == item.PurchaseNo).SingleOrDefault(); if (obj != null) { obj.Acc_Id = psForm.RefundFromSupplier.AccountId; obj.Amount = psForm.RefundFromSupplier.Amount; obj.Cash_Cheque_No = psForm.RefundFromSupplier.CashChequeNo; obj.Cash_Cheque_Date = Convert.ToDateTime(psForm.RefundFromSupplier.DateStr); obj.Remarks = psForm.RefundFromSupplier.Remarks; obj.Is_Cheque = psForm.RefundFromSupplier.IsCheque; //saving details entity obj.SO_CN_PO_DN_No = item.PurchaseNo; obj.SO_CN_PO_DN_Date = item.PurchaseDate; obj.SO_CN_PO_DN_Amt = item.PurchaseAmount; obj.Amt_Due = obj.Amt_Due = item.AmountDue - item.AmountAdjusted; obj.Amt_Refunded = item.AmountAdjusted; obj.Discount = item.Discount; obj.UpdatedBy = 0; obj.UpdatedDate = DateTime.Now; entities.SaveChanges(); if (item.AmountAdjusted == item.PurchaseAmount) { DebitNote dn = entities.DebitNotes.Where(e => e.DN_No == item.PurchaseNo).SingleOrDefault(); PurchaseOrder order = entities.PurchaseOrders.Where(e => e.PO_No == item.PurchaseNo).SingleOrDefault(); if (dn != null) { dn.DN_Status = Convert.ToByte(DN_Status.Refunded); entities.SaveChanges(); } else if (order != null) { order.PO_Status = Convert.ToByte(PO_Status.Refunded); entities.SaveChanges(); } } } } } } catch (Exception ex) { throw ex; } return(psForm.RefundFromSupplier.ID); }
public int SaveCountAndAdjustStock(CountAndAdjustStockForm casForm) { try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { foreach (var item in casForm.CountAndAdjustStockDetails) { StockCount obj = new StockCount(); obj.Stock_count_no = casForm.CountAndAdjustStock.StockCountNo; obj.StockDate = casForm.CountAndAdjustStock.StockDate; obj.StockType = casForm.CountAndAdjustStock.StockType; //saving details entity obj.PSID = item.PSID; obj.PandS_Code = item.PandSCode; obj.PandS_Name = item.PandSName; //obj.SysQty = Math.Abs(Convert.ToInt32(item.SystemQty)); obj.SysQty = item.SystemQty; obj.CountQty = item.CountQty; obj.Difference = item.Difference; obj.Average_Cost = Convert.ToDecimal(item.AvgCost); obj.Amount = item.Amount; obj.Adjusted_Amount = Convert.ToDecimal(item.AdjustedAmount); obj.UpdatedBy = 0; obj.UpdatedDate = DateTime.Now; entities.StockCounts.Add(obj); entities.SaveChanges(); ProductsAndService ps = entities.ProductsAndServices.SingleOrDefault(e => e.ID == item.PSID); if (ps != null) { if (casForm.CountAndAdjustStock.StockType == Convert.ToByte(Stock_Type.StockTake)) { ps.PandS_Qty_in_stock = ps.PandS_Qty_in_stock + item.Difference; ps.PandS_Stock_Value = ps.PandS_Stock_Value - Convert.ToDecimal(item.AdjustedAmount); entities.SaveChanges(); } else { ps.PandS_Qty_in_stock = ps.PandS_Qty_in_stock + item.Difference; entities.SaveChanges(); } } } } } catch (Exception ex) { return(0); throw ex; } return(1); }
public bool DeleteQuotatoin(int pqID) { bool result = false; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var detailList = entities.SalesOrderDetails.Where(x => x.SO_ID == pqID).ToList(); if (detailList != null) { foreach (SalesOrderDetail pqdetail in detailList) { int PSId = Convert.ToInt32(pqdetail.SO_No); if (PSId != 0) { ProductsAndService ps = entities.ProductsAndServices.SingleOrDefault(e => e.ID == PSId); if (ps != null) { ps.PandS_Qty_for_SO = ps.PandS_Qty_for_SO - pqdetail.SO_Qty; entities.SaveChanges(); } } pqdetail.SO_Qty = 0; pqdetail.SO_Price = 0; pqdetail.SO_Discount = 0; pqdetail.SO_Amount = 0; pqdetail.GST_Rate = 0; entities.SaveChanges(); } } var obj = entities.SalesOrders.Where(x => x.ID == pqID).FirstOrDefault(); //entities.SalesOrders.Remove(obj); if (obj != null) { obj.SO_Status = Convert.ToByte(PO_Status.Cancelled); obj.SO_Tot_bef_Tax = 0; obj.SO_Tot_aft_Tax = 0; obj.SO_GST_Amt = 0; obj.IsDeleted = true; obj.ModifiedDate = DateTime.Now; entities.SaveChanges(); } } result = true; } catch { result = false; } return(result); }
public bool SavePromisedDate(List <TodoUnpaidDetailEntity> TodoInvList, string DateFormat) { try { ToDoList todoinv; foreach (var item in TodoInvList) { if (item.PromisedDateStr != null) { todoinv = entities.ToDoLists.Where(e => e.InvoiceNo == item.InvoiceNo).SingleOrDefault(); if (todoinv != null) { todoinv.AmountDue = item.AmountDue; todoinv.CreditDays = item.CreditDueDays; todoinv.InvoiceDate = item.InvoiceDate; todoinv.InvoiceNo = item.InvoiceNo; todoinv.Name = item.Name; todoinv.OverdueDays = item.OverDueDays; todoinv.PaymentDueDate = item.PaymentDueDate; //todoinv.PromisedDate =Convert.ToDateTime(item.PromisedDateStr); todoinv.PromisedDate = Convert.ToDateTime(DateTime.ParseExact(item.PromisedDateStr, DateFormat, CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture)); todoinv.Type = item.Type; //entities.ToDoLists.Add(todoinv); entities.SaveChanges(); } else { todoinv = new ToDoList(); todoinv.AmountDue = item.AmountDue; todoinv.CreditDays = item.CreditDueDays; todoinv.InvoiceDate = item.InvoiceDate; todoinv.InvoiceNo = item.InvoiceNo; todoinv.Name = item.Name; todoinv.OverdueDays = item.OverDueDays; todoinv.PaymentDueDate = item.PaymentDueDate; //todoinv.PromisedDate =Convert.ToDateTime(item.PromisedDateStr); todoinv.PromisedDate = Convert.ToDateTime(DateTime.ParseExact(item.PromisedDateStr, DateFormat, CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture)); todoinv.Type = item.Type; entities.ToDoLists.Add(todoinv); entities.SaveChanges(); } } } return(true); } catch (Exception ex) { throw ex; } // return true; }
/// <summary> /// This method is used to update category contents with associated category /// </summary> /// <param name="content"></param> public void UpdateCategoryContent(ContentModel content) { using (SASEntitiesEDM objCategoryEntities = new SASEntitiesEDM()) { try { var obj = objCategoryEntities.CategoriesContents.Where(x => x.Cat_Id == content.CategoryID && x.IsDeleted != true && x.Set_Default == true && content.IsSelected == true).FirstOrDefault(); if (obj != null) { obj.Set_Default = false; objCategoryEntities.SaveChanges(); } CategoriesContent catContent = objCategoryEntities.CategoriesContents.SingleOrDefault(i => i.ID == content.ContentID); if (catContent != null) { catContent.Cat_Contents = content.ContentName; catContent.Content_Limit = content.Limit; catContent.Set_Default = content.IsSelected; catContent.ModifiedDate = DateTime.Now; objCategoryEntities.SaveChanges(); } //var categoryContent = objCategoryEntities.CategoriesContents.Where(e => e.Cat_Id == content.CategoryID && e.ID!=content.ContentID).ToList(); //if (categoryContent != null) //{ // foreach (var c in categoryContent) // { // if (content.IsSelected == true) // { // if (c.Set_Default == true) // { // c.Set_Default = false; // } // } // else // { // if(c.Set_Default==true) // { // c.Set_Default = true; // } // } // objCategoryEntities.SaveChanges(); // } //} } catch (Exception ex) { throw ex; } } }
private void CreateCreditNote(SalesInvoiceForm invoiceData) { try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { CreditNote deb = entities.CreditNotes.Where(e => e.SI_Id == invoiceData.Invoice.ID).SingleOrDefault(); if (Convert.ToDecimal(invoiceData.Invoice.TotalBeforeTax) < 0) { if (deb != null) { deb.CN_Date = DateTime.Now.Date; // deb.CN_No = "CN-" + (GetLastCreditNoteNo() + 1); //deb.SI_Id = obj.ID; deb.Cus_Id = invoiceData.Invoice.CustomerID; // deb.Cus_DN_Amount = Convert.ToDecimal(invoiceData.Invoice.TotalBeforeTax); deb.ModifiedDate = DateTime.Now; entities.SaveChanges(); } else { deb = new CreditNote(); deb.CN_Date = DateTime.Now.Date; deb.CN_No = "CN-" + (GetLastCreditNoteNo() + 1); deb.SI_Id = invoiceData.Invoice.ID; deb.Cus_Id = invoiceData.Invoice.CustomerID; deb.CN_Status = Convert.ToByte(DN_Status.UnAdjusted); deb.CN_Amount = Convert.ToDecimal(invoiceData.Invoice.TotalAfterTax);//change 3/13/2018 //deb.CN_Amount= Math.Abs(Convert.ToDecimal(invoiceData.Invoice.TotalAfterTax)); deb.CreatedDate = DateTime.Now; entities.CreditNotes.Add(deb); entities.SaveChanges(); } } else { if (deb != null) { entities.CreditNotes.Remove(deb); entities.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }
public void UpdateDebitNote(DebitNoteForm debitNote) { try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { DebitNote obj = entities.DebitNotes.Where(e => e.DN_No == debitNote.DebitNote.DebitNo ).SingleOrDefault(); if (obj != null) { if (!string.IsNullOrEmpty(debitNote.DebitNote.SupplierCreditNoteAmount)) { debitNote.DebitNote.SCNAmount = Convert.ToDecimal(debitNote.DebitNote.SupplierCreditNoteAmount); } obj.DN_Reason = debitNote.DebitNote.TermsAndConditions; obj.Sup_CN_No = debitNote.DebitNote.SupplierCreditNoteNo; obj.Sup_CN_Date = debitNote.DebitNote.SupplierCreditNoteDate; obj.Sup_CN_Amount = debitNote.DebitNote.SCNAmount; obj.ModifiedDate = DateTime.Now; entities.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public int SaveReceiveMoney(ReceiveMoneyEntity receiveMoney) { int autoId = 0; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { ReceiveMoney cbt = new ReceiveMoney(); cbt.LinkedAccountID = receiveMoney.SelectedLinkedAcntID; cbt.CashBankAccountID = receiveMoney.SelectedCashBankAcntID; cbt.IsCheque = receiveMoney.IsCheque; cbt.CashChequeNo = receiveMoney.CashChequeNo; cbt.CashChequeDate = receiveMoney.CashChequeDate; cbt.Remarks = receiveMoney.Remarks; cbt.TaxID = receiveMoney.SelectedTaxID; cbt.TotalBeforeTax = receiveMoney.TotalBeforeTax; cbt.TotalTax = receiveMoney.TotalTax; cbt.TotalAfterTax = receiveMoney.TotalAfterTax; cbt.Remarks = receiveMoney.Remarks; cbt.CreatedBy = 1; cbt.CreatedDate = DateTime.Now; entities.ReceiveMoneys.Add(cbt); entities.SaveChanges(); } } catch (Exception ex) { throw ex; } return(autoId); }
public bool DeleteQuotatoin(int pqID) { bool result = false; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { //var detailList = entities.PurchaseQuotationDetails.Where(x => x.PQ_ID == pqID).ToList(); //if (detailList != null) //{ // //foreach (PurchaseQuotationDetail pqdetail in detailList) // //{ // // entities.PurchaseQuotationDetails.Remove(pqdetail); // //} //} var obj = entities.PurchaseQuotations.Where(x => x.ID == pqID).FirstOrDefault(); //entities.PurchaseQuotations.Remove(obj); if (obj != null) { obj.IsDeleted = true; obj.ModifiedDate = DateTime.Now; entities.SaveChanges(); } } result = true; } catch { result = false; } return(result); }
public bool DeleteQuotatoin(int pqID) { bool result = false; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var obj = entities.SalesQuotations.Where(x => x.ID == pqID).FirstOrDefault(); //entities.SalesQuotations.Remove(obj); if (obj != null) { obj.IsDeleted = true; obj.ModifiedDate = DateTime.Now; entities.SaveChanges(); } } result = true; } catch { result = false; } return(result); }
public void UpdateCreditNote(CreditNoteForm CreditNote) { try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { CreditNote obj = entities.CreditNotes.Where(e => e.CN_No == CreditNote.CreditNote.CreditNo ).SingleOrDefault(); if (obj != null) { if (!string.IsNullOrEmpty(CreditNote.CreditNote.CustomerDebitNoteAmount)) { CreditNote.CreditNote.CDNAmount = Convert.ToDecimal(CreditNote.CreditNote.CustomerDebitNoteAmount); } obj.CN_Reason = CreditNote.CreditNote.TermsAndConditions; obj.Cus_DN_No = CreditNote.CreditNote.CustomerDebitNoteNo; //obj.Cus_DN_Date = CreditNote.CreditNote.CustomerDebitNoteDate; obj.Cus_DN_Date = CreditNote.CreditNote.CustomerDebitNoteDate; obj.Cus_DN_Amount = CreditNote.CreditNote.CDNAmount; obj.ModifiedDate = DateTime.Now; entities.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
private void CreateDebitNote(PurchaseInvoiceForm invoiceData) { try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { DebitNote deb = entities.DebitNotes.Where(e => e.PI_Id == invoiceData.Invoice.ID).SingleOrDefault(); if (Convert.ToDecimal(invoiceData.Invoice.TotalBeforeTax) < 0) { if (deb != null) { deb.DN_Date = DateTime.Now; // deb.DN_No = "DN-" + (GetLastDebitNoteNo() + 1); //deb.PI_Id = obj.ID; deb.Sup_Id = invoiceData.Invoice.SupplierID; deb.Sup_CN_Amount = Convert.ToDecimal(invoiceData.Invoice.TotalBeforeTax); //deb.ModifiedDate = DateTime.Now; entities.SaveChanges(); } else { deb = new DebitNote(); deb.DN_Date = DateTime.Now; deb.DN_No = "DN-" + (GetLastDebitNoteNo() + 1); deb.PI_Id = invoiceData.Invoice.ID; deb.Sup_Id = invoiceData.Invoice.SupplierID; deb.Sup_CN_Amount = Convert.ToDecimal(invoiceData.Invoice.TotalBeforeTax); deb.CreatedDate = DateTime.Now; entities.DebitNotes.Add(deb); entities.SaveChanges(); } } else { if (deb != null) { entities.DebitNotes.Remove(deb); entities.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }
public int SaveStockData(StockModel JForm) { //int autoId = 0; // UnpaidSalesInvoice obj = new UnpaidSalesInvoice(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { Stock obj1; if (JForm.StockDetailsData != null) { foreach (StockEntity JEntity in JForm.StockDetailsData) { //save entity value obj1 = new Stock(); obj1.Product_ID = JEntity.ID; obj1.Quantity_In_Stock = JEntity.QtyInStock; obj1.Average_Cost = JEntity.AverageCost; obj1.Amount = JEntity.Amount; obj1.CreatedDate = DateTime.Now; if (entities.Stocks.AsNoTracking().FirstOrDefault(x => x.ID == JEntity.ID) == null) { entities.Stocks.Add(obj1); entities.SaveChanges(); } else { entities.Entry(obj1).State = EntityState.Modified; entities.SaveChanges(); } } } else { } } return(1); } catch (Exception e) { return(0); throw e; } }
/// <summary> /// This method is used to save new tax /// </summary> /// <param name="taxModel"></param> public void SaveTax(TaxModel taxModel) { try { using (SASEntitiesEDM objEntities = new SASEntitiesEDM()) { TaxCodesAndRate tax = new TaxCodesAndRate(); tax.Tax_Name = taxModel.TaxName; tax.Tax_Description = taxModel.TaxDescription.Trim(); tax.Tax_Code = taxModel.TaxCode.Trim(); tax.Tax_Rate = taxModel.TaxRate; if (taxModel.IsInActive == null) { tax.Tax_Inactive = "N"; } else { tax.Tax_Inactive = taxModel.IsInActive; } tax.Tax_Default = false; tax.CreatedDate = DateTime.Now; tax.IsDeleted = false; objEntities.TaxCodesAndRates.Add(tax); objEntities.SaveChanges(); var taxes = objEntities.TaxCodesAndRates.ToList(); if (taxes != null) { foreach (var taxItem in taxes) { taxItem.Tax_Name = taxModel.TaxName; objEntities.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }
public int SaveTransferMoney(TransferMoneyEntity transferMoney) { int autoId = 0; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { TransferMoney cbt = new TransferMoney(); cbt.From_Acc_Id = transferMoney.SelectedtransferFromCashAndBankAcntID; cbt.To_Acc_Id = transferMoney.SelectedtransferToCashBankAcntID; cbt.Cheque = transferMoney.IsCheque; cbt.Cheque_No = transferMoney.CashChequeNo; cbt.Cheque_Date = transferMoney.CashChequeDate; cbt.Remarks = transferMoney.Remarks; cbt.Amount = transferMoney.Amount; cbt.Remarks = transferMoney.Remarks; cbt.CreatedBy = 1; cbt.CreatedDate = DateTime.Now; entities.TransferMoneys.Add(cbt); entities.SaveChanges(); Account acntFrom = entities.Accounts.SingleOrDefault(e => e.ID == transferMoney.SelectedtransferFromCashAndBankAcntID); if (acntFrom != null) { acntFrom.Acc_Cur_Bal = (acntFrom.Acc_Cur_Bal == null?0:acntFrom.Acc_Cur_Bal) - transferMoney.Amount; entities.SaveChanges(); } Account acntTo = entities.Accounts.SingleOrDefault(e => e.ID == transferMoney.SelectedtransferToCashBankAcntID); if (acntTo != null) { acntTo.Acc_Cur_Bal = (acntTo.Acc_Cur_Bal == null?0:acntTo.Acc_Cur_Bal) + transferMoney.Amount; entities.SaveChanges(); } } } catch (Exception ex) { throw ex; } return(autoId); }
public bool SaveUsers(List <UsersSecurityEntity> Users) { try { foreach (var item in Users) { if (item.Password != null && item.Password != "") { item.EncryptedPassword = Encrypt(item.Password); } var checkuser = entites.Users.Where(x => x.UserId == item.ID).FirstOrDefault(); if (checkuser != null) { checkuser.User_Name = item.UserName; checkuser.User_Password = item.EncryptedPassword; checkuser.Active = item.Isinactive; checkuser.CreatedDate = DateTime.Now; checkuser.User_Email = "*****@*****.**"; entites.SaveChanges(); } else { User user = new User() { User_Name = item.UserName.ToLower(), User_Password = item.EncryptedPassword, Active = item.Isinactive, CreatedDate = DateTime.Now, User_Email = "*****@*****.**" }; entites.Users.Add(user); entites.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); //throw ex; } }
public int SaveUndeliveredPurchaseOrdersDepositsData(UndeliveredPurchaseOrdersDepositsModel JForm) { //int autoId = 0; // UnpaidSalesInvoice obj = new UnpaidSalesInvoice(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { UndeliveredPurchaseOrdersWithDeposit obj1; if (JForm.UndeliveredPurchaseOrdersDepositsDetailsData != null) { foreach (UndeliveredPurchaseOrdersDepositsEntity JEntity in JForm.UndeliveredPurchaseOrdersDepositsDetailsData) { //save entity value obj1 = new UndeliveredPurchaseOrdersWithDeposit(); obj1.S_ID = JEntity.ID; obj1.UPurchaseOrder_No = JEntity.OrderNo; obj1.UPurchaseOrder_Date = JEntity.OrderDateTime; obj1.UPurchaseOrder_Amount = JEntity.UndeliveredAmount; obj1.UPurchaseOrderDeposit_Amount = JEntity.DepositAmount; obj1.CreatedDate = DateTime.Now; obj1.IsDeleted = false; if (obj1 != null) { entities.UndeliveredPurchaseOrdersWithDeposits.Add(obj1); entities.SaveChanges(); } //if (entities.UndeliveredPurchaseOrdersWithDeposits.AsNoTracking().FirstOrDefault(x => x.ID == JEntity.ID) == null) //{ // entities.UndeliveredPurchaseOrdersWithDeposits.Add(obj1); // entities.SaveChanges(); //} //else //{ // entities.Entry(obj1).State = EntityState.Modified; // entities.SaveChanges(); //} } } else { } } return(1); } catch (Exception e) { return(0); throw e; } }
public void UpdatePandS(PandSDetailsModel pandsModel) { try { using (SASEntitiesEDM objEntities = new SASEntitiesEDM()) { ProductsAndService pands = objEntities.ProductsAndServices.Where(p => p.ID == pandsModel.ID).SingleOrDefault(); if (pands != null) { pands.PandS_Code = pandsModel.PSCode; pands.PandS_Name = pandsModel.PSName; pands.PandS_Type = pandsModel.PSType; pands.PandS_Cat1 = pandsModel.PSCategory1; pands.PandS_Cat2 = pandsModel.PSCategory2; pands.Tax_Rate = pandsModel.TaxRate; pands.Tax_ID = pandsModel.TaxID; pands.PandS_Description = pandsModel.PSDescription; pands.PandS_Inactive = pandsModel.IsInActive == null ? null : pandsModel.IsInActive; pands.PandS_Stock_Picture = pandsModel.ImgSource; //Standard Sell and cost price pands.PandS_Std_Sell_Price_bef_GST = Convert.ToDecimal(pandsModel.StandardSellPriceBeforeGST); pands.PandS_Std_Sell_Price_aft_GST = Convert.ToDecimal(pandsModel.StandardSellPriceAfterGST); pands.PandS_Std_Cost_Price_bef_GST = Convert.ToDecimal(pandsModel.StandardCostpriceBeforeGST); pands.PandS_Std_Cost_Price_aft_GST = Convert.ToDecimal(pandsModel.StandardCostpriceAfterGST); //Average pands.PandS_Ave_Sell_Price_bef_GST = Convert.ToDecimal(pandsModel.AverageSellPriceBeforeGST); pands.PandS_Ave_Sell_Price_aft_GST = Convert.ToDecimal(pandsModel.AverageSellPriceAfterGST); pands.PandS_Ave_Cost_Price_bef_GST = Convert.ToDecimal(pandsModel.AverageCostPriceBeforeGST); pands.PandS_Ave_Cost_Price_aft_GST = Convert.ToDecimal(pandsModel.AverageCostPriceAfterGST); //Last pands.PandS_Last_Sold_Price_bef_GST = Convert.ToDecimal(pandsModel.LastSoldPriceBeforeGST); pands.PandS_Last_Sold_Price_aft_GST = Convert.ToDecimal(pandsModel.LastSoldPriceAfterGST); pands.PandS_Last_Pur_Price_bef_GST = Convert.ToDecimal(pandsModel.LastPurchasePriceBeforeGST); pands.PandS_Last_Pur_Price_aft_GST = Convert.ToDecimal(pandsModel.LastPurchasePriceAfterGST); //Stock pands.PandS_Min_Qty = pandsModel.MinimumQuantity; pands.PandS_Qty_in_stock = pandsModel.QuantityInStock; pands.PandS_Qty_for_SO = pandsModel.ReservedForSalesOrders; pands.PandS_Qty_on_PO = pandsModel.OnPurchaseOrders; pands.PandS_Stock_Value = pandsModel.StockValue; pands.ModifiedBy = pandsModel.LoggedinUserID; pands.ModifiedDate = DateTime.Now; pands.IsRefresh = false; pands.RefreshDate = null; objEntities.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public int CreateCustomer(Customer entity) { Customer obj = new Customer(); using (SASEntitiesEDM entities = new SASEntitiesEDM()) { if (entities.Customers.AsNoTracking().FirstOrDefault(x => x.ID == entity.ID) == null) { entities.Customers.Add(entity); } else { entities.Entry(entity).State = EntityState.Modified; } return(entities.SaveChanges()); } }
/// <summary> /// This method is used to delete the tax /// </summary> /// <param name="id"></param> public void DeleteTax(int id) { try { using (SASEntitiesEDM objEntities = new SASEntitiesEDM()) { TaxCodesAndRate tax = objEntities.TaxCodesAndRates.SingleOrDefault(t => t.ID == id); tax.IsDeleted = true; tax.ModifiedDate = DateTime.Now; objEntities.SaveChanges(); } } catch (Exception ex) { throw ex; } }
/// <summary> /// This method is used to save Purchase and sales Category Content /// </summary> /// <param name="content"></param> public void SavePSCategoryContent(ContentModel content) { using (SASEntitiesEDM objCategoryEntities = new SASEntitiesEDM()) { try { var tandc = objCategoryEntities.TermsAndConditions.Where(e => e.Cat_Code == content.CategoryCode).SingleOrDefault(); if (tandc != null) { tandc.Cat_Content = content.ContentName; objCategoryEntities.SaveChanges(); } } catch (Exception ex) { throw ex; } } }
public int DeleteInvoice(string pqNo) { int PIStatus = 0; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var PInvoice = entities.BusinessExpenses.Where(e => e.PI_No == pqNo).FirstOrDefault(); if (PInvoice != null) { var PO_PI = entities.CashAndBankTransactions.Where(x => x.SO_CN_PO_DN_No == pqNo ).FirstOrDefault(); if (PO_PI != null) { if (PO_PI.Amt_Due != null) { PInvoice.PI_Status = Convert.ToByte(PI_Status.UnPaid); PIStatus = Convert.ToByte(PI_Status.UnPaid); } else { PInvoice.PI_Status = Convert.ToByte(PI_Status.Paid); PIStatus = Convert.ToByte(PI_Status.Paid); } } else { PInvoice.PI_Status = Convert.ToByte(PI_Status.Cancelled); PIStatus = Convert.ToByte(PI_Status.Cancelled); } entities.SaveChanges(); } } } catch (Exception ex) { throw ex; } return(PIStatus); }
public bool DeleteCustomer(int custId) { bool result = false; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var obj = entities.Customers.Where(x => x.ID == custId).FirstOrDefault(); entities.Customers.Remove(obj); entities.SaveChanges(); } result = true; } catch { result = false; } return(result); }
/// <summary> /// This method is used to delete Category Content /// </summary> /// <param name="catId"></param> public void DeleteCategoryContent(int contentID) { using (SASEntitiesEDM objCategoryEntities = new SASEntitiesEDM()) { try { CategoriesContent catContent = objCategoryEntities.CategoriesContents.SingleOrDefault(i => i.ID == contentID); if (catContent != null) { catContent.IsDeleted = true; objCategoryEntities.SaveChanges(); } } catch (Exception ex) { throw ex; } } }
public void DeletePandS(PandSDetailsModel pandsModel) { try { using (SASEntitiesEDM objEntities = new SASEntitiesEDM()) { ProductsAndService pands = objEntities.ProductsAndServices.Where(p => p.ID == pandsModel.ID).SingleOrDefault(); if (pands != null) { pands.IsDeleted = true; pands.ModifiedBy = pandsModel.LoggedinUserID; pands.ModifiedDate = DateTime.Now; objEntities.SaveChanges(); } } } catch (Exception ex) { throw ex; } }