public string InsertUpdateServiceCall(ServiceCallViewModel serviceCallVM) { try { AppUA appUA = Session["AppUA"] as AppUA; serviceCallVM.PSASysCommon = new PSASysCommonViewModel(); serviceCallVM.PSASysCommon.CreatedBy = appUA.UserName; serviceCallVM.PSASysCommon.CreatedDate = _pSASysCommon.GetCurrentDateTime(); serviceCallVM.PSASysCommon.UpdatedBy = appUA.UserName; serviceCallVM.PSASysCommon.UpdatedDate = _pSASysCommon.GetCurrentDateTime(); object ResultFromJS = JsonConvert.DeserializeObject(serviceCallVM.DetailJSON); string ReadableFormat = JsonConvert.SerializeObject(ResultFromJS); serviceCallVM.ServiceCallDetailList = JsonConvert.DeserializeObject <List <ServiceCallDetailViewModel> >(ReadableFormat); ResultFromJS = JsonConvert.DeserializeObject(serviceCallVM.CallChargeJSON); ReadableFormat = JsonConvert.SerializeObject(ResultFromJS); serviceCallVM.ServiceCallChargeList = JsonConvert.DeserializeObject <List <ServiceCallChargeViewModel> >(ReadableFormat); object result = _serviceCallBusiness.InsertUpdateServiceCall(Mapper.Map <ServiceCallViewModel, ServiceCall>(serviceCallVM)); if (serviceCallVM.ID == Guid.Empty) { return(JsonConvert.SerializeObject(new { Status = "OK", Record = result, Message = "Insertion successfull" })); } else { return(JsonConvert.SerializeObject(new { Status = "OK", Record = result, Message = "Updation successfull" })); } } catch (Exception ex) { AppConstMessage cm = _appConstant.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Status = "ERROR", Record = "", Message = cm.Message })); } }
public string GetDeliveryChallanDetailListByDeliveryChallanIDWithSaleOrder(Guid saleOrderID) { try { List <DeliveryChallanDetailViewModel> deliveryChallanItemViewModelList = new List <DeliveryChallanDetailViewModel>(); if (saleOrderID != Guid.Empty) { List <SaleOrderDetailViewModel> saleOrderDetailVMList = Mapper.Map <List <SaleOrderDetail>, List <SaleOrderDetailViewModel> >(_saleOrderBusiness.GetSaleOrderDetailListBySaleOrderID(saleOrderID, false).Where(x => x.Qty != x.PrevDelQty).ToList()); deliveryChallanItemViewModelList = (from saleOrderDetailVM in saleOrderDetailVMList select new DeliveryChallanDetailViewModel { ID = Guid.Empty, DelvChallanID = Guid.Empty, ProductID = saleOrderDetailVM.ProductID, ProductModelID = saleOrderDetailVM.ProductModelID, ProductSpec = saleOrderDetailVM.ProductSpec, OrderQty = saleOrderDetailVM.Qty, UnitCode = saleOrderDetailVM.UnitCode, DelvQty = saleOrderDetailVM.Qty - saleOrderDetailVM.PrevDelQty, SpecTag = saleOrderDetailVM.SpecTag, PrevDelQty = saleOrderDetailVM.PrevDelQty, Product = saleOrderDetailVM.Product, ProductModel = saleOrderDetailVM.ProductModel, Unit = saleOrderDetailVM.Unit, }).ToList(); } return(JsonConvert.SerializeObject(new { Status = "OK", Records = deliveryChallanItemViewModelList, Message = "Success" })); } catch (Exception ex) { AppConstMessage cm = _appConstant.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Status = "ERROR", Records = "", Message = cm.Message })); } }
public string GetDueDate(string Code, string InvDate = "") { try { string DuePaymentDueDateFormatted; SPAccounts.DataAccessObject.DTO.Common com = new SPAccounts.DataAccessObject.DTO.Common(); DateTime Datenow = com.GetCurrentDateTime(); PaymentTermsViewModel payTermsObj = Mapper.Map <PaymentTerms, PaymentTermsViewModel>(_paymentTermsBusiness.GetPayTermDetails(Code)); if (InvDate == "") { DuePaymentDueDateFormatted = Datenow.AddDays(payTermsObj.NoOfDays).ToString("dd-MMM-yyyy"); } else { DuePaymentDueDateFormatted = Convert.ToDateTime(InvDate).AddDays(payTermsObj.NoOfDays).ToString("dd-MMM-yyyy"); } return(JsonConvert.SerializeObject(new { Result = "OK", Records = DuePaymentDueDateFormatted })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateIncomingCheque(DepositAndWithdrwalViewModel depositAndWithdrawalObj) { try { AppUA appUA = Session["AppUA"] as AppUA; depositAndWithdrawalObj.IncomingObj.CommonObj = new CommonViewModel(); depositAndWithdrawalObj.IncomingObj.CommonObj.CreatedBy = appUA.UserName; depositAndWithdrawalObj.IncomingObj.CommonObj.CreatedDate = DateTime.Now; depositAndWithdrawalObj.IncomingObj.CommonObj.UpdatedBy = appUA.UserName; depositAndWithdrawalObj.IncomingObj.CommonObj.UpdatedDate = DateTime.Now; object OGC = _depositAndWithdrawalsBusiness.InsertUpdateIncomingCheque(Mapper.Map <IncomingChequesViewModel, IncomingCheques>(depositAndWithdrawalObj.IncomingObj)); if (depositAndWithdrawalObj.IncomingObj.ID != null && depositAndWithdrawalObj.IncomingObj.ID != Guid.Empty) { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.UpdateSuccess, Records = OGC })); } else { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.InsertSuccess, Records = OGC })); } } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateFollowUp(CustomerExpeditingListViewModel customerObj) { try { AppUA _appUA = Session["AppUA"] as AppUA; customerObj.followUpObj.commonObj = new CommonViewModel(); SPAccounts.DataAccessObject.DTO.Common _comonObj = new SPAccounts.DataAccessObject.DTO.Common(); customerObj.followUpObj.commonObj.CreatedBy = _appUA.UserName; customerObj.followUpObj.commonObj.CreatedDate = _comonObj.GetCurrentDateTime(); customerObj.followUpObj.commonObj.UpdatedDate = _comonObj.GetCurrentDateTime(); customerObj.followUpObj.commonObj.UpdatedBy = _appUA.UserName; FollowUpViewModel followupObj = Mapper.Map <FollowUp, FollowUpViewModel>(_paymentFollowupBusiness.InsertUpdateFollowUp(Mapper.Map <FollowUpViewModel, FollowUp>(customerObj.followUpObj))); if (customerObj.followUpObj.ID == Guid.Empty) { return(JsonConvert.SerializeObject(new { Result = "OK", Records = followupObj, Message = "Insertion successfull" })); } else { return(JsonConvert.SerializeObject(new { Result = "OK", Records = followupObj, Message = "Updation successfull" })); } } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateProductionQC(ProductionQCViewModel productionQCVM) { //object resultFromBusiness = null; try { AppUA appUA = Session["AppUA"] as AppUA; productionQCVM.PSASysCommon = new PSASysCommonViewModel(); productionQCVM.PSASysCommon.CreatedBy = appUA.UserName; productionQCVM.PSASysCommon.CreatedDate = _pSASysCommon.GetCurrentDateTime(); productionQCVM.PSASysCommon.UpdatedBy = appUA.UserName; productionQCVM.PSASysCommon.UpdatedDate = _pSASysCommon.GetCurrentDateTime(); object ResultFromJS = JsonConvert.DeserializeObject(productionQCVM.DetailJSON); string ReadableFormat = JsonConvert.SerializeObject(ResultFromJS); productionQCVM.ProductionQCDetailList = JsonConvert.DeserializeObject <List <ProductionQCDetailViewModel> >(ReadableFormat); object result = _productionQCBusiness.InsertUpdateProductionQC(Mapper.Map <ProductionQCViewModel, ProductionQC>(productionQCVM)); if (productionQCVM.ID == Guid.Empty) { return(JsonConvert.SerializeObject(new { Status = "OK", Record = result, Message = "Insertion successfull" })); } else { return(JsonConvert.SerializeObject(new { Status = "OK", Record = result, Message = "Updation successfull" })); } } catch (Exception ex) { AppConstMessage cm = _appConstant.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Status = "ERROR", Record = "", Message = cm.Message })); } }
public string GetUndepositedCheque(string undepositedChequeAdvanceSearchObject)//FromDate, string ToDate) { try { //if (fromDate != "" ? Convert.ToDateTime(fromDate) > Convert.ToDateTime(chequeAdvanceSearchObj.ToDate) : false) //{ // throw new Exception("Date missmatch"); //} AppUA appUA = Session["AppUA"] as AppUA; UndepositedChequeAdvanceSearch undepositedChequeAdvanceSearchObj = undepositedChequeAdvanceSearchObject != null?JsonConvert.DeserializeObject <UndepositedChequeAdvanceSearch>(undepositedChequeAdvanceSearchObject) : new UndepositedChequeAdvanceSearch(); if (undepositedChequeAdvanceSearchObject == null) { undepositedChequeAdvanceSearchObj.ToDate = appUA.DateTime.ToString("dd-MMM-yyyy"); } List <DepositAndWithdrwalViewModel> unDepositedChequeList = Mapper.Map <List <DepositAndWithdrawals>, List <DepositAndWithdrwalViewModel> >(_depositAndWithdrawalsBusiness.GetUndepositedCheque(undepositedChequeAdvanceSearchObj)); string MinDate = unDepositedChequeList.Count != 0 ? Convert.ToDateTime((unDepositedChequeList.Min(X => Convert.ToDateTime(X.DateFormatted)))).ToString("dd-MMM-yyyy") : undepositedChequeAdvanceSearchObj.FromDate; var totalAmount = unDepositedChequeList.Where(amt => amt.TransactionType != "D").Sum(amt => amt.Amount); string totalAmountFormatted = _commonBusiness.ConvertCurrency(totalAmount, 2); return(JsonConvert.SerializeObject(new { Result = "OK", Records = unDepositedChequeList, FromDate = MinDate, totalAmount = totalAmountFormatted })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message }));//, FromDate = FromDate }); } }
public string InsertUpdateTaxType(TaxTypesViewModel _taxTypesObj) { try { object result = null; AppUA appUA = Session["AppUA"] as AppUA; _taxTypesObj.commonObj = new CommonViewModel(); _taxTypesObj.commonObj.CreatedBy = appUA.UserName; _taxTypesObj.commonObj.CreatedDate = common.GetCurrentDateTime(); _taxTypesObj.commonObj.UpdatedBy = appUA.UserName; _taxTypesObj.commonObj.UpdatedDate = common.GetCurrentDateTime(); if (!string.IsNullOrEmpty(_taxTypesObj.hdnCode)) { _taxTypesObj.Code = _taxTypesObj.hdnCode; } result = _taxTypeBusiness.InsertUpdateTaxType(Mapper.Map <TaxTypesViewModel, TaxTypes>(_taxTypesObj)); return(JsonConvert.SerializeObject(new { Result = "OK", Records = result })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetAllBanks() { try { List <BankViewModel> BankList = Mapper.Map <List <Bank>, List <BankViewModel> >(_bankBusiness.GetAllBanks()); Permission _permission = Session["UserRights"] as Permission; string p = _permission.SubPermissionList.Where(li => li.Name == "ODLimit").First().AccessCode; foreach (var Item in BankList) { if (p.Contains("R") || p.Contains("W")) { Item.ShowODLimit = true; } else { Item.ShowODLimit = false; } } return(JsonConvert.SerializeObject(new { Result = "OK", Records = BankList })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdatePayments(SpecialInvPaymentsViewModel SpecialInvObj) { try { if (SpecialInvObj.specialDetailObj.PaidAmount == 0) { throw new Exception("Please Enter Amount"); } AppUA _appUA = Session["AppUA"] as AppUA; if (SpecialInvObj.hdfpaymentDetail != null) { SpecialInvObj.specialList = JsonConvert.DeserializeObject <List <SpecialInvPaymentsDetailViewModel> >(SpecialInvObj.hdfpaymentDetail); } SpecialInvObj.commonObj = new CommonViewModel(); SpecialInvObj.commonObj.CreatedBy = _appUA.UserName; SpecialInvObj.commonObj.CreatedDate = _appUA.DateTime; SpecialInvObj.commonObj.UpdatedBy = _appUA.UserName; SpecialInvObj.commonObj.UpdatedDate = _appUA.DateTime;; SpecialInvPaymentsViewModel SPIN = Mapper.Map <SpecialInvPayments, SpecialInvPaymentsViewModel>(_SpecialInvPaymentsBusiness.InsertUpdateSpecialInvPayments(Mapper.Map <SpecialInvPaymentsViewModel, SpecialInvPayments>(SpecialInvObj))); if (SpecialInvObj.ID != null && SpecialInvObj.ID != Guid.Empty) { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.UpdateSuccess, Records = SPIN })); } else { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.InsertSuccess, Records = SPIN })); } } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateEmployeeCategory(EmployeeCategoryViewModel employeeCategoryViewModel) { object result = null; try { AppUA _appUA = Session["AppUA"] as AppUA; employeeCategoryViewModel.commonObj = new CommonViewModel(); employeeCategoryViewModel.commonObj.CreatedBy = _appUA.UserName; employeeCategoryViewModel.commonObj.CreatedDate = _appUA.DateTime; employeeCategoryViewModel.commonObj.UpdatedBy = employeeCategoryViewModel.commonObj.CreatedBy; employeeCategoryViewModel.commonObj.UpdatedDate = employeeCategoryViewModel.commonObj.CreatedDate; switch (employeeCategoryViewModel.Operation) { case "Insert": result = _employeeBusiness.InsertEmployeeCategory(Mapper.Map <EmployeeCategoryViewModel, EmployeeCategory>(employeeCategoryViewModel)); break; case "Update": result = _employeeBusiness.UpdateEmployeeCategory(Mapper.Map <EmployeeCategoryViewModel, EmployeeCategory>(employeeCategoryViewModel)); break; } return(JsonConvert.SerializeObject(new { Result = "OK", Record = result })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetInvoicesAndSummary(string filter, string FromDate, string ToDate, string Supplier, string InvoiceType, string Company, string Status, string Search, string AccountCode, string EmpID) { try { AppUA appUA = Session["AppUA"] as AppUA; SupplierInvoiceBundleViewModel Result = new SupplierInvoiceBundleViewModel(); DateTime?FDate = string.IsNullOrEmpty(FromDate) ? (DateTime?)null : DateTime.Parse(FromDate); DateTime?TDate = string.IsNullOrEmpty(ToDate) ? (DateTime?)null : DateTime.Parse(ToDate); Result.SupplierInvoiceSummary = Mapper.Map <SupplierInvoiceSummary, SupplierInvoiceSummaryViewModel>(_supplierInvoicesBusiness.GetSupplierInvoicesSummary(true)); Result.SupplierInvoices = Mapper.Map <List <SupplierInvoices>, List <SupplierInvoicesViewModel> >(_supplierInvoicesBusiness.GetAllSupplierInvoices(FDate, TDate, Supplier, InvoiceType, Company, Status, Search, AccountCode, EmpID)); if (filter != null && filter == "OD") { Result.SupplierInvoices = Result.SupplierInvoices.Where(m => m.PaymentDueDate < common.GetCurrentDateTime() && m.BalanceDue > 0).ToList(); } else if (filter != null && filter == "OI") { Result.SupplierInvoices = Result.SupplierInvoices.Where(m => m.PaymentDueDate >= common.GetCurrentDateTime() && m.BalanceDue > 0).ToList(); } else if (filter != null && filter == "FP") { Result.SupplierInvoices = Result.SupplierInvoices.Where(m => m.BalanceDue <= 0).ToList(); } return(JsonConvert.SerializeObject(new { Result = "OK", Records = Result })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateChartOfAccounts(ChartOfAccountsViewModel _chartOfAccountsObj) { try { object result = null; AppUA _appUA = Session["AppUA"] as AppUA; _chartOfAccountsObj.CommonObj = new CommonViewModel(); _chartOfAccountsObj.CommonObj.CreatedBy = _appUA.UserName; _chartOfAccountsObj.CommonObj.CreatedDate = _appUA.DateTime; _chartOfAccountsObj.CommonObj.UpdatedBy = _appUA.UserName; _chartOfAccountsObj.CommonObj.UpdatedDate = _appUA.DateTime; if (!string.IsNullOrEmpty(_chartOfAccountsObj.hdnCode)) { _chartOfAccountsObj.Code = _chartOfAccountsObj.hdnCode; _chartOfAccountsObj.Type = _chartOfAccountsObj.hdnType; } result = _chartOfAccountsBusiness.InsertUpdateChartOfAccounts(Mapper.Map <ChartOfAccountsViewModel, ChartOfAccounts>(_chartOfAccountsObj)); return(JsonConvert.SerializeObject(new { Result = "OK", Records = result })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetServiceCallChargeListByServiceCallID(Guid serviceCallID) { try { List <ServiceCallChargeViewModel> serviceCallChargeViewModelList = new List <ServiceCallChargeViewModel>(); if (serviceCallID == Guid.Empty) { ServiceCallChargeViewModel serviceCallChargeVM = new ServiceCallChargeViewModel() { ID = Guid.Empty, ServiceCallID = Guid.Empty, ChargeAmount = 0, OtherCharge = new OtherChargeViewModel() { Description = "", }, TaxType = new TaxTypeViewModel() { ValueText = "", } }; serviceCallChargeViewModelList.Add(serviceCallChargeVM); } else { serviceCallChargeViewModelList = Mapper.Map <List <ServiceCallCharge>, List <ServiceCallChargeViewModel> >(_serviceCallBusiness.GetServiceCallChargeDetailListByServiceCallID(serviceCallID)); } return(JsonConvert.SerializeObject(new { Status = "OK", Records = serviceCallChargeViewModelList, Message = "Success" })); } catch (Exception ex) { AppConstMessage cm = _appConstant.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Status = "ERROR", Records = "", Message = cm.Message })); } }
public string SpecialPayments(CustomerInvoicesViewModel _customerInvoicesObj) { try { AppUA appUA = Session["AppUA"] as AppUA; _customerInvoicesObj.commonObj = new CommonViewModel(); _customerInvoicesObj.commonObj.CreatedBy = appUA.UserName; _customerInvoicesObj.commonObj.CreatedDate = common.GetCurrentDateTime(); _customerInvoicesObj.commonObj.UpdatedBy = appUA.UserName; _customerInvoicesObj.commonObj.UpdatedDate = common.GetCurrentDateTime(); CustomerInvoicesViewModel CIVM = Mapper.Map <CustomerInvoice, CustomerInvoicesViewModel>(_customerInvoicesBusiness.InsertUpdateSpecialPayments(Mapper.Map <CustomerInvoicesViewModel, CustomerInvoice>(_customerInvoicesObj), appUA)); if ((_customerInvoicesObj.SpecialPayObj.ID != null) && (_customerInvoicesObj.SpecialPayObj.ID != Guid.Empty)) { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.UpdateSuccess, Records = CIVM })); } else { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.InsertSuccess, Records = CIVM })); } } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateDepartment(DepartmentViewModel departmentViewModel) { object result = null; try { AppUA _appUA = Session["AppUA"] as AppUA; departmentViewModel.commonObj = new CommonViewModel(); departmentViewModel.commonObj.CreatedBy = _appUA.UserName; departmentViewModel.commonObj.CreatedDate = _appUA.DateTime; departmentViewModel.commonObj.UpdatedBy = departmentViewModel.commonObj.CreatedBy; departmentViewModel.commonObj.UpdatedDate = departmentViewModel.commonObj.CreatedDate; switch (departmentViewModel.Operation) { case "Insert": result = _departmentBusiness.InsertDepartment(Mapper.Map <DepartmentViewModel, Department>(departmentViewModel)); break; case "Update": result = _departmentBusiness.UpdateDepartment(Mapper.Map <DepartmentViewModel, Department>(departmentViewModel)); break; } return(JsonConvert.SerializeObject(new { Result = "OK", Record = result })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateCompany(CompaniesViewModel _companyObj) { try { AppUA _appUA = Session["AppUA"] as AppUA; _companyObj.commonObj = new CommonViewModel(); _companyObj.commonObj.CreatedBy = _appUA.UserName; _companyObj.commonObj.CreatedDate = _appUA.DateTime; _companyObj.commonObj.UpdatedBy = _appUA.UserName; _companyObj.commonObj.UpdatedDate = _appUA.DateTime; CompaniesViewModel companyObj = Mapper.Map <Companies, CompaniesViewModel>(_companiesBusiness.InsertUpdateCompany(Mapper.Map <CompaniesViewModel, Companies>(_companyObj))); if (_companyObj.Code == "" || _companyObj.Code == null) { return(JsonConvert.SerializeObject(new { Result = "OK", Records = companyObj, Message = "Insertion successfull" })); } else { return(JsonConvert.SerializeObject(new { Result = "OK", Records = companyObj, Message = "Updation successfull" })); } } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateInvoice(CustomerInvoicesViewModel _customerInvoicesObj) { try { if (_customerInvoicesObj.TotalInvoiceAmount == 0) { throw new Exception("Please Enter Amount"); } if (_customerInvoicesObj.RefInvoice == null && _customerInvoicesObj.InvoiceType == "PB") { throw new Exception("Please Enter Reference Invoice"); } AppUA appUA = Session["AppUA"] as AppUA; _customerInvoicesObj.commonObj = new CommonViewModel(); _customerInvoicesObj.commonObj.CreatedBy = appUA.UserName; _customerInvoicesObj.commonObj.CreatedDate = common.GetCurrentDateTime(); _customerInvoicesObj.commonObj.UpdatedBy = appUA.UserName; _customerInvoicesObj.commonObj.UpdatedDate = common.GetCurrentDateTime(); CustomerInvoicesViewModel CIVM = Mapper.Map <CustomerInvoice, CustomerInvoicesViewModel>(_customerInvoicesBusiness.InsertUpdateInvoice(Mapper.Map <CustomerInvoicesViewModel, CustomerInvoice>(_customerInvoicesObj), appUA)); if (_customerInvoicesObj.ID != null && _customerInvoicesObj.ID != Guid.Empty) { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.UpdateSuccess, Records = CIVM })); } else { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.InsertSuccess, Records = CIVM })); } } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetAllOtherExpenseByApprovalStatus(string Status, string ExpenseDate, string DefaultDate) { try { List <OtherExpense> otherExpenseList = _otherExpenseBusiness.GetAllOtherExpenseByApprovalStatus((Status != "")?int.Parse(Status):0, ExpenseDate); if (!string.IsNullOrEmpty(DefaultDate)) { if (DefaultDate == "0") { otherExpenseList = otherExpenseList != null?otherExpenseList .ToList() : null; } else { ExpenseDate = DateTime.Now.AddDays(-int.Parse(DefaultDate)).ToString("dd-MMM-yyyy"); otherExpenseList = otherExpenseList != null?otherExpenseList .Where(o => DateTime.Parse(o.ExpenseDate).Date >= DateTime.Parse(ExpenseDate).Date && DateTime.Parse(o.ExpenseDate).Date <= DateTime.Now.Date) .ToList() : null; } } string sumAmount = _commonBusiness.ConvertCurrency(otherExpenseList != null ? otherExpenseList.Sum(o => o.Amount):decimal.Zero); return(JsonConvert.SerializeObject(new { Result = "OK", Records = otherExpenseList, TotalAmount = sumAmount })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string InsertUpdateEnquiryFollowup(EnquiryFollowupViewModel enquiryFollowupVM) { try { AppUA appUA = Session["AppUA"] as AppUA; enquiryFollowupVM.PSASysCommon = new PSASysCommonViewModel(); enquiryFollowupVM.PSASysCommon.CreatedBy = appUA.UserName; enquiryFollowupVM.PSASysCommon.CreatedDate = _pSASysCommon.GetCurrentDateTime(); enquiryFollowupVM.PSASysCommon.UpdatedBy = appUA.UserName; enquiryFollowupVM.PSASysCommon.UpdatedDate = _pSASysCommon.GetCurrentDateTime(); object result = _enquiryFollowupBusiness.InsertUpdateEnquiryFollowup(Mapper.Map <EnquiryFollowupViewModel, EnquiryFollowup>(enquiryFollowupVM)); if (enquiryFollowupVM.ID == Guid.Empty) { return(JsonConvert.SerializeObject(new { Status = "OK", Record = result, Message = "Insertion successfull" })); } else { return(JsonConvert.SerializeObject(new { Status = "OK", Record = result, Message = "Updation successfull" })); } } catch (Exception ex) { AppConstMessage cm = _appConstant.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Status = "ERROR", Record = "", Message = cm.Message })); } }
public string InsertUpdateAccountHeadGroup(AccountHeadGroupViewModel accountHeadGroup) { try { AppUA appUA = Session["AppUA"] as AppUA; accountHeadGroup.commonObj = new CommonViewModel(); accountHeadGroup.commonObj.CreatedBy = appUA.UserName; accountHeadGroup.commonObj.CreatedDate = common.GetCurrentDateTime(); accountHeadGroup.commonObj.UpdatedBy = appUA.UserName; accountHeadGroup.commonObj.UpdatedDate = common.GetCurrentDateTime(); AccountHeadGroupViewModel CIVM = Mapper.Map <AccountHeadGroup, AccountHeadGroupViewModel>(_accountHeadGroupBusiness.InsertUpdateAccountHeadGroup(Mapper.Map <AccountHeadGroupViewModel, AccountHeadGroup>(accountHeadGroup), appUA)); if (accountHeadGroup.ID != null && accountHeadGroup.ID != Guid.Empty) { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.UpdateSuccess, Records = CIVM })); } else { return(JsonConvert.SerializeObject(new { Result = "OK", Message = c.InsertSuccess, Records = CIVM })); } } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetMaximumReducibleAmount(string refNumber) { try { decimal amount = _otherExpenseBusiness.GetMaximumReducibleAmount(refNumber); return(JsonConvert.SerializeObject(new { Result = "OK", ReducibleAmount = amount })); } catch (Exception Ex) { AppConstMessage cm = c.GetMessage(Ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetEmployeeCompanyDetails(string ID) { try { List <EmployeeViewModel> employeeViewModelList = Mapper.Map <List <Employee>, List <EmployeeViewModel> >(_otherExpenseBusiness.GetCompanybyEmployee(Guid.Parse(ID))); return(JsonConvert.SerializeObject(new { Result = "OK", Records = employeeViewModelList })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetOpeningBalance(string OpeningDate) { try { OtherExpenseViewModel otherExpenseObj = Mapper.Map <OtherExpense, OtherExpenseViewModel>(_otherExpenseBusiness.GetOpeningBalance(OpeningDate)); return(JsonConvert.SerializeObject(new { Result = "OK", Records = otherExpenseObj })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string DeleteEnquiryFollowup(Guid id) { try { object result = _enquiryFollowupBusiness.DeleteEnquiryFollowup(id); return(JsonConvert.SerializeObject(new { Status = "OK", Record = result, Message = "Sucess" })); } catch (Exception ex) { AppConstMessage cm = _appConstant.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Status = "ERROR", Record = "", Message = cm.Message })); } }
public string GetEmployeeDetails(string ID) { try { EmployeeViewModel employeeObj = Mapper.Map <Employee, EmployeeViewModel>(_employeeBusiness.GetEmployeeDetails(ID != null && ID != "" ? Guid.Parse(ID) : Guid.Empty)); return(JsonConvert.SerializeObject(new { Result = "OK", Records = employeeObj })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetAllEmployees(string filter) { try { List <EmployeeViewModel> employeesList = Mapper.Map <List <Employee>, List <EmployeeViewModel> >(_employeeBusiness.GetAllEmployees(filter)); return(JsonConvert.SerializeObject(new { Result = "OK", Records = employeesList })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetAllSuppliers() { try { List <SuppliersViewModel> suppliersList = Mapper.Map <List <Supplier>, List <SuppliersViewModel> >(_SupplierBusiness.GetAllSuppliers()); return(JsonConvert.SerializeObject(new { Result = "OK", Records = suppliersList })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetSupplierDetails(string ID) { try { SuppliersViewModel supplierObj = Mapper.Map <Supplier, SuppliersViewModel>(_SupplierBusiness.GetSupplierDetails(ID != null && ID != "" ? Guid.Parse(ID) : Guid.Empty)); return(JsonConvert.SerializeObject(new { Result = "OK", Records = supplierObj })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string DeleteTaxType(int code) { try { var result = _taxTypeBusiness.DeleteTaxType(code); return(JsonConvert.SerializeObject(new { Status = "OK", Record = result, Message = "Success" })); } catch (Exception ex) { AppConstMessage cm = _appConst.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Status = "ERROR", Record = "", Message = cm.Message })); } }