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