public string Get(string FDate, string TDate, string RCode, string DCode, int type) { ManageSQLConnection sqlConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); try { if (type == 1) { ds = sqlConnection.GetDataSetValues("GetAllIncidentDetails"); } else { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDate", FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@TDate", TDate)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@DCode", DCode)); ds = sqlConnection.GetDataSetValues("GetIncidentDetails", sqlParameters); } return(JsonConvert.SerializeObject(ds.Tables[0])); } finally { ds.Dispose(); } }
public string Get(int Type = 0) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); try { if (Type == 1) { ds = manageSQLConnection.GetDataSetValues("GetNotificationPopup"); //string ImageName = ds.ImageName; string newPath = GlobalVariable.ImagePath; if (Directory.Exists(newPath)) { var ImageName = newPath + "/"; } //return JsonConvert.SerializeObject(ds.Tables[0]); } else { ds = manageSQLConnection.GetDataSetValues("GetNotificationsData"); } return(JsonConvert.SerializeObject(ds.Tables[0])); } finally { ds.Dispose(); } }
public string Get(string RCode = "0", int Type = 2) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); try { if (Type == 2) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@Type", Type.ToString())); ds = manageSQLConnection.GetDataSetValues("GetPartyNameDetails", sqlParameters); } else { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Type", Type.ToString())); ds = manageSQLConnection.GetDataSetValues("GetPartyNameDetails", sqlParameters); } return(JsonConvert.SerializeObject(ds.Tables[0])); } finally { ds.Dispose(); } }
public string Get(string Type, string TIN = null, string PartyName = null) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); try { if (Type == "Registered") { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@Type", Type.ToString())); sqlParameters.Add(new KeyValuePair <string, string>("@TIN", TIN)); ds = manageSQLConnection.GetDataSetValues("GetPartyLedgerdetails", sqlParameters); } else { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@Type", Type.ToString())); sqlParameters.Add(new KeyValuePair <string, string>("@PartyName", PartyName.ToString())); ds = manageSQLConnection.GetDataSetValues("GetPartyLedgerdetails", sqlParameters); } return(JsonConvert.SerializeObject(ds.Tables[0])); } finally { ds.Dispose(); } }
public string Get(string value, int Type, string GCode) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); if (Type == 1) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@SIDate", value)); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", GCode)); ds = manageSQLConnection.GetDataSetValues("GetStockIssueDetailsByDate", sqlParameters); } else if (Type == 2) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@SINo", value)); ds = manageSQLConnection.GetDataSetValues("GetStockIssueDetailsBySINo", sqlParameters); } else { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", value)); ds = manageSQLConnection.GetDataSetValues("GetGatePass", sqlParameters); } return(JsonConvert.SerializeObject(ds)); }
public string Get(string TicketID, int UserId) { // SQLConnection sqlConnection = new SQLConnection(); ManageSQLConnection sqlConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); try { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); if (TicketID == "A") { sqlParameters.Add(new KeyValuePair <string, string>("@UserId", UserId.ToString())); ds = sqlConnection.GetDataSetValues("GetMyTicket", sqlParameters); } else if (TicketID == "TD") { sqlParameters.Add(new KeyValuePair <string, string>("@UserId", UserId.ToString())); ds = sqlConnection.GetDataSetValues("GetTicketDescription", sqlParameters); } else { sqlParameters.Add(new KeyValuePair <string, string>("@TicketID", TicketID)); ds = sqlConnection.GetDataSetValues("ticketbyid", sqlParameters); } return(JsonConvert.SerializeObject(ds.Tables[0])); } finally { ds.Dispose(); } }
public Tuple <bool, string> Post(DocumentDeliveryOrderEntity deliveryOrderEntity = null) { if (deliveryOrderEntity.Type == 2) { ManageDocumentDeliveryOrder documentDO = new ManageDocumentDeliveryOrder(); documentDO.GenerateDeliveryOrderText(deliveryOrderEntity); return(new Tuple <bool, string>(true, "Print Generated Successfully")); } else { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", deliveryOrderEntity.IssuerCode)); var result = manageSQLConnection.GetDataSetValues("AllowDocumentEntry", sqlParameters); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(result)) { //Check data is available in GSTSalesTax table List <KeyValuePair <string, string> > sqlParameters1 = new List <KeyValuePair <string, string> >(); sqlParameters1.Add(new KeyValuePair <string, string>("@BillNo", deliveryOrderEntity.Dono.Trim())); var result1 = manageSQLConnection.GetDataSetValues("GetSalesTaxByBillNo", sqlParameters1); if (manageReport.CheckDataAvailable(result1)) { return(new Tuple <bool, string>(false, GlobalVariable.DocumentEditPermissionForDO)); } ManageDeliveryOrder manageDelivery = new ManageDeliveryOrder(); return(manageDelivery.InsertDeliveryOrderEntry(deliveryOrderEntity)); } else { return(new Tuple <bool, string>(false, "Permission not Granted")); } } }
public string Post([FromBody] ReportParameter reportParameter) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", reportParameter.FromDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", reportParameter.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", reportParameter.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", reportParameter.RCode)); if (reportParameter.Type == 1) { ds = manageSQLConnection.GetDataSetValues("LoadMenwagesLoading", sqlParameters); } else { ds = manageSQLConnection.GetDataSetValues("LoadMenwagesUnLoading", sqlParameters); } //StockReceiptRegister stockDeliveryOrder = new StockReceiptRegister(); //ManageReport manageReport = new ManageReport(); //if (manageReport.CheckDataAvailable(ds)) //{ // CommonEntity entity = new CommonEntity // { // dataSet = ds, // GCode = reportParameter.GCode, // FromDate = reportParameter.FromDate, // Todate = reportParameter.ToDate, // UserName = reportParameter.UserName // }; // Task.Run(() => stockDeliveryOrder.GenerateStockReceiptRegister(entity)); //Generate the Report //} return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Get(string Month, string Year, string GCode, string Type) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); try { if (Type == "1") { sqlParameters.Add(new KeyValuePair <string, string>("@GCode", GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Month", Month)); sqlParameters.Add(new KeyValuePair <string, string>("@Year", Year)); ds = manageSQLConnection.GetDataSetValues("GetAllotmetforSociety", sqlParameters); } else { sqlParameters.Add(new KeyValuePair <string, string>("@GCode", GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@IRelates", Month)); ds = manageSQLConnection.GetDataSetValues("GetAllotmentShopDetails", sqlParameters); } return(JsonConvert.SerializeObject(ds)); } finally { ds.Dispose(); } }
public string Post(TransactionEntity entity) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > listParameters = new List <KeyValuePair <string, string> >(); if (entity.Type == 1) { listParameters.Add(new KeyValuePair <string, string>("@Docdate", entity.Docdate)); listParameters.Add(new KeyValuePair <string, string>("@Gcode", entity.Gcode)); listParameters.Add(new KeyValuePair <string, string>("@RoleId", entity.RoleId)); ds = manageSQLConnection.GetDataSetValues("GetTransactionstatus", listParameters); return(JsonConvert.SerializeObject(ds.Tables[0])); } else { ManageStackCard manageStack = new ManageStackCard(); listParameters.Add(new KeyValuePair <string, string>("@Docdate", entity.Docdate)); listParameters.Add(new KeyValuePair <string, string>("@RCode", entity.RCode)); listParameters.Add(new KeyValuePair <string, string>("@RoleId", entity.RoleId)); ds = manageSQLConnection.GetDataSetValues("GetTransactionStatusByDate", listParameters); //Manage Transactionstatus var result = manageStack.ManageApprovalStatus(ds, entity.Docdate); return(JsonConvert.SerializeObject(result)); } }
public string Post(StockPayement stockPayement) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); if (stockPayement.Type == 1) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@DoDate", stockPayement.DoDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ReceivorCode", stockPayement.ReceivorCode)); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", stockPayement.GCode)); ds = manageSQLConnection.GetDataSetValues("GetPaymentDetailsForShop", sqlParameters); return(JsonConvert.SerializeObject(ds.Tables[0])); } else { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@DoDate", stockPayement.DoDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ReceivorCode", stockPayement.ReceivorCode)); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", stockPayement.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@DoNo", stockPayement.DoNo)); ds = manageSQLConnection.GetDataSetValues("GetPreviousBalance", sqlParameters); return(JsonConvert.SerializeObject(ds.Tables[0])); } }
public string Post(LorryDetailEntity lorryDetail) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); if (lorryDetail.DType == "G") { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", lorryDetail.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", lorryDetail.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@fromdate", lorryDetail.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@type", lorryDetail.DType)); ds = manageSQLConnection.GetDataSetValues("GetDSlORRYNOGATEPASS", sqlParameters); } else { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@lorno", lorryDetail.LorryNo)); sqlParameters.Add(new KeyValuePair <string, string>("@fromdate", lorryDetail.FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@todate", lorryDetail.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@type", lorryDetail.DType)); ds = manageSQLConnection.GetDataSetValues("GetDSlORRYNO", sqlParameters); } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public Tuple <bool, string, string> Post(DocumentStockReceiptList stockReceipt = null) { ManageDocumentReceipt documentReceipt = new ManageDocumentReceipt(); if (stockReceipt.Type == 2) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); documentReceipt.GenerateReceipt(stockReceipt); //update print if (stockReceipt.UnLoadingSlip == "N" || string.IsNullOrEmpty(stockReceipt.UnLoadingSlip)) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@SRNo", stockReceipt.SRNo)); manageSQLConnection.UpdateValues("UpdateSRDetailsUnLoading", sqlParameters); } return(new Tuple <bool, string, string>(true, "Print Generated Sucessfully", "")); } else { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", stockReceipt.ReceivingCode)); var result = manageSQLConnection.GetDataSetValues("AllowDocumentEntry", sqlParameters); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(result)) { if (stockReceipt.SRNo.Trim() != "0" && stockReceipt.SRNo.Trim() != "-") { List <KeyValuePair <string, string> > sqlParameters1 = new List <KeyValuePair <string, string> >(); sqlParameters1.Add(new KeyValuePair <string, string>("@Type", "1")); sqlParameters1.Add(new KeyValuePair <string, string>("@DocNumber", stockReceipt.SRNo.Trim())); var result1 = manageSQLConnection.GetDataSetValues("CheckDocumentEdit", sqlParameters1); if (!manageReport.CheckDataAvailable(result1)) { return(new Tuple <bool, string, string>(false, GlobalVariable.DocumentEditPermission, "")); } // CheckDocumentEdit } else if (documentReceipt.CheckSRUpdateStatus(stockReceipt.SRNo)) { return(new Tuple <bool, string, string>(false, GlobalVariable.DocumentEditByHO, "")); } StockReceipt receipt = new StockReceipt(); return(receipt.InsertReceiptData(stockReceipt)); } else { return(new Tuple <bool, string, string>(false, "Permission not Granted", "")); } } }
public string Post([FromBody] ReportParameter reportParameter) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", reportParameter.FromDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", reportParameter.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", reportParameter.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", reportParameter.RCode)); ds = manageSQLConnection.GetDataSetValues("StockReceiptForRegister", sqlParameters); StockReceiptRegister stockDeliveryOrder = new StockReceiptRegister(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = reportParameter.GCode, FromDate = reportParameter.FromDate, Todate = reportParameter.ToDate, UserName = reportParameter.UserName }; Task.Run(() => stockDeliveryOrder.GenerateStockReceiptRegister(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Post([FromBody] GUGRParameter reportParameter) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", reportParameter.FromDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", reportParameter.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", reportParameter.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", reportParameter.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Type", reportParameter.Type)); ds = manageSQLConnection.GetDataSetValues("GETGRGU", sqlParameters); ManageGUGR manageGUGR = new ManageGUGR(); ManageReport manageReport = new ManageReport(); //filter condotions if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = reportParameter.GCode, FromDate = reportParameter.FromDate, Todate = reportParameter.ToDate, UserName = reportParameter.UserName }; // commodityIssueMemo.GenerateCommodityIssueMemoReport(entity); Task.Run(() => manageGUGR.GenerateGUGRReport(entity, reportParameter)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Get(string FDate, string ToDate, string GCode, string Username, string RCode) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDate", FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", RCode)); ds = manageSQLConnection.GetDataSetValues("GetTransitdetails", sqlParameters); ManageTruckTransit manageTruckToRegion = new ManageTruckTransit(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = GCode, FromDate = FDate, Todate = ToDate, UserName = Username, GName = ds.Tables[0].Rows[0]["TNCSName"].ToString(), RName = ds.Tables[0].Rows[0]["Region"].ToString() }; Task.Run(() => manageTruckToRegion.GenerateTruckTransit(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Post([FromBody] CommodityParameter commodity) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDate", commodity.FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", commodity.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", commodity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@ITCode", commodity.TRCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", commodity.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@IssuedToGodown", Convert.ToString(commodity.IssueToGodown))); sqlParameters.Add(new KeyValuePair <string, string>("@IssuedToDepositor", Convert.ToString(commodity.IssueToDepositor))); ds = manageSQLConnection.GetDataSetValues("GetCommodityIssueMemo", sqlParameters); CommodityIssueMemo commodityIssueMemo = new CommodityIssueMemo(); ManageReport manageReport = new ManageReport(); //filter condotions if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = commodity.GCode, FromDate = commodity.FDate, Todate = commodity.ToDate, UserName = commodity.UserName }; // commodityIssueMemo.GenerateCommodityIssueMemoReport(entity); Task.Run(() => commodityIssueMemo.GenerateCommodityIssueMemoReport(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Get(string FDate, string TDate, string RCode, string DCode, string Product, string Component, string Shops, int type) { // SQLConnection sqlConnection = new SQLConnection(); ManageSQLConnection sqlConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); string procedureName = string.Empty; try { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@fromdate", FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@todate", TDate)); if (type == 1) { procedureName = "GetTicketsByDate"; } else { sqlParameters.Add(new KeyValuePair <string, string>("@RCode", RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@DCode", DCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Product", Product)); sqlParameters.Add(new KeyValuePair <string, string>("@Component", Component)); sqlParameters.Add(new KeyValuePair <string, string>("@Shops", Shops)); procedureName = "GetTickets"; } ds = sqlConnection.GetDataSetValues(procedureName, sqlParameters); return(JsonConvert.SerializeObject(ds.Tables[0])); } finally { ds.Dispose(); } }
public string Get(int roleId) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); KeyValuePair <string, string> parameterValues = new KeyValuePair <string, string>(); ManageMenu manageMenu = new ManageMenu(); DataSet ds = new DataSet(); try { parameterValues = new KeyValuePair <string, string>("@RoleId", Convert.ToString(roleId)); parameterList.Add(parameterValues); ds = manageSQLConnection.GetDataSetValues("GetMenuMaster", parameterList); List <Menu> menus = new List <Menu>(); menus = manageMenu.ConvertDataTableToList(ds.Tables[0]); var reult = manageMenu.GetMenuTree(menus, 0); return(JsonConvert.SerializeObject(reult)); } finally { ds.Dispose(); parameterList = null; manageMenu = null; } }
public string Post(DeliveryOrderSchemeWiseEntity marginAmount) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", marginAmount.FromDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", marginAmount.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", marginAmount.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", marginAmount.RCode)); ds = manageSQLConnection.GetDataSetValues("GetDeliveryOrderMarginAmount", sqlParameters); ManageDOMargin manageDOMargin = new ManageDOMargin(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = marginAmount.GCode, FromDate = marginAmount.FromDate, Todate = marginAmount.ToDate, UserName = marginAmount.UserName, GName = marginAmount.GName, RName = marginAmount.RName }; // commodityIssueMemo.GenerateCommodityIssueMemoReport(entity); Task.Run(() => manageDOMargin.GenerateDOMarginReport(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Post([FromBody] DemandDraftEntity demandDraft) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", demandDraft.FromDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", demandDraft.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", demandDraft.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", demandDraft.RCode)); ds = manageSQLConnection.GetDataSetValues("Get_demanddraftdetails", sqlParameters); ManageDemandDraft manageDemand = new ManageDemandDraft(); ManageReport manageReport = new ManageReport(); //filter condotions if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = demandDraft.GCode, FromDate = demandDraft.FromDate, Todate = demandDraft.ToDate, UserName = demandDraft.UserName, GName = demandDraft.GName, RName = demandDraft.RName }; // commodityIssueMemo.GenerateCommodityIssueMemoReport(entity); Task.Run(() => manageDemand.GenerateDemandDraftReport(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Get(string GCode, int Type = 0) { if (Type == 1) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", GCode)); ds = manageSQLConnection.GetDataSetValues("GetIssuerPartyMaster", sqlParameters); return(JsonConvert.SerializeObject(ds.Tables[0])); } else if (Type == 2) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@GodCode", GCode)); ds = manageSQLConnection.GetDataSetValues("GetIssuersMasterAllData", sqlParameters); return(JsonConvert.SerializeObject(ds.Tables[0])); } else { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", GCode)); ds = manageSQLConnection.GetDataSetValues("GetIssuerMaster", sqlParameters); return(JsonConvert.SerializeObject(ds.Tables[0])); } }
public string Post([FromBody] CommodityParameter commodity) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDate", commodity.FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", commodity.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", commodity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", commodity.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@TRCODE", commodity.TRCode)); sqlParameters.Add(new KeyValuePair <string, string>("@ITCode", commodity.ITCode)); ds = manageSQLConnection.GetDataSetValues("GetCOMMODITYRECEIPT", sqlParameters); // CommodityReceipt commodityReceipt = new CommodityReceipt(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = commodity.GCode, FromDate = commodity.FDate, Todate = commodity.ToDate, UserName = commodity.UserName, // SchemeName = commodity.SchemeName, }; Task.Run(() => commodityReceipt.GenerateCommodityReceiptReport(entity, commodity.ITName, commodity.TRName)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Post([FromBody] CommodityParameter commodity) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDate", commodity.FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", commodity.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@GodCode", commodity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", commodity.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@TRCODE", commodity.TRCode)); ds = manageSQLConnection.GetDataSetValues("GetTransactionReceipt", sqlParameters); TransactionReceipt stockDeliveryOrder = new TransactionReceipt(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = commodity.GCode, FromDate = commodity.FDate, Todate = commodity.ToDate, UserName = commodity.UserName }; Task.Run(() => stockDeliveryOrder.GenerateTransactionReceipt(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public Tuple <bool, bool> Post(StackOpeningEntity stackOpeningEntity = null) { ManageSQLConnection manageSQL = new ManageSQLConnection(); ManageStackCard manageStack = new ManageStackCard(); if (!string.IsNullOrEmpty(stackOpeningEntity.StackNo) && !string.IsNullOrEmpty(stackOpeningEntity.CurrYear)) { if (stackOpeningEntity.CurrYear.Length != 4 || stackOpeningEntity.CurrYear.ToUpper() == "NULL") { return(new Tuple <bool, bool>(false, false)); } bool isInserted = false; DataSet ds = new DataSet(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@OBDate", stackOpeningEntity.ObStackDate)); sqlParameters.Add(new KeyValuePair <string, string>("@CurYear", stackOpeningEntity.CurrYear)); sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stackOpeningEntity.GodownCode)); sqlParameters.Add(new KeyValuePair <string, string>("@StackNo", stackOpeningEntity.StackNo)); ds = manageSQL.GetDataSetValues("FetchStackCard", sqlParameters); var result = manageStack.CheckStackCard(ds); if (!result) { isInserted = manageSQL.InsertStackOpening(stackOpeningEntity); } isInserted = manageSQL.InsertStackOpening(stackOpeningEntity); return(new Tuple <bool, bool>(result, isInserted)); } else { return(new Tuple <bool, bool>(false, false)); } }
public string Post([FromBody] CommodityParameter commodity) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDATE", commodity.FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", commodity.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", commodity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", commodity.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@ScCode", commodity.TRCode)); ds = manageSQLConnection.GetDataSetValues("GetSchemeIssueMemo", sqlParameters); SchemeIssueMemo schemeIssue = new SchemeIssueMemo(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = commodity.GCode, FromDate = commodity.FDate, Todate = commodity.ToDate, UserName = commodity.UserName }; Task.Run(() => schemeIssue.GenerateSchemeIssueMemoReport(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Post(DeliveryOrderSchemeWiseEntity SchemeWise) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", SchemeWise.FromDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", SchemeWise.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", SchemeWise.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Schcode", SchemeWise.SchCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", SchemeWise.RCode)); ds = manageSQLConnection.GetDataSetValues("GetDeliveryOrdersOtherScheme", sqlParameters); ManageDOOthers manageDOSPLPDS = new ManageDOOthers(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = SchemeWise.GCode, FromDate = SchemeWise.FromDate, Todate = SchemeWise.ToDate, UserName = SchemeWise.UserName, GName = SchemeWise.GName, RName = SchemeWise.RName }; // manageDOAllScheme.GenerateDOAllSchemeReport(entity); Task.Run(() => manageDOSPLPDS.GenerateDOOthersScheme(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Get(string sValue, int Type = 1) { DataSet ds = new DataSet(); try { if (Type == 1) { ManageSQLConnection manageSQL = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@TNCSCKey", sValue)); sqlParameters.Add(new KeyValuePair <string, string>("@Type", "1")); ds = manageSQL.GetDataSetValues("GetTNCSCSettings", sqlParameters); return(JsonConvert.SerializeObject(ds.Tables[0])); } else { ManageSQLConnection manageSQL = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@TNCSCKey", sValue)); sqlParameters.Add(new KeyValuePair <string, string>("@Type", Type.ToString())); ds = manageSQL.GetDataSetValues("GetTNCSCSettings", sqlParameters); return(JsonConvert.SerializeObject(ds)); } } finally { ds.Dispose(); } }
public string Get(string FDate, string ToDate, string GCode, string UserName, string RCode) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDate", FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", RCode)); ds = manageSQLConnection.GetDataSetValues("GetHullingDetails", sqlParameters); HullingDetails hullingDetails = new HullingDetails(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = GCode, FromDate = FDate, Todate = ToDate, UserName = UserName }; Task.Run(() => hullingDetails.GenerateHullingReport(entity)); } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Post([FromBody] PurchaseParameter reportParameter) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDATE", reportParameter.FromDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", reportParameter.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", reportParameter.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@orderno", reportParameter.OrderNo)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", reportParameter.RCode)); ds = manageSQLConnection.GetDataSetValues("Getrono", sqlParameters); RoNoController RoNoPurchase = new RoNoController(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = reportParameter.GCode, FromDate = reportParameter.FromDate, Todate = reportParameter.ToDate, UserName = reportParameter.UserName }; Task.Run(() => RoNoPurchase.GenerateRoNoPurchase(entity)); } return(JsonConvert.SerializeObject(ds.Tables[0])); }