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 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] OCREntity oCREntity)
{
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", oCREntity.FromDate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", oCREntity.ToDate));
sqlParameters.Add(new KeyValuePair <string, string>("@GCode", oCREntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@RCode", oCREntity.RCode));
ds = manageSQLConnection.GetDataSetValues("GetOCRReport", sqlParameters);
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(ds))
{
ManageOCRReport manageOCR = new ManageOCRReport();
CommonEntity entity = new CommonEntity
{
dataSet = ds,
GCode = oCREntity.GCode,
FromDate = oCREntity.FromDate,
Todate = oCREntity.ToDate,
UserName = oCREntity.UserID,
GName = oCREntity.GName,
RName = oCREntity.RName
};
Task.Run(() => manageOCR.GenerateOCRReport(entity)); //Generate the Report
}
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
public Tuple <bool, 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));
ds = manageSQLConnection.GetDataSetValues("GetGSTData", sqlParameters);
ManageGST manageGST = new ManageGST();
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,
Type = reportParameter.Type
};
return(manageGST.GenerateGSTFile(entity)); //Generate the Report
}
return(new Tuple <bool, string>(false, "GST File is not generated"));
}
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]));
}
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 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 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(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] 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 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([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(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 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 Tuple <bool, string, string> Post(DocumentStockTransferDetails documentStockTransfer = null)
{
if (documentStockTransfer.Type == 2)
{
ManageDocumentTruckMemo documentTruckMemo = new ManageDocumentTruckMemo();
documentTruckMemo.GenerateTruckMemo(documentStockTransfer);
if (documentStockTransfer.IssueSlip == "N" || string.IsNullOrEmpty(documentStockTransfer.IssueSlip))
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@STNo", documentStockTransfer.STNo));
manageSQLConnection.UpdateValues("UpdateStockTransferIssueslip", sqlParameters);
}
return(new Tuple <bool, string, string>(true, "Print Generated Successfully", documentStockTransfer.STNo));
}
else
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GCode", documentStockTransfer.IssuingCode));
var result = manageSQLConnection.GetDataSetValues("AllowDocumentEntry", sqlParameters);
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(result))
{
if (documentStockTransfer.STNo.Trim() != "0" && documentStockTransfer.STNo.Trim() != "-")
{
List <KeyValuePair <string, string> > sqlParameters1 = new List <KeyValuePair <string, string> >();
sqlParameters1.Add(new KeyValuePair <string, string>("@Type", "3"));
sqlParameters1.Add(new KeyValuePair <string, string>("@DocNumber", documentStockTransfer.STNo.Trim()));
var result1 = manageSQLConnection.GetDataSetValues("CheckDocumentEdit", sqlParameters1);
if (!manageReport.CheckDataAvailable(result1))
{
return(new Tuple <bool, string, string>(false, GlobalVariable.DocumentEditPermission, ""));
}
// CheckDocumentEdit
}
ManageTruckMemo manageTruck = new ManageTruckMemo();
return(manageTruck.InsertTruckMemoEntry(documentStockTransfer));
}
else
{
return(new Tuple <bool, string, string>(false, "Permission not Granted", ""));
}
}
}
public bool CheckSRUpdateStatus(string documentNo)
{
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@Doc", documentNo));
ds = manageSQLConnection.GetDataSetValues("GetSRDetailStatus", sqlParameters);
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(ds))
{
return(true);
}
return(false);
}
public Tuple <bool, string> Post(DocumentStockReceiptList stockReceipt = null)
{
//Check valid user details.
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
ManageReport manage = new ManageReport();
List <KeyValuePair <string, string> > sqlParameters1 = new List <KeyValuePair <string, string> >();
sqlParameters1.Add(new KeyValuePair <string, string>("@UserName", stockReceipt.UserID));
DataSet ds = new DataSet();
ds = manageSQLConnection.GetDataSetValues("GetDocumentDownloadUser", sqlParameters1);
if (manage.CheckDataAvailable(ds))
{
ManagePDFGeneration managePDF = new ManagePDFGeneration();
var result = managePDF.GeneratePDF(stockReceipt);
if (result.Item1)
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@Doc", stockReceipt.SRNo));
sqlParameters.Add(new KeyValuePair <string, string>("@Status", "1"));
manageSQLConnection.UpdateValues("UpdateSRDetailStatus", sqlParameters);
List <KeyValuePair <string, string> > InsertParameter = new List <KeyValuePair <string, string> >();
InsertParameter.Add(new KeyValuePair <string, string>("@GCode", stockReceipt.ReceivingCode));
InsertParameter.Add(new KeyValuePair <string, string>("@RCode", stockReceipt.RCode));
InsertParameter.Add(new KeyValuePair <string, string>("@DocNumber", stockReceipt.SRNo));
InsertParameter.Add(new KeyValuePair <string, string>("@UserName", stockReceipt.UserID));
InsertParameter.Add(new KeyValuePair <string, string>("@DocType", "1"));
manageSQLConnection.InsertData("InsertDocumentDownloadLog", InsertParameter);
}
return(result);
}
else
{
List <KeyValuePair <string, string> > InsertParameter = new List <KeyValuePair <string, string> >();
InsertParameter.Add(new KeyValuePair <string, string>("@GCode", stockReceipt.ReceivingCode));
InsertParameter.Add(new KeyValuePair <string, string>("@RCode", stockReceipt.RCode));
InsertParameter.Add(new KeyValuePair <string, string>("@DocNumber", stockReceipt.SRNo));
InsertParameter.Add(new KeyValuePair <string, string>("@UserName", stockReceipt.UserID));
InsertParameter.Add(new KeyValuePair <string, string>("@DocType", "2"));
manageSQLConnection.InsertData("InsertDocumentDownloadLog", InsertParameter);
//
return(new Tuple <bool, string>(false, "Please contact HO"));
}
}
public string Post([FromBody] IssuerParameter issuerParameter)
{
DataSet ds = new DataSet();
DataSet dsNew = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", issuerParameter.FromDate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", issuerParameter.ToDate));
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", issuerParameter.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@RCode", issuerParameter.RCode));
//sqlParameters.Add(new KeyValuePair<string, string>("@Type", "0"));
sqlParameters.Add(new KeyValuePair <string, string>("@Startindex", Convert.ToString(issuerParameter.StartIndex)));
sqlParameters.Add(new KeyValuePair <string, string>("@TotalRows", Convert.ToString(issuerParameter.TotalRecord)));
ds = manageSQLConnection.GetDataSetValues("StockIssueForRegister", sqlParameters);
if (issuerParameter.Position == 1)
{
List <KeyValuePair <string, string> > sqlParametersNew = new List <KeyValuePair <string, string> >();
sqlParametersNew.Add(new KeyValuePair <string, string>("@FromDate", issuerParameter.FromDate));
sqlParametersNew.Add(new KeyValuePair <string, string>("@ToDate", issuerParameter.ToDate));
sqlParametersNew.Add(new KeyValuePair <string, string>("@GodownCode", issuerParameter.GCode));
// sqlParametersNew.Add(new KeyValuePair<string, string>("@Type", "1"));
sqlParametersNew.Add(new KeyValuePair <string, string>("@RCode", issuerParameter.RCode));
sqlParametersNew.Add(new KeyValuePair <string, string>("@Startindex", Convert.ToString(issuerParameter.StartIndex)));
sqlParametersNew.Add(new KeyValuePair <string, string>("@TotalRows", Convert.ToString(issuerParameter.TotalRecord)));
dsNew = manageSQLConnection.GetDataSetValues("StockIssueForRegister", sqlParametersNew);
StockIssueRegister stockIssues = new StockIssueRegister();
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(ds))
{
CommonEntity entity = new CommonEntity
{
dataSet = dsNew,
GCode = issuerParameter.GCode,
FromDate = issuerParameter.FromDate,
Todate = issuerParameter.ToDate,
UserName = issuerParameter.UserName
};
// stockIssues.GenerateStockIssuesRegister(entity);
Task.Run(() => stockIssues.GenerateStockIssuesRegister(entity)); //Generate the Report
}
}
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
public string Get(string TyCode, string TRType, string GCode, string TRCode)
{
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@TyCode", TyCode));
sqlParameters.Add(new KeyValuePair <string, string>("@TRType", TRType));
sqlParameters.Add(new KeyValuePair <string, string>("@GodCode", GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@TRCode", TRCode));
ds = manageSQLConnection.GetDataSetValues("GetDepositorDetails", sqlParameters);
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(ds))
{
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
return(JsonConvert.SerializeObject(string.Empty));
}
public string Get(string GCode, string ITCode, string TRCode, string SchemeCode = null)
{
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@CommodityCode", ITCode));
sqlParameters.Add(new KeyValuePair <string, string>("@TRCode", TRCode));
sqlParameters.Add(new KeyValuePair <string, string>("@SchemeCode", SchemeCode));
ds = manageSQLConnection.GetDataSetValues("GetStackDetails", sqlParameters);
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(ds))
{
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
return(JsonConvert.SerializeObject(string.Empty));
}
public string Get(string Value, string Code, int Type, string ToDate)
{
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@Value", Value));
sqlParameters.Add(new KeyValuePair <string, string>("@GCode", Code));
sqlParameters.Add(new KeyValuePair <string, string>("@Type", Type.ToString()));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", ToDate));
ds = manageSQLConnection.GetDataSetValues("GetDocumentCorrection", sqlParameters);
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(ds))
{
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
return(JsonConvert.SerializeObject(""));
}
public string Post(QuantityAccountEntity accountEntity)
{
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", accountEntity.FromDate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", accountEntity.ToDate));
sqlParameters.Add(new KeyValuePair <string, string>("@GCode", accountEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@RCode", accountEntity.RCode));
ds = manageSQLConnection.GetDataSetValues("GetTruckMemoForQuantityAC", sqlParameters);
//Generate the report.
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(ds))
{
ManageQAReceipt manageQAReceipt = new ManageQAReceipt();
Task.Run(() => manageQAReceipt.GenerateQAReceipt(ds, accountEntity, GlobalVariable.QATruckMemoForAllScheme, "- Truck Memo Abstract -", 2));
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
return(JsonConvert.SerializeObject(string.Empty));
}
private Tuple <bool, string> GetImageName(string GCode)
{
try
{
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", GCode));
ds = manageSQLConnection.GetDataSetValues("GetGodownProfile", sqlParameters);
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(ds))
{
return(new Tuple <bool, string>(true, Convert.ToString(ds.Tables[0].Rows[0]["ImageName"])));
}
return(new Tuple <bool, string>(false, ""));
}
catch (Exception ex)
{
AuditLog.WriteError("GetImageName : " + ex.Message);
return(new Tuple <bool, string>(false, ""));
}
}
public bool Put(SrEntity srEntity)
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
ManageReport manage = new ManageReport();
List <KeyValuePair <string, string> > sqlParameters1 = new List <KeyValuePair <string, string> >();
sqlParameters1.Add(new KeyValuePair <string, string>("@UserName", srEntity.UserId));
DataSet ds = new DataSet();
ds = manageSQLConnection.GetDataSetValues("GetDocumentDownloadUser", sqlParameters1);
if (manage.CheckDataAvailable(ds))
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@Doc", srEntity.DocNumber));
sqlParameters.Add(new KeyValuePair <string, string>("@Status", srEntity.Status.ToString()));
return(manageSQLConnection.UpdateValues("UpdateSRDetailStatus", sqlParameters));
}
else
{
return(false);
}
}
public Tuple <bool, GToGEntity> CheckIssueMemoNumber(string IssueMomo)
{
GToGEntity gEntity = new GToGEntity();
bool isAvailable = false;
try
{
gEntity.IssueMemoNumber = IssueMomo;
DataSet dataset = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@DocNumber", IssueMomo));
dataset = manageSQLConnection.GetDataSetValues("CheckIssueMomo", sqlParameters);
ManageReport manageReport = new ManageReport();
if (manageReport.CheckDataAvailable(dataset))
{
isAvailable = true;
gEntity.StatusCode = "0";
gEntity.Message = "Success";
}
else
{
isAvailable = false;
gEntity.StatusCode = "2000";
gEntity.Message = "Issuemomo Number is not valid or Already ACK has been updated.";
}
return(new Tuple <bool, GToGEntity>(isAvailable, gEntity));
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
gEntity.StatusCode = "2000";
gEntity.Message = "Internal Error";
gEntity.IssueMemoNumber = IssueMomo;
return(new Tuple <bool, GToGEntity>(false, gEntity));
}
}
public Tuple <bool, string, string> Post(DocumentStockIssuesEntity documentStockIssuesEntity = null)
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
ManageReport manageReport = new ManageReport();
//Check the document Approval
List <KeyValuePair <string, string> > sqlParametersDocApproval = new List <KeyValuePair <string, string> >();
sqlParametersDocApproval.Add(new KeyValuePair <string, string>("@DocDate", documentStockIssuesEntity.SIDate));
sqlParametersDocApproval.Add(new KeyValuePair <string, string>("@GCode", documentStockIssuesEntity.IssuingCode));
var docResult = manageSQLConnection.GetDataSetValues("GetApprovalStatusForDocument", sqlParametersDocApproval);
if (manageReport.CheckDocApproval(docResult))
{
if (documentStockIssuesEntity.Type == 2)
{
ManageDocumentIssues documentIssues = new ManageDocumentIssues();
documentIssues.GenerateIssues(documentStockIssuesEntity);
if (documentStockIssuesEntity.Loadingslip == "N" || string.IsNullOrEmpty(documentStockIssuesEntity.Loadingslip))
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@SINo", documentStockIssuesEntity.SINo));
manageSQLConnection.UpdateValues("UpdateStockIssuesLoadingslip", sqlParameters);
}
return(new Tuple <bool, string, string>(true, "Print Generated Successfully", documentStockIssuesEntity.SINo));
}
else
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GCode", documentStockIssuesEntity.IssuingCode));
var result = manageSQLConnection.GetDataSetValues("AllowDocumentEntry", sqlParameters);
if (manageReport.CheckDataAvailable(result))
{
if (documentStockIssuesEntity.DocType == 2) //(documentStockIssuesEntity.SINo.Trim() != "0" && documentStockIssuesEntity.SINo.Trim() != "-")
{
List <KeyValuePair <string, string> > sqlParameters1 = new List <KeyValuePair <string, string> >();
sqlParameters1.Add(new KeyValuePair <string, string>("@Type", "2"));
sqlParameters1.Add(new KeyValuePair <string, string>("@DocNumber", documentStockIssuesEntity.SINo.Trim()));
var result1 = manageSQLConnection.GetDataSetValues("CheckDocumentEdit", sqlParameters1);
if (!manageReport.CheckDataAvailable(result1))
{
return(new Tuple <bool, string, string>(false, GlobalVariable.DocumentEditPermission, ""));
}
// CheckDocumentEdit
}
else
{
// check document available
List <KeyValuePair <string, string> > sqlParameterscheckdate = new List <KeyValuePair <string, string> >();
sqlParameterscheckdate.Add(new KeyValuePair <string, string>("@SINo", documentStockIssuesEntity.SINo));
var result1 = manageSQLConnection.GetDataSetValues("GetStockIssueDetailsBySINo", sqlParameterscheckdate);
if (manageReport.CheckDataAvailable(result1))
{
return(new Tuple <bool, string, string>(false, "This document number " + documentStockIssuesEntity.SINo + " is already exists, Please refresh the page.", ""));
}
}
StockIssueMemo stockIssueMemo = new StockIssueMemo();
return(stockIssueMemo.InsertStockIssueData(documentStockIssuesEntity));
}
else
{
return(new Tuple <bool, string, string>(false, "Permission not Granted", ""));
}
}
}
else
{
return(new Tuple <bool, string, string>(false, "Please Approve CB, Receipt, Issues and Truck memo for yesterday documents. If you wants to do without approval Please get permission from HO (MD).", ""));
}
}
public void InsertSalesTaxDetails(DocumentDeliveryOrderEntity deliveryOrderEntity, string SRNo)
{
try
{
if (deliveryOrderEntity.DOTaxStatus == "YES")
{
//Get values to calculate the GST value.
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@EffectDate", deliveryOrderEntity.DoDate));
ds = manageSQLConnection.GetDataSetValues("GetRateMasterData", sqlParameters);
ManageReport report = new ManageReport();
if (report.CheckDataAvailable(ds))
{
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
List <RateEntity> _rateEntity = new List <RateEntity>();
_rateEntity = report.ConvertDataTableToList <RateEntity>(ds.Tables[0]);
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "DeleteDOSalesTaxDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@BillNo", SRNo);
sqlCommand.Parameters.AddWithValue("@GCode", deliveryOrderEntity.IssuerCode);
sqlCommand.ExecuteNonQuery();
var creditSales = (deliveryOrderEntity.TransactionCode == "TR019") ? true : false;
decimal gst = 0, taxPercent = 0, taxAmnt = 0, rate = 0, amnt = 0;
foreach (var item in deliveryOrderEntity.documentDeliveryItems)
{
//Filter the value based on HSN no and Scheme.
var result = (from a in _rateEntity
where a.Hsncode == item.HsnCode && a.Scheme == item.Scheme
select a).FirstOrDefault();
if (result != null)
{
item.TaxPercent = Convert.ToString(result.TaxPercentage);
rate = result.Rate;
}
else
{
item.TaxPercent = "100";
rate = 0;
}
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "InsertIntoGSTSalesTax";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@BillNo", SRNo);
sqlCommand.Parameters.AddWithValue("@BillDate", deliveryOrderEntity.DoDate);
sqlCommand.Parameters.AddWithValue("@Month", deliveryOrderEntity.Month);
sqlCommand.Parameters.AddWithValue("@Year", deliveryOrderEntity.Year);
sqlCommand.Parameters.AddWithValue("@CompanyID", deliveryOrderEntity.PartyID);
sqlCommand.Parameters.AddWithValue("@CreditSales", creditSales);
sqlCommand.Parameters.AddWithValue("@TaxPercentage", item.TaxPercent);
sqlCommand.Parameters.AddWithValue("@Hsncode", item.HsnCode);
sqlCommand.Parameters.AddWithValue("@CommodityID", item.Itemcode);
sqlCommand.Parameters.AddWithValue("@TaxType", "CGST");
sqlCommand.Parameters.AddWithValue("@Measurement", item.Wtype);
sqlCommand.Parameters.AddWithValue("@Quantity", item.NetWeight);
taxPercent = (Convert.ToDecimal(item.TaxPercent) / 2);
// rate = ((Convert.ToDouble(item.Rate)) - ((Convert.ToDouble(item.Rate) * Convert.ToDouble(item.TaxPercent)) / 100));
sqlCommand.Parameters.AddWithValue("@Rate", rate);
amnt = (Convert.ToDecimal(item.NetWeight) * rate);
sqlCommand.Parameters.AddWithValue("@Amount", amnt);
gst = ((amnt * taxPercent) / 100);
sqlCommand.Parameters.AddWithValue("@CGST", gst);
sqlCommand.Parameters.AddWithValue("@SGST", gst);
taxAmnt = (gst * 2);
sqlCommand.Parameters.AddWithValue("@TaxAmount", taxAmnt);
sqlCommand.Parameters.AddWithValue("@Total", (amnt + taxAmnt));
sqlCommand.Parameters.AddWithValue("@RCode", item.Rcode);
sqlCommand.Parameters.AddWithValue("@GCode", deliveryOrderEntity.IssuerCode);
sqlCommand.Parameters.AddWithValue("@CreatedBy", deliveryOrderEntity.UserID);
sqlCommand.Parameters.AddWithValue("@Scheme", item.Scheme);
sqlCommand.Parameters.AddWithValue("@DORate", item.Rate);
sqlCommand.Parameters.AddWithValue("@DOTotal", item.Total);
sqlCommand.ExecuteNonQuery();
}
}
}
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
}
public string Post(IssueMemoEntity issueMemoDetails)
{
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
if (issueMemoDetails.Type == 1)
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", issueMemoDetails.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@type", issueMemoDetails.ReceivorType));
sqlParameters.Add(new KeyValuePair <string, string>("@FDATE", issueMemoDetails.Fdate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", issueMemoDetails.Tdate));
ds = manageSQLConnection.GetDataSetValues("GetIssueMemoSocietyAbstract", sqlParameters);
IssueMemoSocietyAbstract salesIssueMemo = new IssueMemoSocietyAbstract();
ManageReport manageReport = new ManageReport();
//DataTable dt = new DataTable();
if (manageReport.CheckDataAvailable(ds))
{
CommonEntity entity = new CommonEntity
{
dataSet = ds,
GCode = issueMemoDetails.GCode,
FromDate = issueMemoDetails.Fdate,
Todate = issueMemoDetails.Tdate,
UserName = issueMemoDetails.UserName,
RName = issueMemoDetails.RName,
GName = issueMemoDetails.GName
};
Task.Run(() => salesIssueMemo.GenerateIssueMemoReceipt(entity, GlobalVariable.IssueMemoSocietyAbstractFileName, "IssueMemo Society Abstract", 0));
}
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
else if (issueMemoDetails.Type == 2)
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", issueMemoDetails.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@type", issueMemoDetails.ReceivorType));
sqlParameters.Add(new KeyValuePair <string, string>("@FDATE", issueMemoDetails.Fdate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", issueMemoDetails.Tdate));
ds = manageSQLConnection.GetDataSetValues("GetIssueMemoSocietyDateWise", sqlParameters);
IssueMemoSocietyAbstract salesIssueMemoAbstract = new IssueMemoSocietyAbstract();
ManageReport manageReport = new ManageReport();
//DataTable dt = new DataTable();
if (manageReport.CheckDataAvailable(ds))
{
CommonEntity entity = new CommonEntity
{
dataSet = ds,
GCode = issueMemoDetails.GCode,
FromDate = issueMemoDetails.Fdate,
Todate = issueMemoDetails.Tdate,
UserName = issueMemoDetails.UserName,
RName = issueMemoDetails.RName,
GName = issueMemoDetails.GName
};
Task.Run(() => salesIssueMemoAbstract.GenerateIssueMemoReceipt(entity, GlobalVariable.IssueMemoSocietyDateWiseFileName, "IssueMemo Society Date wise Abstract", 1));
}
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
else if (issueMemoDetails.Type == 3)
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", issueMemoDetails.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@type", issueMemoDetails.ReceivorType));
sqlParameters.Add(new KeyValuePair <string, string>("@FDATE", issueMemoDetails.Fdate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", issueMemoDetails.Tdate));
ds = manageSQLConnection.GetDataSetValues("GetIssueMemoSocietyDateAndScheme", sqlParameters);
IssueMemoSocietyAbstract salesIssueMemoAbstract = new IssueMemoSocietyAbstract();
ManageReport manageReport = new ManageReport();
//DataTable dt = new DataTable();
if (manageReport.CheckDataAvailable(ds))
{
CommonEntity entity = new CommonEntity
{
dataSet = ds,
GCode = issueMemoDetails.GCode,
FromDate = issueMemoDetails.Fdate,
Todate = issueMemoDetails.Tdate,
UserName = issueMemoDetails.UserName,
RName = issueMemoDetails.RName,
GName = issueMemoDetails.GName
};
Task.Run(() => salesIssueMemoAbstract.GenerateIssueMemoReceipt(entity, GlobalVariable.IssueMemoSocietyDateWiseFileName, "IssueMemo Society Date wise Abstract", 1));
}
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
else if (issueMemoDetails.Type == 4)
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", issueMemoDetails.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@type", issueMemoDetails.ReceivorType));
sqlParameters.Add(new KeyValuePair <string, string>("@FDATE", issueMemoDetails.Fdate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", issueMemoDetails.Tdate));
ds = manageSQLConnection.GetDataSetValues("GetIssueMemoSocietySchemeWise", sqlParameters);
IssueMemoSocietyAbstract salesIssueMemoAbstract = new IssueMemoSocietyAbstract();
ManageReport manageReport = new ManageReport();
//DataTable dt = new DataTable();
if (manageReport.CheckDataAvailable(ds))
{
CommonEntity entity = new CommonEntity
{
dataSet = ds,
GCode = issueMemoDetails.GCode,
FromDate = issueMemoDetails.Fdate,
Todate = issueMemoDetails.Tdate,
UserName = issueMemoDetails.UserName,
RName = issueMemoDetails.RName,
GName = issueMemoDetails.GName
};
Task.Run(() => salesIssueMemoAbstract.GenerateIssueMemoReceipt(entity, GlobalVariable.IssueMemoSocietyDateWiseFileName, "IssueMemo Society Scheme wise Abstract", 0));
}
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
return(JsonConvert.SerializeObject(""));
}
