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 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 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] 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] 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] 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(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 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] 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 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]));
}
private void onClicksubManageReport(object sender, RoutedEventArgs e)
{
if (RibbonContainer.SelectedItem is RibbonTab)
{
RibbonTab selectedTab = (RibbonTab)RibbonContainer.SelectedItem;
selectedTab.Items.Clear();
selectedTab.Header = "Report List";
selectedTab.Margin = new Thickness(0, 0, -200, -727);
RibbonGroup ManageReportTabGroup = new RibbonGroup();
ManageReportTabGroup.Background = (Brush)FindResource("Report");
ContextMenu contextMenu = new ContextMenu();
MenuItem closeMenuItem = new MenuItem();
closeMenuItem.Header = "Close";
closeMenuItem.Click += MenuItem_Click_1;
contextMenu.Items.Add(closeMenuItem);
ManageReportTabGroup.ContextMenu = contextMenu;
UserControl ManageReportTabGroupTabContent = new ManageReport();
ManageReportTabGroup.Items.Add(ManageReportTabGroupTabContent);
selectedTab.Items.Add(ManageReportTabGroup);
}
}
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, 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>("@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 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 decimal GetCBQty(decimal qty, int type)
{
try
{
ManageReport report = new ManageReport();
decimal svalue = Math.Round((type == 1 ? qty / 1000 : qty), 3);
return(Convert.ToDecimal(report.DecimalformatForWeight(Convert.ToString(svalue))));
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
return(0);
}
}
/// <summary>
/// Add footer for document receipt
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockReceipt"></param>
public void AddFooter(StreamWriter streamWriter, DocumentDeliveryOrderEntity deliveryOrderList)
{
ManageReport report = new ManageReport();
streamWriter.WriteLine("|**(Pre.AmtBal+AmtPay)-(TotalValue+Others) = Balance >>> For Credit |");
streamWriter.WriteLine("|**(Pre.AmtBal+TotalValue+others)-(Amtpaid) = Balance >>> For Debit |");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| SIGNATURE OF GODOWN INCHARGE |");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("|REMARKS |");
streamWriter.WriteLine("| " + manageReport.StringFormatWithoutPipe(deliveryOrderList.Remarks, 102, 2) + "|");
report.AddMoreContent(streamWriter, deliveryOrderList.Remarks, 102, 3);//Add content next line.
streamWriter.WriteLine("|==========================================================================================================|");
streamWriter.WriteLine((char)12);
}
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 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 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 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 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 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 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(""));
}
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 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));
}
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));
}
}
