コード例 #1
0
        /// <summary>
        /// Updating invoice status and payment date
        /// on accepting discount
        /// Date: 25 June 2019
        /// Developer: Shreyans Khandelwal (0538)
        /// </summary>
        /// <param name="invoiceId"></param>
        /// <param name="paymentDate"></param>
        /// <returns></returns>
        private bool UpdateInvoice(long?invoiceId, decimal amountPaid, decimal discountAmount, DateTime paymentdate, Int32 InvoiceStatus, decimal?AvailableLimits, bool?IsUnLimited)
        {
            try
            {
                var invoice = (from data in finocartEntities.Invoice where data.InvoiceID == invoiceId select data).FirstOrDefault();
                invoice.InvoiceStatus = InvoiceStatus;
                if (invoice.FinoLimUnLim != "FinoLim" && invoice.FinoLimUnLim != "FinoUnLim")
                {
                    invoice.PaymentDate = paymentdate;
                }
                invoice.AmountPaid          = Math.Round(amountPaid);
                invoice.Earning             = Math.Round(discountAmount);
                invoice.InvoiceApprovalDate = DateTime.Now.Date;
                if (IsUnLimited != true && AvailableLimits != null)
                {
                    invoice.Limits = AvailableLimits.ToString();
                }
                else
                {
                    invoice.Limits = "Unlimited";
                }

                finocartEntities.SaveChanges();


                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
ファイル: MsVendor.cs プロジェクト: Rashmi-Salaria/Finocart
        /// <summary>
        /// Saving vendor from SAP to Database
        /// Date: 20 June 2019
        /// Developer: Shreyans Khandelwal (0538)
        /// </summary>
        public void SaveVendor()
        {
            try
            {
                VendorDetail vendorDetail = new VendorDetail();
                //vendorDetail = objSapVendor.GetVendor();
                vendorDetail.PanNumber = "0192873661";
                int  venId          = 0;
                bool addAssoCompany = false;

                //allowing to add vendor only if PAN number is available
                if (!string.IsNullOrEmpty(vendorDetail.PanNumber))
                {
                    //checking if vendor already exist on basis of PAN number
                    var vendorId = (from data in finocartEntities.Company where data.Pan_number == vendorDetail.PanNumber select data.CompanyID).FirstOrDefault();

                    //if vendor exist linking it to new company
                    if (vendorId > 0)
                    {
                        var vendorAssociate = (from data in finocartEntities.VendorAssociatedCompany where data.VendorId == vendorId && data.CompanyId == 5678 select data).FirstOrDefault();
                        if (vendorAssociate == null)
                        {
                            venId          = vendorId;
                            addAssoCompany = true;
                        }
                    }
                    //If vendor does not exist adding it to DB
                    else
                    {
                        vendorDetail.InstretedAs = (from data in finocartEntities.LookupDetails
                                                    where data.LookupValue == "Vendor" && data.LookupFor == "AccessView"
                                                    select data.ID).FirstOrDefault();
                        Company company = MapCompany(vendorDetail);
                        finocartEntities.Company.Add(company);
                        finocartEntities.SaveChanges();
                        addAssoCompany = true;
                        venId          = company.CompanyID;
                    }
                    //Linking vendor to the company
                    if (addAssoCompany)
                    {
                        if (!finocartEntities.VendorAssociatedCompany.Where(data => data.VendorId == venId && data.CompanyId == 57).Any())
                        {
                            VendorAssociatedCompany vendorAssociatedCompany = new VendorAssociatedCompany();
                            vendorAssociatedCompany.VendorId  = venId;
                            vendorAssociatedCompany.CompanyId = 57;

                            finocartEntities.VendorAssociatedCompany.Add(vendorAssociatedCompany);
                            finocartEntities.SaveChanges();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                logger.WriteLog(ex);
                throw ex;
            }
        }
コード例 #3
0
 /// <summary>
 /// Sending notification to vendor
 /// on approval of invoice
 /// Date: 26 June 2019
 /// Developer: Shreyans Khandelwal (0538)
 /// </summary>
 /// <returns></returns>
 public bool SendNotification(int companyId, string messageType, int billId, decimal billAmount)
 {
     try
     {
         bool                insert          = false;
         string              message         = GetMessage(messageType, billId, billAmount);
         List <int>          userId          = GetUserForNotification(companyId, messageType);
         List <Notification> lstNotification = new List <Notification>();
         foreach (var id in userId)
         {
             Notification notification = new Notification();
             notification.CreatedOn   = DateTime.Now;
             notification.Description = message;
             notification.UserID      = id;
             lstNotification.Add(notification);
             insert = true;
         }
         if (insert)
         {
             finocartEntities.Notification.AddRange(lstNotification);
             finocartEntities.SaveChanges();
         }
         return(true);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }