public List <ReceiptTranscationDto> GetGroupReceiptAccountdetails(int groupID, string transactionDate)
{
List <ReceiptTranscationDto> lstGroupReceiptDto = new List <ReceiptTranscationDto>();
try
{
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@GroupID", groupID);
parms[0].SqlDbType = SqlDbType.Int;
parms[1] = new SqlParameter("@TransactionDate", transactionDate);
parms[1].SqlDbType = SqlDbType.VarChar;
SqlDataReader sdr = obj.ExecDataReaderProc("uspGetGroupReceiptTemplate", parms);
while (sdr.Read())
{
ReceiptTranscationDto objLoanOBLookup = new ReceiptTranscationDto();
objLoanOBLookup.AHID = Convert.ToInt32(sdr["AHID"]);
objLoanOBLookup.AHCode = Convert.ToString(sdr["AHCode"]);
objLoanOBLookup.AHName = sdr["AHName"].ToString();
objLoanOBLookup.ClosingBalance = Convert.ToDecimal(sdr["ClosingBalance"]);
objLoanOBLookup.SLAcNo = Convert.ToString(sdr["SLAccount"]);
lstGroupReceiptDto.Add(objLoanOBLookup);
}
}
catch (Exception ex)
{
}
return(lstGroupReceiptDto);
}
private ReceiptTranscationDto GetAccountHeadClosingBalnces()
{
ReceiptTranscationDto objReceiptTranscationDto = new ReceiptTranscationDto();
objReceiptTranscationDto = _groupReceiptService.GetAccountHeadClosingBalnces();
return(objReceiptTranscationDto);
}
public ActionResult CreateJournalEntryVoucher(string Id)
{
long AccountMasterId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt64(Id.DecryptString());
ReceiptMasterDto objDto = new ReceiptMasterDto();
if (AccountMasterId > 0)
{
objDto = _journalService.GetByID(AccountMasterId);
if (objDto.lstGroupReceiptTranscationDto.Count > 0)
{
List <ReceiptTranscationDto> lstAccounts = new List <ReceiptTranscationDto>();
var list = objDto.lstGroupReceiptTranscationDto;
foreach (var i in list)
{
ReceiptTranscationDto Addrecaccount = new ReceiptTranscationDto();
Addrecaccount.AHID = i.AHID;
Addrecaccount.AHName = i.AHName;
Addrecaccount.AHCode = i.AHCode;
Addrecaccount.DrAmount = i.DrAmount;
Addrecaccount.CrAmount = i.CrAmount;
lstAccounts.Add(Addrecaccount);
}
objDto.lstGroupReceiptTranscationDto = lstAccounts;
}
}
LoadDropDown();
int EmployeeID = UserInfo.UserID;
EmployeeDto ObjEmployee = _employeeService.GetByID(EmployeeID);
objDto.EmployeeCode = ObjEmployee.EmployeeCode;
objDto.EmployeeName = ObjEmployee.EmployeeName;
return(View(objDto));
}
private ReceiptMasterDto ReadFormData(FormCollection form)
{
ReceiptMasterDto groupReceiptDto = new ReceiptMasterDto();
int AccountMasterID = default(int);
DateTime dtTransactiondate = form["txtTransactionDate"].ConvertToDateTime();
int.TryParse(form["AccountTranID"], out AccountMasterID);
groupReceiptDto.UserID = UserInfo.UserID;
groupReceiptDto.EmployeeID = UserInfo.UserID;
groupReceiptDto.VoucherRefNumber = Convert.ToString(form["JournalEntryRefNo"]);
groupReceiptDto.AccountMasterID = Convert.ToInt64(form["AccountMasterID"]);
groupReceiptDto.Amount = Convert.ToDecimal(form["hdnTotal"]);
groupReceiptDto.EmployeeName = Convert.ToString(form["EmployeeName"]);
groupReceiptDto.TransactionDate = dtTransactiondate;
groupReceiptDto.AHID = Convert.ToInt32(form["AHID"]);
groupReceiptDto.AHCode = Convert.ToString(form["AHCode"]);
groupReceiptDto.AHName = Convert.ToString(form["AHName"]);
groupReceiptDto.Amount = Convert.ToDecimal(form["hdnTotal"]);
groupReceiptDto.TransactionMode = Convert.ToString(form["TransactionMode"]);
groupReceiptDto.Narration = Convert.ToString(form["Narration"]);
groupReceiptDto.TransactionType = Convert.ToInt32(form["TransactionType"]);
int maxIndex = Convert.ToInt32(form["hdnMaxJournalIndex"]);
groupReceiptDto.lstGroupReceiptTranscationDto = new List <ReceiptTranscationDto>();
ReceiptTranscationDto Amount = null;
for (int i = 1; i <= maxIndex; i++)
{
if (form["hdnAHCode_" + i] == null)
{
continue;
}
Amount = new ReceiptTranscationDto();
//if ((form["hdnSLAccountNo_" + i]) != "")
//{
// Amount.AHID = Convert.ToInt32(form["hdnSLAccountID_" + i]);
//}
//else
//{
Amount.AHID = Convert.ToInt32(form["hdnAHID_" + i]);
//}
Amount.AHName = form["hdnAHCode_" + i];
//Amount.AHCode = form["hdnSLACNo_" + i];
//Amount.AHName = form["hdnSLAName_" + i];
Amount.DrAmount = Convert.ToDecimal(form["hdnDrAmount_" + i]);
Amount.CrAmount = Convert.ToDecimal(form["hdnCrAmount_" + i]);
Amount.AccountTranID = Convert.ToInt64(form["hdnAccountTranID_" + i]);
groupReceiptDto.lstGroupReceiptTranscationDto.Add(Amount);
}
return(groupReceiptDto);
}
private ReceiptMasterDto ReadFormData(FormCollection form)
{
var ReceiptTranscationDto = GetAccountHeadClosingBalnces();
ViewBag.CashInHandDetails = ReceiptTranscationDto;
ReceiptMasterDto groupReceiptDto = new ReceiptMasterDto();
int accountMasterId = default(int);
int.TryParse(form["AccountMasterID"], out accountMasterId);
groupReceiptDto.IsGroup = false;
groupReceiptDto.SubHeadID = 1;
groupReceiptDto.AccountMasterID = Convert.ToInt32(form["AccountMasterID"]);
groupReceiptDto.VoucherNumber = Convert.ToString(form["VoucherNumber"]);
groupReceiptDto.GroupID = Convert.ToInt32(form["GroupID"]);
groupReceiptDto.GroupName = Convert.ToString(form["GroupName"]);
groupReceiptDto.EmployeeID = Convert.ToInt32(form["EmployeeID"]);
groupReceiptDto.EmployeeCode = Convert.ToString(form["EmployeeCode"]);
groupReceiptDto.EmployeeName = Convert.ToString(form["EmployeeName"]);
DateTime dtTransactionDate = DateTime.ParseExact(form["TransactionDate"], "dd/MMM/yyyy", provider);
DateTime dtChequeDate = DateTime.Now;
if (form["ChequeDate"] != null && form["ChequeDate"] != string.Empty)
{
dtChequeDate = DateTime.ParseExact(form["ChequeDate"], "dd/MMM/yyyy", provider);
}
groupReceiptDto.TransactionDate = dtTransactionDate;
groupReceiptDto.ChequeDate = dtChequeDate;
groupReceiptDto.AHID = Convert.ToInt32(form["AccountHeadId"]);
groupReceiptDto.TransactionType = Convert.ToInt32(form["TransactionType"]);
groupReceiptDto.TransactionMode = Convert.ToString(Request.Form["TransactionMode"]);
groupReceiptDto.Amount = Convert.ToDecimal(form["Amount"]);
groupReceiptDto.GroupBankAccountName = Convert.ToString(form["GroupBankAccountName"]);
groupReceiptDto.GroupBankAccountNumber = Convert.ToString(form["GroupBankAccountNumber"]);
groupReceiptDto.ChequeNumber = Convert.ToString(form["ChequeNumber"]);
groupReceiptDto.VoucherRefNumber = Convert.ToString(form["VoucherRefNumber"]);
if (form["FederationBankAccountNumber"] != null && form["FederationBankAccountNumber"] != string.Empty && form["FederationBankAccountNumber"] != "0")
{
groupReceiptDto.BankAccount = Convert.ToInt32(form["FederationBankAccountNumber"]);
}
groupReceiptDto.FederationBankAccountName = Convert.ToString(form["FederationBankAccountName"]);
groupReceiptDto.Narration = Convert.ToString(form["Narration"]);
groupReceiptDto.PartyName = Convert.ToString(form["PartyName"]);
groupReceiptDto.UserID = UserInfo.UserID;
int myIndex = Convert.ToInt32(form["index"]);
groupReceiptDto.lstGroupReceiptTranscationDto = new List <ReceiptTranscationDto>();
ReceiptTranscationDto receipt = null;
//foreach (var rpt in groupReceiptDto.lstGroupReceiptTranscationDto)
for (int i = 1; i <= myIndex; i++)
{
receipt = new ReceiptTranscationDto();
receipt.AHID = Convert.ToInt32(form["AHID_" + i]);
receipt.AHName = Convert.ToString(form["AHName_" + i]);
receipt.OpeningBalance = Convert.ToDecimal(form["OpeningBalance_" + i]);
receipt.CrAmount = Convert.ToDecimal(form["CrAmount_" + i]);
receipt.IsMaster = false;
groupReceiptDto.lstGroupReceiptTranscationDto.Add(receipt);
}
receipt = new ReceiptTranscationDto();
receipt.AHID = groupReceiptDto.AHID;
receipt.AHName = "";
receipt.IsMaster = true;
//receipt.OpeningBalance = Convert.ToDecimal(form["OpeningBalance_" + i]);
receipt.CrAmount = groupReceiptDto.lstGroupReceiptTranscationDto.Sum(s => s.CrAmount);
groupReceiptDto.lstGroupReceiptTranscationDto.Add(receipt);
return(groupReceiptDto);
}
private ReceiptMasterDto ReadFormData(FormCollection form)
{
ReceiptMasterDto groupReceiptDto = new ReceiptMasterDto();
int accountMasterId = default(int);
int.TryParse(form["AccountMasterID"], out accountMasterId);
groupReceiptDto.IsGroup = true;
groupReceiptDto.SubHeadID = 1;
groupReceiptDto.AccountMasterID = accountMasterId;
groupReceiptDto.MemberId = Convert.ToInt32(form["MemberId"]);
groupReceiptDto.VoucherRefNumber = Convert.ToString(form["VoucherRefNumber"]);
//groupReceiptDto.GroupID = Convert.ToInt32(form["GroupID"]);
groupReceiptDto.EmployeeID = UserInfo.UserID;
//groupReceiptDto.EmployeeCode = UserInfo.e ;
//groupReceiptDto.EmployeeName = Convert.ToString(form["EmployeeName"]);
groupReceiptDto.TransactionDate = Convert.ToDateTime(form["TransactionDate"]);
groupReceiptDto.TransactionType = Convert.ToInt32(form["TransactionType"]);
groupReceiptDto.TransactionMode = Convert.ToString(Request.Form["TransactionMode"]);
groupReceiptDto.Amount = Convert.ToDecimal(form["Amount"]);
if (form["GroupBankAccountNumber"] != null && form["GroupBankAccountNumber"] != string.Empty && form["GroupBankAccountNumber"] != "0")
{
groupReceiptDto.BankAccount = Convert.ToInt32(form["GroupBankAccountNumber"]);
}
if (groupReceiptDto.TransactionMode == "B")
{
groupReceiptDto.GroupBankAccountName = Convert.ToString(form["GroupBankAccountName"]);
groupReceiptDto.ChequeNumber = Convert.ToString(form["ChequeNumber"]);
groupReceiptDto.ChequeDate = Convert.ToDateTime(form["ChequeDate"]);
}
groupReceiptDto.AHID = Convert.ToInt32(form["hdnCashInHandAHID"]);
groupReceiptDto.ReferenceNumber = Convert.ToString(form["ReferenceNumber"]);
groupReceiptDto.FederationBankAccountNumber = Convert.ToString(form["FederationBankAccountNumber"]);
groupReceiptDto.FederationBankAccountName = Convert.ToString(form["FederationBankAccountName"]);
groupReceiptDto.Narration = Convert.ToString(form["Narration"]);
groupReceiptDto.PartyName = Convert.ToString(form["PartyName"]);
groupReceiptDto.UserID = UserInfo.UserID;
groupReceiptDto.GroupID = GroupInfo.GroupID;
int myIndex = Convert.ToInt32(form["index"]);
groupReceiptDto.lstGroupReceiptTranscationDto = new List <ReceiptTranscationDto>();
ReceiptTranscationDto receipt = null;
//foreach (var rpt in groupReceiptDto.lstGroupReceiptTranscationDto)
for (int i = 1; i <= myIndex; i++)
{
receipt = new ReceiptTranscationDto();
receipt.CrAmount = Convert.ToDecimal(form["CrAmount_" + i]);
if (receipt.CrAmount <= 0)
{
continue;
}
receipt.AHID = Convert.ToInt32(form["AHID_" + i]);
receipt.AHName = Convert.ToString(form["AHName_" + i]);
//receipt.OpeningBalance = Convert.ToDecimal(form["OpeningBalance_" + i]);
receipt.IsMaster = false;
groupReceiptDto.lstGroupReceiptTranscationDto.Add(receipt);
}
receipt = new ReceiptTranscationDto();
receipt.AHID = groupReceiptDto.AHID;
receipt.AHName = "";
receipt.IsMaster = true;
//receipt.OpeningBalance = Convert.ToDecimal(form["OpeningBalance_" + i]);
receipt.DrAmount = groupReceiptDto.lstGroupReceiptTranscationDto.Sum(s => s.CrAmount);
groupReceiptDto.lstGroupReceiptTranscationDto.Add(receipt);
return(groupReceiptDto);
}
