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]));
}
