public Tuple <bool, string, string> InsertStockIssueData(DocumentStockIssuesEntity stockIssueList)
{
ManageSQLForIssues manageSQLForIssuesConnection = new ManageSQLForIssues();
var result = manageSQLForIssuesConnection.InsertIssuesEntry(stockIssueList);
return(result);
}
/// <summary>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockIssuesEntity"></param>
private void AddDetails(StreamWriter streamWriter, DocumentStockIssuesEntity stockIssuesEntity)
{
int i = 0;
int units = 0;
double netKgs = 0;
foreach (var item in stockIssuesEntity.IssueItemList)
{
i = i + 1;
if (item.TStockNo.ToUpper() != "TOTAL")
{
streamWriter.Write("||");
streamWriter.Write(report.StringFormat(i.ToString(), 3, 2));
streamWriter.Write(report.StringFormat(item.TStockNo, 12, 2));
streamWriter.Write(report.StringFormat(item.CommodityName, 31, 2));
streamWriter.Write(report.StringFormat(item.SchemeName, 14, 2));
streamWriter.Write(report.StringFormat(item.PackingName, 13, 2));
streamWriter.Write(report.StringFormat(item.NoPacking.ToString(), 10, 1));
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(item.Nkgs.ToString()), 13, 1));
streamWriter.Write(report.StringFormat(item.Moisture.ToString(), 5, 1));
streamWriter.WriteLine(" ");
units = units + item.NoPacking;
netKgs = netKgs + Convert.ToDouble(item.Nkgs);
}
}
streamWriter.WriteLine("||------------------------------------------------------------------------------------------------------|-----|");
streamWriter.WriteLine("|| |Total |" + report.StringFormatWithoutPipe(units.ToString(), 9, 1) + "|" + report.StringFormatWithoutPipe(report.DecimalformatForWeight(netKgs.ToString()), 12, 1) + "| |");
streamWriter.WriteLine("||------------------------------------------------------------------------------------------------------|-----|");
}
/// <summary>
/// Add header for document receipt
/// </summary>
/// <param name="streamWriter">Stream writer to write the text file.</param>
/// <param name="stockIssuesEntity"></param>
/// <param name="isDuplicate"></param>
public void AddDocHeaderForIssues(StreamWriter streamWriter, DocumentStockIssuesEntity stockIssuesEntity, 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(stockIssuesEntity.RegionName, 53, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
if (isDuplicate)
{
streamWriter.WriteLine("| STOCK ISSUE - ISSUE MEMO DUPLICATE COPY |");
}
else
{
streamWriter.WriteLine("| STOCK ISSUE - ISSUE MEMO |");
}
streamWriter.WriteLine("|-------------------------------------------------------------------------------------------------------------|");
streamWriter.Write("|ISSUE MEMO NO : ");
streamWriter.Write(report.StringFormatWithoutPipe(stockIssuesEntity.SINo, 21, 2));
streamWriter.Write("DATE: ");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(stockIssuesEntity.SIDate.ToString()), 12, 2));
streamWriter.Write("TIME:");
streamWriter.Write(report.StringFormatWithoutPipe(report.GetCurrentTime(DateTime.Now), 14, 2));
streamWriter.Write(report.StringFormatWithoutPipe((stockIssuesEntity.IssueRegularAdvance.ToUpper() == "R" ? "REGULAR" : "ADVANCE"), 8, 2));
streamWriter.Write(report.StringFormat(stockIssuesEntity.IRelates, 20, 2));
streamWriter.WriteLine(" ");
streamWriter.Write("|ISSUING GODOWN : ");
streamWriter.Write(report.StringFormatWithoutPipe(stockIssuesEntity.GodownName, 21, 2));
streamWriter.Write(report.StringFormatWithoutPipe("TO WHOM ISSUED:", 15, 1));
streamWriter.Write(report.StringFormatWithoutPipe(stockIssuesEntity.ReceiverName, 51, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
try
{
streamWriter.Write("| ");
streamWriter.Write(report.StringFormatWithoutPipe("ISSUER CODE :", 15, 1));
streamWriter.Write(report.StringFormatWithoutPipe(stockIssuesEntity.IssuerCode, 51, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
streamWriter.WriteLine("||------------------------------------------------------------------------------------------------------|-----|");
streamWriter.WriteLine("||SNo| STACK NO | COMMODITY | SCHEME |UNIT WEIGHT |NO.OFUNITS| NET Wt/Nos|MOI% |");
streamWriter.WriteLine("||------------------------------------------------------------------------------------------------------|-----|");
}
/// <summary>
/// Add footer for document receipt
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockIssuesEntity"></param>
private void AddFooter(StreamWriter streamWriter, DocumentStockIssuesEntity stockIssuesEntity)
{
streamWriter.WriteLine("| LORRY NO :" + report.StringFormatWithoutPipe(report.ConvertToUpper(stockIssuesEntity.LorryNo), 17, 2) + "TC NAME : " + report.StringFormatWithoutPipe(report.ConvertToUpper(stockIssuesEntity.TransporterName), 60, 2) + "|");
// streamWriter.WriteLine("| |");
streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI1, 108, 2) + "|");
streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI2, 108, 2) + "|");
streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI3, 108, 2) + "|");
streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI4, 108, 2) + "|");
streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI5, 108, 2) + "|");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| Signature of the representative. GODOWN INCHARGE |");
// streamWriter.WriteLine("| Sign. of the Authorised Person. GODOWN INCHARGE |");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("|REMARKS |");
streamWriter.WriteLine("| " + report.StringFormatWithoutPipe(stockIssuesEntity.Remarks, 105, 2) + "|");
report.AddMoreContent(streamWriter, stockIssuesEntity.Remarks, 105, 3);
streamWriter.WriteLine("|-------------------------------------------------------------------------------------------------------------|");
streamWriter.WriteLine((char)12);
}
/// <summary>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockIssuesEntity"></param>
private void AddDODetails(StreamWriter streamWriter, DocumentStockIssuesEntity stockIssuesEntity)
{
int i = 0;
streamWriter.WriteLine("||-----------------------------------------------------------------| |");
streamWriter.WriteLine("|| DELIVERY ORDER | ISSUE/TRUCK MEMO | GATE PASS | |");
streamWriter.WriteLine("|| NUMBER | DATE | NUMBER | DATE | NUMBER | DATE | |");
streamWriter.WriteLine("||-----------------------------------------------------------------| |");
foreach (var item in stockIssuesEntity.SIDetailsList)
{
i = i + 1;
streamWriter.Write("||");
streamWriter.Write(report.StringFormat(item.DNo, 10, 2));
streamWriter.Write(report.StringFormat(report.FormatIndianDate(item.DDate.ToString()), 10, 2));
streamWriter.Write(report.StringFormat(stockIssuesEntity.SINo, 10, 2));
streamWriter.Write(report.StringFormat(report.FormatIndianDate(stockIssuesEntity.SIDate.ToString()), 10, 2));
streamWriter.Write(" | | |");
streamWriter.WriteLine(" ");
}
streamWriter.WriteLine("||-----------------------------------------------------------------| |");
streamWriter.WriteLine("|-------------------------------------------------------------------------------------------------------------|");
}
/// <summary>
///
/// </summary>
/// <param name="stockIssuesEntity"></param>
public void GenerateIssues(DocumentStockIssuesEntity stockIssuesEntity)
{
// AuditLog.WriteError("GeneratestockIssuesEntityRegister");
string fPath = string.Empty, subF_Path = string.Empty, fileName = string.Empty, filePath = string.Empty;
StreamWriter streamWriter = null;
bool isDuplicate = false;
try
{
fileName = stockIssuesEntity.IssuingCode + GlobalVariable.DocumentIssueFileName;
fPath = GlobalVariable.ReportPath + "Reports";
report.CreateFolderIfnotExists(fPath); // create a new folder if not exists
subF_Path = fPath + "//" + stockIssuesEntity.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 = stockIssuesEntity.Loadingslip == null ? false : stockIssuesEntity.Loadingslip.ToUpper() == "Y" ? true : false;
streamWriter = new StreamWriter(filePath, true);
AddDocHeaderForIssues(streamWriter, stockIssuesEntity, isDuplicate);
AddDetails(streamWriter, stockIssuesEntity);
AddDODetails(streamWriter, stockIssuesEntity);
AddFooter(streamWriter, stockIssuesEntity);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
finally
{
streamWriter.Flush();
streamWriter.Close();
fPath = string.Empty; fileName = string.Empty;
streamWriter = null;
}
}
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 Tuple <bool, string, string> InsertIssuesEntry(DocumentStockIssuesEntity issueList)
{
SqlTransaction objTrans = null;
string RowID = string.Empty, SINo = string.Empty;
bool isNewDoc = true;
using (sqlConnection = new SqlConnection(GlobalVariable.ConnectionString))
{
DataSet ds = new DataSet();
sqlCommand = new SqlCommand();
try
{
if (issueList.DocType == 2)
{
isNewDoc = false;
}
if (sqlConnection.State == 0)
{
sqlConnection.Open();
}
objTrans = sqlConnection.BeginTransaction();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "InsertStockIssueDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@SIDate", issueList.SIDate);
sqlCommand.Parameters.AddWithValue("@Trcode", issueList.Trcode);
sqlCommand.Parameters.AddWithValue("@IRelates", issueList.IRelates);
sqlCommand.Parameters.AddWithValue("@DNo", issueList.DNo);
sqlCommand.Parameters.AddWithValue("@DDate", issueList.DDate);
sqlCommand.Parameters.AddWithValue("@WCCode", issueList.WCCode);
sqlCommand.Parameters.AddWithValue("@IssuingCode", issueList.IssuingCode);
sqlCommand.Parameters.AddWithValue("@Receivorcode", issueList.Receivorcode);
sqlCommand.Parameters.AddWithValue("@issuetype1", issueList.Issuetype);
sqlCommand.Parameters.AddWithValue("@SoundServiceable", issueList.SoundServiceable);
sqlCommand.Parameters.AddWithValue("@ServiceablePatches", issueList.ServiceablePatches);
sqlCommand.Parameters.AddWithValue("@Gunnyutilised", issueList.GunnyUtilised);
sqlCommand.Parameters.AddWithValue("@GunnyReleased", issueList.GunnyReleased);
sqlCommand.Parameters.AddWithValue("@Remarks", issueList.Remarks);
sqlCommand.Parameters.AddWithValue("@TransporterName", issueList.TransporterName);
sqlCommand.Parameters.AddWithValue("@TransportingCharge", issueList.TransportingCharge);
sqlCommand.Parameters.AddWithValue("@LorryNo", issueList.LorryNo);
sqlCommand.Parameters.AddWithValue("@NewBale", issueList.NewBale);
sqlCommand.Parameters.AddWithValue("@RCode", issueList.RCode);
sqlCommand.Parameters.AddWithValue("@IssueType", "-");
sqlCommand.Parameters.AddWithValue("@ExportFlag", "N");
sqlCommand.Parameters.AddWithValue("@Loadingslip", issueList.Loadingslip);
sqlCommand.Parameters.AddWithValue("@IssueMemo", "-");
sqlCommand.Parameters.AddWithValue("@Flag1", issueList.ManualDocNo);
sqlCommand.Parameters.AddWithValue("@Flag2", issueList.IssueRegularAdvance);
sqlCommand.Parameters.AddWithValue("@SINo1", issueList.SINo != null ? issueList.SINo : "");
sqlCommand.Parameters.AddWithValue("@RowId1", issueList.RowId != null ? issueList.RowId : "");
sqlCommand.Parameters.Add("@SINo", SqlDbType.NVarChar, 13);
sqlCommand.Parameters.Add("@RowId", SqlDbType.NVarChar, 30);
sqlCommand.Parameters["@SINo"].Direction = ParameterDirection.Output;
sqlCommand.Parameters["@RowId"].Direction = ParameterDirection.Output;
sqlCommand.ExecuteNonQuery();
RowID = Convert.ToString(sqlCommand.Parameters["@RowId"].Value);
SINo = Convert.ToString(sqlCommand.Parameters["@SINo"].Value);
issueList.SINo = SINo;
//insert record into gatepass table
if (isNewDoc)
{
if (issueList.IssuingCode.Trim() != issueList.Receivorcode.Trim())
{
GatePassEntity gatePassEntity = new GatePassEntity
{
LorryNumber = issueList.LorryNo,
DocumentTye = 2,
GCode = issueList.IssuingCode,
RCode = issueList.RCode,
DocumentNumber = SINo
};
ManageGatePass gatePass = new ManageGatePass();
gatePass.InsertGatePass(gatePassEntity);
}
//lock (gatePass)
//{
// Task.Run(() => gatePass.InsertGatePass(gatePassEntity));
//}
}
//#if (!DEBUG)
ManageDocumentIssues documentIssues = new ManageDocumentIssues();
Task.Run(() => documentIssues.GenerateIssues(issueList));
//if (isNewDoc)
//{
// ManageDataTransfer dataTransfer = new ManageDataTransfer();
// DataTransferEntity transferEntity = new DataTransferEntity();
// transferEntity.DocNumber = SINo;
// transferEntity.DocType = 2;
// transferEntity.TripType = 2;
// transferEntity.RCode = issueList.RCode;
// transferEntity.GCode = issueList.IssuingCode;
// // dataTransfer.InsertDataTransfer(transferEntity);
// Task.Run(() => dataTransfer.InsertDataTransfer(transferEntity));
//}
// Delete Stock issue Item Details
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "DeleteSIItemDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@SINo", SINo);
sqlCommand.ExecuteNonQuery();
//Insert data into SI Item details
List <DocumentStockIssuesItemEntity> stockIssuesItemEntities = new List <DocumentStockIssuesItemEntity>();
stockIssuesItemEntities = issueList.IssueItemList;
foreach (var item in stockIssuesItemEntities)
{
if (item.TStockNo.ToUpper() != "TOTAL")
{
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "InsertSIItemDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@RowId", RowID);
sqlCommand.Parameters.AddWithValue("@SINo", SINo);
sqlCommand.Parameters.AddWithValue("@TStockNo", item.TStockNo);
sqlCommand.Parameters.AddWithValue("@ICode", item.ICode);
sqlCommand.Parameters.AddWithValue("@IPCode", item.IPCode);
sqlCommand.Parameters.AddWithValue("@NoPacking", item.NoPacking);
sqlCommand.Parameters.AddWithValue("@WTCode", item.WTCode);
sqlCommand.Parameters.AddWithValue("@GKgs", item.GKgs);
sqlCommand.Parameters.AddWithValue("@Nkgs", item.Nkgs);
sqlCommand.Parameters.AddWithValue("@Moisture", item.Moisture);
sqlCommand.Parameters.AddWithValue("@Scheme", item.Scheme);
sqlCommand.Parameters.AddWithValue("@RCode", issueList.RCode);
sqlCommand.Parameters.AddWithValue("@ExportFlag", "N");
sqlCommand.Parameters.AddWithValue("@flag1", item.StackYear); //StackYear
sqlCommand.Parameters.AddWithValue("@Flag2", "-");
sqlCommand.ExecuteNonQuery();
}
}
//Insert data into IssueMemoDoNo Item details
List <DocumentStockIssueDetailsEntity> stockIssueDetailsEntities = new List <DocumentStockIssueDetailsEntity>();
stockIssueDetailsEntities = issueList.SIDetailsList;
foreach (var item in stockIssueDetailsEntities)
{
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "InsertIssuememodono";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Issuememono", SINo);
sqlCommand.Parameters.AddWithValue("@IssueMemoDate", item.SIDate);
sqlCommand.Parameters.AddWithValue("@DeliveryOrderNo", item.DNo);
sqlCommand.Parameters.AddWithValue("@DeliveryOrderDate", item.DDate);
sqlCommand.Parameters.AddWithValue("@Godowncode", item.GodownCode);
sqlCommand.Parameters.AddWithValue("@RCode", issueList.RCode);
sqlCommand.Parameters.AddWithValue("@ExportFlag", "N");
sqlCommand.Parameters.AddWithValue("@RowId", RowID);
sqlCommand.Parameters.AddWithValue("@Flag1", "-");
sqlCommand.Parameters.AddWithValue("@Flag2", "-");
sqlCommand.ExecuteNonQuery();
}
System.Threading.Thread.Sleep(100);
objTrans.Commit();
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
return(new Tuple <bool, string, string>(true, GlobalVariable.SavedMessage + SINo, SINo));
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " : " + ex.StackTrace);
objTrans.Rollback();
return(new Tuple <bool, string, string>(false, GlobalVariable.ErrorMessage, ""));
}
finally
{
sqlConnection.Close();
sqlCommand.Dispose();
ds.Dispose();
isNewDoc = false;
}
}
}
