public async Task <ApiResponse> AllAgent() { var listAgentMaster = await _context.TblAgentMaster.ToListAsync(); var listCompany = await _context.TblCompany.ToListAsync(); var items = (from lam in listAgentMaster join lc in listCompany on lam.CompanyId equals lc.Id select new { Id = lam.Id, AgentName = lam.AgentName, ContactPerson = lam.ContactPerson, AgentAddress = lam.AgentAddress, Fax = lam.Fax, Phone = lam.Phone, Telephone = lam.Telephone, Email = lam.Email, RecordDate = lam.RecordDate, UpdateDate = lam.UpdateDate, DeleteStatus = lam.DeleteStatus, CompanyId = lam.CompanyId, CompanyName = listCompany.Where(i => i.Id == lam.CompanyId).FirstOrDefault().CompanyName } ).ToList(); var ApiResponse = await response.ApiResult("OK", items, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> AllInstallment() { var listcustomer = await _context.TblCustomerMaster.ToListAsync(); var listinstallment = await _context.TblInstallment.ToListAsync(); var items = (from li in listinstallment join lc in listcustomer on li.CustomerId equals lc.Id select new { id = li.Id, stockNumber = li.StockNumber, customerId = li.CustomerId, salemanId = li.SalemanId, salePrice = li.SalePrice, downPayment = li.DownPayment, timeDurationYears = li.TimeDurationYears, totalInstallment = li.TotalInstallment, taxPer = li.TaxPer, taxAmount = li.TaxAmount, finalAmount = li.FinalAmount, installAmount = li.InstallAmount, status = li.Status, createdDate = li.CreatedDate, updatedDate = li.UpdatedDate, deletedDate = li.DeletedDate, invoiceNumber = li.InvoiceNumber, installmentmode = li.Installmentmode, day = li.Day, // paymentMode=li.PaymentMode, customerName = lc.CustomerName, customerCode = lc.CustomerCode }).ToList(); var ApiResponse = await response.ApiResult("OK", items, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> AllYard() { var listYard = await _context.TblYard.OrderBy(i => i.Name).ToListAsync(); // var AgentIdlist = (from ld in listYard select new { ld.AgentId }).ToList(); var agentlist = await _context.TblAgentMaster.ToListAsync(); var portlist = await _context.TblPortMaster.ToListAsync(); var items = (from lY in listYard select new { id = lY.Id, name = lY.Name, numberOfFreeDay = lY.NumberOfFreeDay, handlingChages = lY.HandlingChages, radiationCharges = lY.RadiationCharges, godownCharges = lY.GodownCharges, otherCharges = lY.OtherCharges, portlist = portlist.Where(i => ConvertStringToIntList(lY.PortId).Contains(Convert.ToInt32(i.Id))), agentlist = agentlist.Where(i => ConvertStringToIntList(lY.AgentId).Contains(Convert.ToInt32(i.Id))), portid = lY.PortId }).ToList(); var ApiResponse = await response.ApiResult("OK", items, "Data Found"); return(ApiResponse); }
public async Task <ApiResponse> Login(TblUserMaster objuser) { var loginDetail = await _context.TblUserMaster.Where(i => i.Email == objuser.Email && i.Password == objuser.Password && i.Active == true && i.DeleteStatus == null).ToListAsync(); if (loginDetail.Count == 1) { var listGroupMaster = await _context.TblGroupMaster.ToListAsync(); var items = (from lu in loginDetail join lg in listGroupMaster on lu.UserTypeId equals lg.Id select new { emailId = lu.Email, userId = lu.Id, userName = lu.UserName, userTypeName = lg.GroupName, userTypeId = lu.UserTypeId }) .ToList(); var ApiResponse = await response.ApiResult("OK", items, "Data Found"); return(ApiResponse); } else { var ApiResponse = await response.ApiResult("OK", "", "Email/Password Wrong"); return(ApiResponse); } }
public async Task <ApiResponse> AllProduct() { var categoryList = await _context.TblCategoryMaster.ToListAsync(); var varientname = categoryList.Where(i => i.Type == "Variant").Select(i => i.CategoryType).FirstOrDefault(); var productList = await _context.TblProduct.ToListAsync(); var items = (from pl in productList select new { prodictid = pl.Id, productType = pl.ProductType, typeid = pl.Typeid, modelid = pl.ModelId, makerid = pl.MakerId, chassisType = pl.ChassisType, drive = pl.Drive, fule = pl.Fuel, noOfDoor = pl.NoOfDoors, noOfSeat = pl.NoOfSeats, engine_cc = pl.EngineCc, makername = categoryList.Where(i => i.Id == pl.MakerId).Select(i => i.CategoryType).FirstOrDefault() != null ? categoryList.Where(i => i.Id == pl.MakerId).Select(i => i.CategoryType).FirstOrDefault() : "N/A" , modelname = categoryList.Where(i => i.Id == pl.ModelId && i.Type == "ModelMaster").Select(i => i.CategoryType).FirstOrDefault() != null ? categoryList.Where(i => i.Id == pl.ModelId && i.Type == "ModelMaster").Select(i => i.CategoryType).FirstOrDefault() : "N/A" , type = categoryList.Where(i => i.Id == pl.Typeid && i.Type == "TypeMaster").Select(i => i.CategoryType).FirstOrDefault() != null ? categoryList.Where(i => i.Id == pl.Typeid && i.Type == "TypeMaster").Select(i => i.CategoryType).FirstOrDefault() : "N/A" , variant = categoryList.Where(i => i.Id == pl.VariantId && i.Type == "Variant").Select(i => i.CategoryType).FirstOrDefault() != null ? categoryList.Where(i => i.Id == pl.VariantId && i.Type == "Variant").Select(i => i.CategoryType).FirstOrDefault() : "N/A" }).OrderBy(i => i.makername).ToList(); var ApiResponse = await response.ApiResult("OK", items, "Product Found"); return(ApiResponse); }
public async Task <ApiResponse> GetAllCurrency() { var listCurrency = await _context.TblCurrencyMaster.ToListAsync(); var ApiResponse = await response.ApiResult("OK", listCurrency, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> AllCompany() { var items = await _context.TblCompany.OrderByDescending(i => i.Id).ToListAsync(); var ApiResponse = await response.ApiResult("OK", items, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> AllVesselName() { var items = await _context.TblVesselName.ToListAsync(); var ApiResponse = await response.ApiResult("OK", items, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> InvoiceGeneratedList() { var currencyList = await _context.TblCurrencyMaster.ToListAsync(); var salemanList = await _context.TblUserMaster.ToListAsync(); var customerList = await _context.TblCustomerMaster.ToListAsync(); var stockList = await _context.TblStock.ToListAsync(); var productList = await _context.TblProduct.ToListAsync(); var colorList = await _context.TblColor.ToListAsync(); var productStocklist = (from ls in stockList join lp in productList on ls.ProductId equals lp.Id join lc in colorList on ls.ColorId equals lc.Id select new { StockNumber = ls.StockNumber, Fuel = lp.Fuel, ChassisType = lp.ChassisType, Drive = lp.Drive, Color = lc.Name }).ToList(); var items = await _context.TblInvoice.Where(i => i.Status == "Sale").ToListAsync(); var item = (from it in items select new { StockNumber = it.StockNumber, ProductName = "Product Name", // Customer="Customer", //SalesMan="SalesMan", Status = it.Status, SaleReffNo = "SaleReffNO", SaleDate = it.SaleDate, SalePrice = it.SalePrice, PaymentStatus = it.PaymentStatus, PaidAmount = it.PaidAmount, BalanceAmount = it.BalanceAmount, IndividualInvoiceNumber = it.IndividualInvoiceNumber, InvoiceNumber = it.InvoiceNumber, NotifyParty = it.NotifyParty, ConsigneeName = it.ConsigneeName, ConsigneeAddress = it.ConsigneeAddress, CFS = it.Cfs, Detail = productStocklist.Where(i => i.StockNumber == it.StockNumber), Customer = customerList.Where(i => i.Id == it.CustomerId).FirstOrDefault().CustomerName, Salesman = salemanList.Where(i => i.Id == it.UserId).FirstOrDefault().UserName, CurrencyName = currencyList.Where(i => i.Id == it.CurrencyId).FirstOrDefault().Name, CancelDate = it.CancelDate }).OrderByDescending(i => i.SaleDate).ToList(); var ApiResponse = await response.ApiResult("OK", item, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> GetCustomerTT() { try{ var ttList = await _context.TblCustomerTt.Where(i => i.Id == 13).ToListAsync(); var currencyList = await _context.TblCurrencyMaster.ToListAsync(); var salemanList = await _context.TblUserMaster.ToListAsync(); var customerList = await _context.TblCustomerMaster.ToListAsync(); var banklist = await _context.TblBank.ToListAsync(); var items = (from tt in ttList select new { ttstatus = tt.Ttstatus, customername = customerList.Where(i => i.Id == tt.Customerid).FirstOrDefault().CustomerName, customercode = customerList.Where(i => i.Id == tt.Customerid).FirstOrDefault().CustomerCode, bankreferance = "bank reference", receivedbankname = banklist.Where(i => i.Id == tt.ReceivedBankId).FirstOrDefault().Name, date = tt.RecordDate, remmiterbankname = tt.RemmiterBankName, remmitername = tt.RemmiterName, currency = currencyList.Where(i => i.Id == tt.CurrencyId).FirstOrDefault().Name, amount = tt.Amount, bankcharges = tt.BankCharges, totalttamount = tt.ToatalAmount, confirmby = tt.ComfirmBy, ttremark = tt.Remarks, transferamount = tt.TransferAmount, transferbankcharges = tt.BankCharges, refundamount = tt.RefundAmount, refundbankcharges = tt.RefundBankCharge, receivedamount = tt.ReceviedAmount, receivedremarks = tt.ReceviedRemarks, transferremarks = tt.TransferRemarks, refundremarks = tt.RefundRemarks, updatedate = tt.UpdateDate }).ToList(); var ApiResponse = await response.ApiResult("OK", items, "Record Found"); return(ApiResponse); } catch (Exception ex) { var ApiResponseCatch = await response.ApiResult("OK", "", ex.ToString()); return(ApiResponseCatch); } }
public async Task <ApiResponse> AllAuction() { var items = await _context.TblAuctionMaster.ToListAsync(); var ApiResponse = await response.ApiResult("OK", items, "Data Found"); return(ApiResponse); }
public async Task <ApiResponse> AllCustomer() { try { var listcustomer = await _context.TblCustomerMaster.Where(i => i.DeleteStatus == null).OrderBy(i => i.CustomerName).ToListAsync(); var ApiResponse = await response.ApiResult("OK", listcustomer, "Record Found"); return(ApiResponse); } catch (Exception ex) { var ApiResponseCatch = await response.ApiResult("OK", ex, "Error "); return(ApiResponseCatch); } }
//public async Task<ActionResult<IEnumerable<TblStock>>> GetStockByNumber(TblStock tblStock) //{ // var tblStockResult = await _context.TblStock.Where(i=>i.StockNumber==tblStock.StockNumber).ToListAsync(); // if (tblStock == null) // { // return NotFound(); // } // return tblStockResult; //} public async Task <ApiResponse> GetStockByNumber(TblStock tblStock) { ApiResponse response = new ApiResponse(); string message = "Record Not Found"; try { List <TblStock> listStock = new List <TblStock>(); if (tblStock.StockNumber != "") { var stockArray = tblStock.StockNumber.Split(','); for (int i = 0; i < stockArray.Length; i++) { var stocknumber = stockArray[i].ToString(); var listinvoice = await _context.TblInvoice.Where(j => j.StockNumber == stocknumber).ToListAsync(); if (listinvoice.Count == 0) { List <TblStock> tblStockResult = await _context.TblStock.Where(j => j.StockNumber == stocknumber).ToListAsync(); listStock.AddRange(tblStockResult); } } if (listStock.Count == 0) { //message; } else { message = "Record Found"; } } var ApiResponse = await response.ApiResult("OK", listStock, message); return(ApiResponse); } catch (Exception ex) { var ApiResponse = await response.ApiResult("FAILED", "", ex.ToString()); return(ApiResponse); } }
public async Task <ApiResponse> AllVessel() { var countrylist = await _context.TblCountryMaster.ToListAsync(); var vesselnameList = await _context.TblVesselName.ToListAsync(); var shippingAgentlist = await _context.TblShippingAgent.ToListAsync(); var yardlist = await _context.TblYard.ToListAsync(); var vesselmasterList = await _context.TblVesselMaster.ToListAsync(); var items = (from vm in vesselmasterList select new { id = vm.Id, vesselname = vesselnameList.Where(i => i.Id == vm.VesselNameId).Select(i => i.VesselName).FirstOrDefault(), voyageno = vm.VoyageNo, vesseltype = vm.VesselType, ispackagedeal = vm.IsPackageDeal, noofcontainer = vm.NoOfContainer, yardname = yardlist.Where(i => vm.YardId.Contains((i.Id).ToString())).Select(i => i.Name), source = countrylist.Where(i => i.Id == vm.SourceCountryId).Select(i => i.CountryName), destination = countrylist.Where(i => i.Id == vm.DestinationCountryId).Select(i => i.CountryName), shippingagent = shippingAgentlist.Where(i => vm.ShippingAgentid.Contains((i.Id).ToString())).Select(i => i.ShippingAgentName), etddate = vm.Etddate, lastofconsigneedate = vm.LastConsigneDate, lastofcfsdate = vm.LastCfsdate }).ToList(); var ApiResponse = await response.ApiResult("OK", items, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> AllPort() { var items = await _context.TblPortMaster.OrderBy(i => i.PortName).ToListAsync(); var ApiResponse = await response.ApiResult("OK", items, "Data Found"); return(ApiResponse); }
public async Task <ApiResponse> AddAttribute(TblAttribute tblAttribute) { try { _context.TblAttribute.Add(tblAttribute); await _context.SaveChangesAsync(); var ApiResponse = await GetAllProduct(); return(ApiResponse); } catch (Exception ex) { var ApiResponse = await response.ApiResult("FAILED", ex, "Error Data Insert"); return(ApiResponse); } // return CreatedAtAction("GetTblAttribute", new { id = tblAttribute.Id }, tblAttribute); }
public async Task <ActionResult <ApiResponse> > AllCategory(TblCategoryMaster tblobj) { var items = await _context.TblCategoryMaster.Where(i => i.Type == tblobj.Type).ToListAsync(); var ApiResponse = await response.ApiResult("OK", items, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> AllCountry() { var listCountry = await _context.TblCountryMaster.OrderByDescending(i => i.Id).ToListAsync(); var ApiResponse = await response.ApiResult("OK", listCountry, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> TransportationByPortAuction(TblTransportation tbltransportation) { var companylist = await _context.TblCompany.Distinct().ToListAsync(); var transportList = await _context.TblTransportation.Where(i => i.SourceId == tbltransportation.SourceId && i.DesstinationId == tbltransportation.DesstinationId && i.TypeId == tbltransportation.TypeId).ToListAsync(); var items = (from tl in transportList select new { id = tl.Id, name = companylist.Where(i => i.Id == tl.CompanyId).Select(i => i.CompanyName).FirstOrDefault() }).ToList(); var ApiResponse = await response.ApiResult("OK", items, "Record Found"); return(ApiResponse); }
public async Task <ApiResponse> UpdateBank(TblBank tblBank) { _context.Entry(tblBank).State = EntityState.Modified; _context.Entry(tblBank).Property(x => x.RecordDate).IsModified = false; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { var ApiResponse = await response.ApiResult("FAILED", "", "Bank Not Found"); return(ApiResponse); } var responseBank = await GetAllBanks(); return(responseBank); }