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