コード例 #1
0
        public string AppvendorList(int BatchID, string approveremailID, string type)
        {
            var status = string.Empty;

            try
            {
                List <VendorModels> datalist = _context.NONSODVendorMaster.Where(a => (a.BatchId == BatchID || a.ID == BatchID) && a.IsApproved != 0).ToList();
                if (datalist.Count > 0)
                {
                    foreach (var i in datalist)
                    {
                        if (i.IsApproved == 1)
                        {
                            return("Vendor Detail has been approved already");//Exist
                        }
                        else if (i.IsApproved == 2)
                        {
                            return("Vendor Detail has been rejected already");//Exist
                        }
                    }
                }
                else
                {
                    datalist = _context.NONSODVendorMaster.Where(a => (a.BatchId == BatchID || a.ID == BatchID) && a.IsApproved != 1).ToList();
                    List <VendorApprovallog> logTable = new List <VendorApprovallog>();
                    if (datalist != null)
                    {
                        foreach (var data in datalist)
                        {
                            VendorApprovallog modal = new VendorApprovallog();
                            data.IsApproved            = 1;
                            data.Approvaldate          = DateTime.Now;
                            data.ApprovedbyEmpEmailID  = approveremailID;
                            modal.VendorCode           = data.VendorCode;
                            modal.ApprovalStatus       = data.IsApproved;
                            modal.ApprovedbyEmpEmailID = data.ApprovedbyEmpEmailID;
                            modal.Approvaldate         = DateTime.Now;
                            modal.ApprovalModifiedDate = DateTime.Now;
                            modal.BatchID = data.BatchId;
                            modal.Remarks = "Approved";
                            logTable.Add(modal);
                            var insertdata = _context.NONSODVendorApprovalLog.AddRange(logTable);
                            var s          = _context.SaveChanges();
                        }
                        status = "Vendor Detail has been Approved";
                    }
                    else
                    {
                        return("error");//Error
                    }
                }
            }
            catch (Exception ex)
            {
                throw;
            }

            return(status);
        }
コード例 #2
0
        public string RejectVendorList(int BatchID, string ApprovermailId, string type)

        {
            var status = string.Empty;
            List <VendorModels> datalist = _context.NONSODVendorMaster.Where(a => (a.BatchId == BatchID || a.ID == BatchID) && a.IsApproved != 0).ToList();

            if (datalist.Count > 0)
            {
                foreach (var i in datalist)
                {
                    if (i.IsApproved == 1)
                    {
                        status = "Vendor Detail has been approved already";//Exist
                    }
                    else if (i.IsApproved == 2)
                    {
                        status = "Vendor Detail has been rejected already";//Exist
                    }
                }
            }
            else
            {
                var data = _context.NONSODVendorMaster.Where(a => (a.BatchId == BatchID || a.ID == BatchID)).FirstOrDefault();
                List <VendorApprovallog> logTable = new List <VendorApprovallog>();
                //var adddata = _context.NONSODVendorApprovalLog
                if (data != null)
                {
                    VendorApprovallog modal = new VendorApprovallog();
                    data.IsApproved            = 2;
                    data.Approvaldate          = DateTime.Now;
                    data.ApprovedbyEmpEmailID  = ApprovermailId;
                    modal.VendorCode           = data.VendorCode;
                    modal.ApprovalStatus       = data.IsApproved;
                    modal.ApprovedbyEmpEmailID = data.ApprovedbyEmpEmailID;
                    modal.Approvaldate         = DateTime.Now;
                    modal.ApprovalModifiedDate = DateTime.Now;
                    modal.BatchID = data.BatchId;
                    modal.Remarks = "Rejected";
                    logTable.Add(modal);
                    var insertdata = _context.NONSODVendorApprovalLog.AddRange(logTable);
                    // _context.SaveChanges();
                    _context.SaveChanges();
                    status = "Vendor Detail has been Rejected";
                }
                else
                {
                    status = "error";
                }
            }
            return(status);
        }