public void TruckMemoRegCommodityAbstract(StreamWriter sw, CommonEntity entity) { // var distinctDate = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Issue_Date"); //Date wise DO report int iCount = 11; string sIssuer = string.Empty; string sDoNo = string.Empty; //foreach (DataRow dateValue in distinctDate.Rows) //{ iCount = 11; string sDoNo1 = string.Empty; List <TruckMemoRegEntity> dORegEntities = new List <TruckMemoRegEntity>(); dORegEntities = report.ConvertDataTableToList <TruckMemoRegEntity>(entity.dataSet.Tables[0]); // Gets the group by values based on ths column To_Whom_Issued, Commodity,Scheme var myResult = from a in dORegEntities orderby a.Commodity ascending group a by new { a.Commodity, a.TRName } into gValue select new { NoBags = gValue.Sum(s => s.NoBags), NetWt = gValue.Sum(s => s.NetWt), GroupByNames = gValue.Key }; AddHeaderforTMCommodityAbstract(sw, entity); foreach (var item in myResult) { if (iCount >= 50) { //Add header again iCount = 11; sw.WriteLine("-----------------------------------------------------------------------------------------------------------------------------------"); sw.WriteLine((char)12); AddHeaderforTMAbstract(sw, entity); } sw.Write(report.StringFormatWithoutPipe(item.GroupByNames.TRName, 18, 2)); sw.Write(report.StringFormatWithoutPipe(item.GroupByNames.Commodity, 44, 2)); sw.Write(report.StringFormatWithoutPipe(item.NoBags.ToString(), 10, 1)); sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item.NetWt.ToString()), 25, 1)); iCount++; sw.WriteLine(""); } sw.WriteLine("-----------------------------------------------------------------------------------------------------------------------------------"); sw.WriteLine((char)12); // } }
public void GenerateDeliveryOrderForRegister(CommonEntity entity) { string fPath = string.Empty, sPath = string.Empty, sFileName = string.Empty; string filePath = string.Empty; StreamWriter sw = null; try { GName = entity.dataTable.Rows[0]["Godown"].ToString(); Regioncode = entity.dataTable.Rows[0]["Region"].ToString(); sFileName = entity.GCode + GlobalVariable.StockDORegisterFileName; fPath = GlobalVariable.ReportPath + "Reports"; report.CreateFolderIfnotExists(fPath); // create a new folder if not exists sPath = fPath + "//" + entity.UserName; //ManageReport.GetDateForFolder(); report.CreateFolderIfnotExists(sPath); //delete file if exists filePath = sPath + "//" + sFileName + ".txt"; report.DeleteFileIfExists(filePath); sw = new StreamWriter(filePath, true); WriteDORegForDateWise(sw, entity); // sw.WriteLine((char)12); List <DORegEntity> dORegEntities = new List <DORegEntity>(); dORegEntities = report.ConvertDataTableToList <DORegEntity>(entity.dataTable); WriteDORegforSocityandScheme(sw, dORegEntities, entity); WriteDORegforItemandScheme(sw, dORegEntities, entity); WriteDORegforItem(sw, dORegEntities, entity); sw.Flush(); //send mail to corresponding godown. } catch (Exception ex) { AuditLog.WriteError("GenerateDeliveryOrderForRegister " + ex.Message + " : " + ex.StackTrace); } finally { sw.Close(); sw = null; fPath = string.Empty; sFileName = string.Empty; } }
/// <summary> /// /// </summary> /// <param name="entity"></param> public void GenerateStockReceiptRegister(CommonEntity entity) { string fPath = string.Empty, subF_Path = string.Empty, fileName = string.Empty, filePath = string.Empty; StreamWriter streamWriter = null; try { GName = entity.dataSet.Tables[0].Rows[0]["Godownname"].ToString(); RName = entity.dataSet.Tables[0].Rows[0]["Region"].ToString(); fileName = entity.GCode + GlobalVariable.StockReceiptRegisterFileName; 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); DateWiseStockReceiptRegister(streamWriter, entity); List <StockReceiptList> stockReceiptList = new List <StockReceiptList>(); stockReceiptList = report.ConvertDataTableToList <StockReceiptList>(entity.dataSet.Tables[0]); // DateWiseStockReceiptRegister(streamWriter, entity); StockReceiptAbstractRecdTypeAndSchemeWise(streamWriter, stockReceiptList, entity); StockReceiptAbstractSchemeAndCommodityWise(streamWriter, stockReceiptList, entity); StockReceiptAbstractStackNoAndCommodity(streamWriter, stockReceiptList, entity); StockReceiptAbstractCommodityWise(streamWriter, stockReceiptList, entity); streamWriter.Flush(); } catch (Exception ex) { AuditLog.WriteError(ex.Message + " " + ex.StackTrace); } finally { streamWriter.Close(); fPath = string.Empty; fileName = string.Empty; streamWriter = null; } }
/// <summary> /// /// </summary> /// <param name="entity"></param> public void GenerateHullingReport(CommonEntity entity) { //AuditLog.WriteError("GenerateHullingReport"); string fPath = string.Empty, subF_Path = string.Empty, fileName = string.Empty, filePath = string.Empty; StreamWriter streamWriter = null; try { GName = entity.dataSet.Tables[0].Rows[0]["Godownname"].ToString(); RName = entity.dataSet.Tables[0].Rows[0]["Region"].ToString(); fileName = entity.GCode + GlobalVariable.HullingDetailsReportFileName; 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); DateWiseHullingDetails(streamWriter, entity); List <HullingReportEntity> hullingReportList = new List <HullingReportEntity>(); hullingReportList = report.ConvertDataTableToList <HullingReportEntity>(entity.dataSet.Tables[0]); HullingDetailsAbstract(streamWriter, hullingReportList, entity); streamWriter.Flush(); } catch (Exception ex) { AuditLog.WriteError(ex.Message + " " + ex.StackTrace); } finally { streamWriter.Close(); fPath = string.Empty; fileName = string.Empty; streamWriter = null; } }
/// <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; } }
public void InsertSalesTaxDetails(DocumentDeliveryOrderEntity deliveryOrderEntity, string SRNo) { try { if (deliveryOrderEntity.DOTaxStatus == "YES") { //Get values to calculate the GST value. DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@EffectDate", deliveryOrderEntity.DoDate)); ds = manageSQLConnection.GetDataSetValues("GetRateMasterData", sqlParameters); ManageReport report = new ManageReport(); if (report.CheckDataAvailable(ds)) { sqlCommand.Parameters.Clear(); sqlCommand.Dispose(); List <RateEntity> _rateEntity = new List <RateEntity>(); _rateEntity = report.ConvertDataTableToList <RateEntity>(ds.Tables[0]); sqlCommand = new SqlCommand(); sqlCommand.Transaction = objTrans; sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = "DeleteDOSalesTaxDetails"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@BillNo", SRNo); sqlCommand.Parameters.AddWithValue("@GCode", deliveryOrderEntity.IssuerCode); sqlCommand.ExecuteNonQuery(); var creditSales = (deliveryOrderEntity.TransactionCode == "TR019") ? true : false; decimal gst = 0, taxPercent = 0, taxAmnt = 0, rate = 0, amnt = 0; foreach (var item in deliveryOrderEntity.documentDeliveryItems) { //Filter the value based on HSN no and Scheme. var result = (from a in _rateEntity where a.Hsncode == item.HsnCode && a.Scheme == item.Scheme select a).FirstOrDefault(); if (result != null) { item.TaxPercent = Convert.ToString(result.TaxPercentage); rate = result.Rate; } else { item.TaxPercent = "100"; rate = 0; } sqlCommand.Parameters.Clear(); sqlCommand.Dispose(); sqlCommand = new SqlCommand(); sqlCommand.Transaction = objTrans; sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = "InsertIntoGSTSalesTax"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@BillNo", SRNo); sqlCommand.Parameters.AddWithValue("@BillDate", deliveryOrderEntity.DoDate); sqlCommand.Parameters.AddWithValue("@Month", deliveryOrderEntity.Month); sqlCommand.Parameters.AddWithValue("@Year", deliveryOrderEntity.Year); sqlCommand.Parameters.AddWithValue("@CompanyID", deliveryOrderEntity.PartyID); sqlCommand.Parameters.AddWithValue("@CreditSales", creditSales); sqlCommand.Parameters.AddWithValue("@TaxPercentage", item.TaxPercent); sqlCommand.Parameters.AddWithValue("@Hsncode", item.HsnCode); sqlCommand.Parameters.AddWithValue("@CommodityID", item.Itemcode); sqlCommand.Parameters.AddWithValue("@TaxType", "CGST"); sqlCommand.Parameters.AddWithValue("@Measurement", item.Wtype); sqlCommand.Parameters.AddWithValue("@Quantity", item.NetWeight); taxPercent = (Convert.ToDecimal(item.TaxPercent) / 2); // rate = ((Convert.ToDouble(item.Rate)) - ((Convert.ToDouble(item.Rate) * Convert.ToDouble(item.TaxPercent)) / 100)); sqlCommand.Parameters.AddWithValue("@Rate", rate); amnt = (Convert.ToDecimal(item.NetWeight) * rate); sqlCommand.Parameters.AddWithValue("@Amount", amnt); gst = ((amnt * taxPercent) / 100); sqlCommand.Parameters.AddWithValue("@CGST", gst); sqlCommand.Parameters.AddWithValue("@SGST", gst); taxAmnt = (gst * 2); sqlCommand.Parameters.AddWithValue("@TaxAmount", taxAmnt); sqlCommand.Parameters.AddWithValue("@Total", (amnt + taxAmnt)); sqlCommand.Parameters.AddWithValue("@RCode", item.Rcode); sqlCommand.Parameters.AddWithValue("@GCode", deliveryOrderEntity.IssuerCode); sqlCommand.Parameters.AddWithValue("@CreatedBy", deliveryOrderEntity.UserID); sqlCommand.Parameters.AddWithValue("@Scheme", item.Scheme); sqlCommand.Parameters.AddWithValue("@DORate", item.Rate); sqlCommand.Parameters.AddWithValue("@DOTotal", item.Total); sqlCommand.ExecuteNonQuery(); } } } } catch (Exception ex) { AuditLog.WriteError(ex.Message); } }