public void GenerateDDCheque(DDChequeEntity chequeEntity)
{
string fPath = string.Empty, subF_Path = string.Empty, fileName = string.Empty, filePath = string.Empty;
StreamWriter streamWriter = null;
try
{
fileName = chequeEntity.GCode + GlobalVariable.DDChequeFileName;
fPath = GlobalVariable.ReportPath + "Reports";
report.CreateFolderIfnotExists(fPath); // create a new folder if not exists
subF_Path = fPath + "//" + chequeEntity.UserID; //ManageReport.GetDateForFolder();
report.CreateFolderIfnotExists(subF_Path);
//delete file if exists
filePath = subF_Path + "//" + fileName + ".txt";
report.DeleteFileIfExists(filePath);
// isDuplicate = ReceiptId == "0" ? false : true;
streamWriter = new StreamWriter(filePath, true);
AddDocHeaderForReceipt(streamWriter, chequeEntity);
AddDetails(streamWriter, chequeEntity);
AddFooter(streamWriter, chequeEntity);
}
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(DDChequeEntity chequeEntity = null)
{
if (chequeEntity.Type == 2)
{
ManageDDCheque manageDDCheque = new ManageDDCheque();
manageDDCheque.GenerateDDCheque(chequeEntity);
return(new Tuple <bool, string, string>(true, "Print Generated !", chequeEntity.ReceiptNo));
}
else
{
ManageSQLForDDCheque manageSQL = new ManageSQLForDDCheque();
return(manageSQL.InsertDDChequeEntry(chequeEntity));
}
}
/// <summary>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockReceipt"></param>
public void AddDetails(StreamWriter streamWriter, DDChequeEntity chequeEntity)
{
int i = 0;
foreach (var item in chequeEntity.DDChequeItems)
{
i = i + 1;
streamWriter.Write(" ");
streamWriter.Write(report.StringFormat(item.PaymentType + " " + item.ChequeNo + " ", 16, 2));
streamWriter.Write(report.StringFormat(report.FormatIndianDate(item.ChequeDate) + " ", 10, 2));
streamWriter.Write(report.StringFormat(item.Bank + " ", 30, 2));
streamWriter.Write(report.StringFormat(item.Amount, 14, 1));
streamWriter.WriteLine(" ");
}
}
/// <summary>
/// Add header for document receipt
/// </summary>
/// <param name="streamWriter">Stream writer to write the text file.</param>
/// <param name="stockReceipt"></param>
/// <param name="isDuplicate"></param>
public void AddDocHeaderForReceipt(StreamWriter streamWriter, DDChequeEntity chequeEntity)
{
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" TAMILNADU CIVIL SUPPLIES CORPORATION ");
streamWriter.Write(" ");
streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.RegionName, 30, 1));
streamWriter.Write(report.StringFormatWithoutPipe("- RECEIPT -", 11, 2));
streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.GodownName, 30, 2));
streamWriter.WriteLine("");
streamWriter.Write(" RECP.NO.: "); //"R00002 DATE: 03/Jan/2011");
streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.ReceiptNo, 25, 2));
streamWriter.Write(" ");
streamWriter.Write("DATE : ");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(chequeEntity.ReceiptDate), 13, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine("------------------------------------------------------------------------------");
streamWriter.Write(" Received with Thanks from Thiru / M/s.");
streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.DDChequeItems[0].ReceivedFrom, 35, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine("");
streamWriter.Write(" Rupees ");
string Rupees = string.Empty;
try
{
NumberToWordConvertion numberToWord = new NumberToWordConvertion();
//string[] split = chequeEntity.Total.Split('.');
Rupees = numberToWord.GetNumberToWord(chequeEntity.Total);
// ConvertNumbertoWords(Convert.ToInt64(split[0].ToString()));
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
streamWriter.Write(report.StringFormatWithoutPipe(Rupees, 68, 2));
streamWriter.WriteLine("");
report.AddMoreContent(streamWriter, Rupees, 68, 1);//Add content next line.
streamWriter.WriteLine("");
streamWriter.WriteLine(" by Cash/DD/Cheque ");
streamWriter.WriteLine("------------------------------------------------------------------------------");
streamWriter.WriteLine(" DD/Cheque No. Date Bank Amount");
streamWriter.WriteLine("------------------------------------------------------------------------------");
}
/// <summary>
/// Add footer for document receipt
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockReceipt"></param>
public void AddFooter(StreamWriter streamWriter, DDChequeEntity chequeEntity)
{
streamWriter.WriteLine("------------------------------------------------------------------------------");
streamWriter.Write(" Total |");
streamWriter.Write(report.StringFormat(chequeEntity.Total, 14, 1));
streamWriter.WriteLine(" ");
streamWriter.WriteLine("------------------------------------------------------------------------------");
streamWriter.WriteLine(report.StringFormatWithoutPipe(chequeEntity.Details, 55, 2));
report.AddMoreContent(streamWriter, chequeEntity.Details, 55, 1);//Add content next line.
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" For Tamil Nadu Civil Supplies Corporation");
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" Asst./ Cashier Supdt. D.M A/c ");
streamWriter.Write(" ");
streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.RegionName, 30, 1));
streamWriter.WriteLine();
streamWriter.WriteLine((char)12);
}
public Tuple <bool, string, string> InsertDDChequeEntry(DDChequeEntity chequeEntity)
{
SqlTransaction objTrans = null;
string RowID = string.Empty;
using (sqlConnection = new SqlConnection(GlobalVariable.ConnectionString))
{
DataSet ds = new DataSet();
sqlCommand = new SqlCommand();
try
{
if (sqlConnection.State == 0)
{
sqlConnection.Open();
}
objTrans = sqlConnection.BeginTransaction();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "Insertmemofile";
sqlCommand.CommandType = CommandType.StoredProcedure;
// sqlCommand.Parameters.AddWithValue("@RowId", chequeEntity.RowId);
sqlCommand.Parameters.AddWithValue("@vrno1", chequeEntity.ReceiptNo);
sqlCommand.Parameters.AddWithValue("@godcode", chequeEntity.GCode);
sqlCommand.Parameters.AddWithValue("@detail", chequeEntity.Details);
sqlCommand.Parameters.AddWithValue("@vropt", "1");
sqlCommand.Parameters.AddWithValue("@casopt", "CL1");
sqlCommand.Parameters.AddWithValue("@eflag", "N");
sqlCommand.Parameters.Add("@vrno", SqlDbType.NVarChar, 26);
sqlCommand.Parameters["@vrno"].Direction = ParameterDirection.Output;
sqlCommand.ExecuteNonQuery();
RowID = Convert.ToString(sqlCommand.Parameters["@vrno"].Value);
chequeEntity.ReceiptNo = RowID;
// Generate Text file
ManageDDCheque manageDDCheque = new ManageDDCheque();
manageDDCheque.GenerateDDCheque(chequeEntity);
foreach (var item in chequeEntity.DDChequeItems)
{
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "InsertReceiptChequedetail";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@vrno", chequeEntity.ReceiptNo);
sqlCommand.Parameters.AddWithValue("@godcode", chequeEntity.GCode);
sqlCommand.Parameters.AddWithValue("@cdopt", item.PaymentType);
sqlCommand.Parameters.AddWithValue("@cdno", item.ChequeNo);
sqlCommand.Parameters.AddWithValue("@cddate", item.ChequeDate);
sqlCommand.Parameters.AddWithValue("@cdamount", item.Amount);
sqlCommand.Parameters.AddWithValue("@cdbank", item.Bank);
sqlCommand.Parameters.AddWithValue("@cdwhom", item.ReceivedFrom);
sqlCommand.Parameters.AddWithValue("@whomcode", item.ReceivorCode);
sqlCommand.Parameters.AddWithValue("@recdate", chequeEntity.ReceiptDate);
sqlCommand.Parameters.AddWithValue("@eflag", "N");
sqlCommand.ExecuteNonQuery();
}
objTrans.Commit();
return(new Tuple <bool, string, string>(true, GlobalVariable.SavedMessage + " Receipt No : " + RowID, RowID));
}
catch (Exception ex)
{
objTrans.Rollback();
AuditLog.WriteError(ex.Message + " : " + ex.StackTrace);
return(new Tuple <bool, string, string>(false, GlobalVariable.ErrorMessage, ""));
}
finally
{
sqlConnection.Close();
sqlCommand.Dispose();
ds.Dispose();
}
}
}
