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]));
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
public void GenerateGUGRReport(CommonEntity entity, GUGRParameter param)
{
string fPath = string.Empty, subF_Path = string.Empty, fileName = string.Empty, filePath = string.Empty;
StreamWriter streamWriter = null;
try
{
HeaderTitle = (param.Type == "GR") ? " Gunny Release Details of " : " Gunny Utilisation Details of ";
fileName = (param.Type == "GR") ? (entity.GCode + GlobalVariable.GRReportFileName) : (entity.GCode + GlobalVariable.GUReportFileName);
fPath = GlobalVariable.ReportPath + "Reports";
report.CreateFolderIfnotExists(fPath); // create a new folder if not exists
subF_Path = fPath + "//" + entity.UserName; //ManageReport.GetDateForFolder();
report.CreateFolderIfnotExists(subF_Path);
//delete file if exists
filePath = subF_Path + "//" + fileName + ".txt";
report.DeleteFileIfExists(filePath);
streamWriter = new StreamWriter(filePath, true);
DateWiseCommodityWiseGUGRReport(streamWriter, entity);
List <GUList> guList = new List <GUList>();
guList = report.ConvertDataTableToList <GUList>(entity.dataSet.Tables[0]);
WriteGUGRAbstract(streamWriter, guList, entity);
streamWriter.Flush();
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
finally
{
streamWriter.Close();
fPath = string.Empty; fileName = string.Empty;
streamWriter = null;
}
}
