public void GenerateTruckMemo(DocumentStockTransferDetails truckMemoList)
{
string fPath = string.Empty, subF_Path = string.Empty, fileName = string.Empty, filePath = string.Empty;
StreamWriter streamWriter = null;
bool isDuplicate = false;
try
{
fileName = truckMemoList.IssuingCode + GlobalVariable.DocumentTruckMemoFileName;
fPath = GlobalVariable.ReportPath + "Reports";
report.CreateFolderIfnotExists(fPath); // create a new folder if not exists
subF_Path = fPath + "//" + truckMemoList.UserID; //ManageReport.GetDateForFolder();
report.CreateFolderIfnotExists(subF_Path);
//delete file if exists
filePath = subF_Path + "//" + fileName + ".txt";
report.DeleteFileIfExists(filePath);
// isDuplicate = ReceiptId == "0" ? false : true;
isDuplicate = truckMemoList.IssueSlip == "Y" ? true : false;
streamWriter = new StreamWriter(filePath, true);
AddDocHeaderForTruckMemo(streamWriter, truckMemoList, isDuplicate);
AddDetails(streamWriter, truckMemoList);
AddFooter(streamWriter, truckMemoList);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
finally
{
streamWriter.Flush();
streamWriter.Close();
fPath = string.Empty; fileName = string.Empty;
streamWriter = null;
}
}
/// <summary>
/// Add footer for document receipt
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="truckMemoList"></param>
public void AddFooter(StreamWriter streamWriter, DocumentStockTransferDetails transferDetails)
{
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.Write("|LORRY NO: ");
streamWriter.Write(report.StringFormatWithoutPipe(transferDetails.LorryNo, 23, 2));
streamWriter.Write("TC NAME : ");
streamWriter.Write(report.StringFormatWithoutPipe(transferDetails.documentSTTDetails[0].TransporterName, 59, 2) + "|");
streamWriter.WriteLine(" ");
streamWriter.Write("|MODE OF WEIGHMENT : ");
streamWriter.Write(report.StringFormatWithoutPipe(GetWTCode(transferDetails), 85, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.Write("|FROM RAIL HEAD: ");
streamWriter.Write(report.StringFormatWithoutPipe(transferDetails.RailHeadName, 17, 2));
streamWriter.Write("WAGON NO : ");
streamWriter.Write(report.StringFormatWithoutPipe(GetWNo(transferDetails), 21, 2));
streamWriter.Write("RR NO:");
streamWriter.Write(report.StringFormatWithoutPipe(GetRRNo(transferDetails), 31, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI1, 105, 2) + "|");
streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI2, 105, 2) + "|");
streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI3, 105, 2) + "|");
streamWriter.WriteLine("| NAME OF TC |");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("|GODOWN INCHARGE Sign. of the Authorised Person. |");
streamWriter.WriteLine("|REMARKS |");
streamWriter.WriteLine("| " + report.StringFormatWithoutPipe(GetRemarks(transferDetails), 102, 2) + "|");
report.AddMoreContent(streamWriter, GetRemarks(transferDetails), 102, 3);//Add content next line.
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.WriteLine((char)12);
}
public string GetRemarks(DocumentStockTransferDetails transferDetails)
{
try
{
return(transferDetails.documentSTTDetails[0].Remarks);
}
catch (Exception ex)
{
AuditLog.WriteError(" GetRemarks " + ex.Message + " " + ex.StackTrace);
}
return("-");
}
/// <summary>
/// Add header for document receipt
/// </summary>
/// <param name="streamWriter">Stream writer to write the text file.</param>
/// <param name="truckMemoList"></param>
/// <param name="isDuplicate"></param>
public void AddDocHeaderForTruckMemo(StreamWriter streamWriter, DocumentStockTransferDetails truckMemoList, bool isDuplicate = false)
{
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| TAMILNADU CIVIL SUPPLIES CORPORATION |");
streamWriter.Write("| ");
streamWriter.Write(report.StringFormatWithoutPipe("REGION : ", 9, 1));
streamWriter.Write(report.StringFormat(truckMemoList.RegionName, 53, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
if (isDuplicate)
{
streamWriter.WriteLine("| STOCK ISSUE TRUCK MEMO DUPLICATE COPY |");
}
else
{
streamWriter.WriteLine("| STOCK ISSUE TRUCK MEMO |");
}
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.Write("|TRUCK MEMO NO:");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.STNo, 21, 2));
streamWriter.Write("ALLOTMENT/RELEASE ORDER: ");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.RNo, 12, 2));
streamWriter.Write("MOVE. ORDER NO: ");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.MNo, 15, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.Write("| DATE:");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(truckMemoList.STDate.ToString()), 21, 2));
streamWriter.Write(report.StringFormatWithoutPipe("TIME: ", 25, 1));
streamWriter.Write(report.StringFormatWithoutPipe(report.GetCurrentTime(DateTime.Now), 16, 2));
streamWriter.Write("DATE:");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(truckMemoList.RDate.ToString()), 16, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.Write("|ISSUING GODOWN :");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.GodownName, 30, 2));
streamWriter.Write("RECEIVER NAME: ");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.ReceivingName, 41, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.WriteLine("||--------------------------------------------------------------------------------------------------------||");
streamWriter.WriteLine("||SNo |STACK NO |COMMODITY | SCHEME |UNIT WEIGHT |NO.OF | Gross NET |% OF ||");
streamWriter.WriteLine("|| | | | | | UNIT| WEIGHT in Kgs/NOs |MOISTURE||");
streamWriter.WriteLine("||--------------------------------------------------------------------------------------------------------||");
}
public string GetRRNo(DocumentStockTransferDetails transferDetails)
{
string WtCode = string.Empty;
try
{
WtCode = transferDetails.documentSTTDetails[0].RRNo;
}
catch
{
}
return(WtCode);
}
public string GetWTCode(DocumentStockTransferDetails transferDetails)
{
string WtCode = string.Empty;
try
{
WtCode = transferDetails.documentSTItemDetails[0].WTCode;
}
catch (Exception ex)
{
AuditLog.WriteError(" GetWTCode " + ex.Message + " " + ex.StackTrace);
}
return(WtCode);
}
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", ""));
}
}
}
/// <summary>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="truckMemoList"></param>
public void AddDetails(StreamWriter streamWriter, DocumentStockTransferDetails transferDetails)
{
int i = 0;
foreach (var item in transferDetails.documentSTItemDetails)
{
i = i + 1;
streamWriter.Write("||");
streamWriter.Write(report.StringFormat(i.ToString(), 4, 2));
streamWriter.Write(report.StringFormat(item.TStockNo, 11, 2));
streamWriter.Write(report.StringFormat(item.ITDescription, 20, 2));
streamWriter.Write(report.StringFormat(item.SchemeName, 14, 2));
streamWriter.Write(report.StringFormat(item.PackingType, 13, 2));
streamWriter.Write(report.StringFormat(item.NoPacking.ToString(), 6, 1));
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(item.GKgs.ToString()), 10, 1));
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(item.Nkgs.ToString()), 10, 1));
streamWriter.Write(report.StringFormat(item.Moisture.ToString(), 8, 1) + "|");
streamWriter.WriteLine(" ");
}
}
