/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeComboFill()
{
try
{
DataTable dtblVoucherTypes = new DataTable();
VoucherTypeSP spVoucherType = new VoucherTypeSP();
dtblVoucherTypes = spVoucherType.VoucherTypeSelectionComboFill("Service Voucher");
DataRow dr = dtblVoucherTypes.NewRow();
dr["voucherTypeId"] = 0;
dr["voucherTypeName"] = "All";
dtblVoucherTypes.Rows.InsertAt(dr, 0);
cmbVoucherType.DataSource = dtblVoucherTypes;
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("SVRT 6 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeFill()
{
try
{
VoucherTypeSP spVoucherType = new VoucherTypeSP();
DataTable dtbl = new DataTable();
dtbl = spVoucherType.VoucherTypeSelectionComboFill("Physical Stock");
DataRow dr = dtbl.NewRow();
dr[0] = 0;
dr[1] = "All";
dtbl.Rows.InsertAt(dr, 0);
cmbVoucherType.DataSource = dtbl;
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("PSRT5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public string VoucherClear(string strVoucherNo, string dptVoucherDate, string editMode)
{
DataTable dtbl = new DataTable();
try
{
if (Convert.ToBoolean(editMode) == false)
{
decimal typeId = 27;
VoucherTypeSP spVoucherType = new VoucherTypeSP();
var isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(typeId);
return(voucherNumberGeneration(typeId, strVoucherNo, dptVoucherDate));
/*if (isAutomatic)
* {
* return voucherNumberGeneration(typeId, strVoucherNo, dptVoucherDate);
* }
* else
* {
* return string.Empty;
* }*/
}
//int inCount = dgvMonthlySalary.RowCount;
//for (int i = 0; i < inCount; i++)
//{
// dgvMonthlySalary.Rows[i].Cells["cmbStatus"].Value = null;
//}
return(string.Empty);
}
catch (Exception ex)
{
// MessageBox.Show("MSR2:" + ex.Message, "Masterfine", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(string.Empty);
}
/// <summary>
/// Function to fill VoucherType name combobox
/// </summary>
public void VoucherTypeNameComboFill()
{
try
{
VoucherTypeSP SpVoucherType = new VoucherTypeSP();
DataTable dtbl = new DataTable();
decimal decVoucherTypeId = 0;
decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
dtbl = SpVoucherType.VoucherTypeNameViewAllForComboFill(decVoucherTypeId);
DataRow dr = dtbl.NewRow();
dr[0] = 0;
dr[1] = "All";
dtbl.Rows.InsertAt(dr, 0);
cmbVoucherTypeName.DisplayMember = "voucherTypeName";
cmbVoucherTypeName.ValueMember = "voucherTypeId";
cmbVoucherTypeName.DataSource = dtbl;
cmbVoucherTypeName.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("AB2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public ActionResult GetAdvancePaymentEditDetails(string advancePaymentEditId)
{
try
{
decAdvancePaymentEditId = Convert.ToDecimal(advancePaymentEditId);
AdvancePaymentSP spadvance = new AdvancePaymentSP();
AdvancePaymentInfo infoadvance = new AdvancePaymentInfo();
VoucherTypeSP spvouchertype = new VoucherTypeSP();
infoadvance = spadvance.AdvancePaymentView(decAdvancePaymentEditId);
strVoucherNo = infoadvance.VoucherNo;
string txtAdvanceVoucherNo = infoadvance.InvoiceNo;
strInvoiceNo = infoadvance.InvoiceNo;
string employeeId = infoadvance.EmployeeId.ToString();
string salaryMonth = infoadvance.SalaryMonth.ToString("yyyy-MM");
string txtDate = infoadvance.Date.ToString("yyyy-MM-dd");
string txtChequeDate = infoadvance.Date.ToString("yyyy-MM-dd");
string ledgerId = infoadvance.LedgerId.ToString();
string txtCheckNo = infoadvance.Chequenumber;
string txtAmount = infoadvance.Amount.ToString();
string txtNarration = infoadvance.Narration;
bool isBankAccount = false;
decAdvancePaymentsId = decAdvancePaymentId;
TransactionsGeneralFill obj = new TransactionsGeneralFill();
DataTable cashOrBank = obj.CashOrBankComboFill(false);
DataTable employee = EmployeeComboFill();
string jsonCashOrBank = Utils.ConvertDataTabletoString(cashOrBank);
string jsonEmployee = Utils.ConvertDataTabletoString(employee);
if (cashOrBank.Rows.Count > 0)
{
decimal cashOrBankId = (decimal)cashOrBank.Rows[0][1];
string cashOrBankName = (string)cashOrBank.Rows[0][0];
isBankAccount = CheckWhetherBankOrCash(cashOrBankId, cashOrBankName);
}
decPaymentVoucherTypeId = infoadvance.VoucherTypeId;
decPaymentSuffixPrefixId = infoadvance.SuffixPrefixId;
isAutomatic = spvouchertype.CheckMethodOfVoucherNumbering(decPaymentVoucherTypeId);
return(Json(new
{
success = "true",
ex = "no",
data = new
{
voucherNo = strVoucherNo,
employee = jsonEmployee,
employeeId,
salaryMonth,
chequeNo = txtCheckNo,
date = txtDate,
amount = txtAmount,
cashOrBank = jsonCashOrBank,
ledgerId,
chequeDate = txtChequeDate,
narration = txtNarration,
isAutomatic,
isBankAccount
}
}));
}
catch (Exception ex)
{
return(Json(new { success = "true", ex = "AP3:" + ex.Message }));
}
}
/// <summary>
/// Function for edit
/// </summary>
public void EditFunction_MSV(string masterId, string tableData, string editMode)
{
try
{
List <Object> dgvMonthlySalary = JsonConvert.DeserializeObject <List <Object> >(tableData);
JArray itemFirst = (JArray)dgvMonthlySalary[0];
string voucherNo = Convert.ToString(itemFirst[0]["voucherNo"].Value <string>());
string voucherDate = Convert.ToString(itemFirst[0]["voucherDate"].Value <string>());
string month = Convert.ToString(itemFirst[0]["month"].Value <string>());
string cash = Convert.ToString(itemFirst[0]["cash"].Value <string>());
string totalAmount = Convert.ToString(itemFirst[0]["totalAmount"].Value <string>());
string narration = Convert.ToString(itemFirst[0]["narration"].Value <string>());
SalaryVoucherMasterSP spMaster = new SalaryVoucherMasterSP();
SalaryVoucherMasterInfo infoMaster = new SalaryVoucherMasterInfo();
SalaryVoucherDetailsSP spDetails = new SalaryVoucherDetailsSP();
SalaryVoucherDetailsInfo infoDetails = new SalaryVoucherDetailsInfo();
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
decimal masterID = Convert.ToDecimal(masterId);
infoMaster.SalaryVoucherMasterId = masterID;
infoMaster.Date = Convert.ToDateTime(voucherDate);
infoMaster.LedgerId = Convert.ToDecimal(cash);
infoMaster.Narration = narration;
infoMaster.TotalAmount = Convert.ToDecimal(totalAmount);
bool isEditMode = Convert.ToBoolean(editMode);
VoucherTypeSP spVoucherType = new VoucherTypeSP();
int decMonthlyVoucherTypeId = 27;
decimal typeId = Convert.ToDecimal(decMonthlyVoucherTypeId);
var isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(typeId);
infoMaster.VoucherNo = voucherNo;
infoMaster.InvoiceNo = voucherNo;
infoMaster.Extra1 = string.Empty;
infoMaster.Extra2 = string.Empty;
infoMaster.SuffixPrefixId = Convert.ToDecimal(ViewData["decMonthlySuffixPrefixId"]);
infoMaster.VoucherTypeId = typeId;
infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoMaster.Month = Convert.ToDateTime(month);
infoDetails.Extra1 = string.Empty;
infoDetails.Extra2 = string.Empty;
int inRowCount = dgvMonthlySalary.Count;
for (int i = 0; i < inRowCount; i++)
{
JArray item = (JArray)dgvMonthlySalary[i];
if (item[0]["txtEmployeeId"] != null)
{
infoDetails.EmployeeId = Convert.ToDecimal(item[0]["txtEmployeeId"].Value <string>());
}
if (item[0]["txtBonus"] != null)
{
infoDetails.Bonus = Convert.ToDecimal(item[0]["txtBonus"].Value <string>());
}
if (item[0]["txtDeduction"] != null)
{
infoDetails.Deduction = Convert.ToDecimal(item[0]["txtDeduction"].Value <string>());
}
if (item[0]["txtAdvance"] != null)
{
infoDetails.Advance = Convert.ToDecimal(item[0]["txtAdvance"].Value <string>());
}
if (item[0]["txtLop"] != null)
{
infoDetails.Lop = Convert.ToDecimal(item[0]["txtLop"].Value <string>());
}
if (item[0]["txtSalary"] != null)
{
infoDetails.Salary = Convert.ToDecimal(item[0]["txtSalary"].Value <string>());
}
if (item[0]["cmbStatus"] != null && Convert.ToString(item[0]["cmbStatus"].Value <string>()) == "Paid")
{
infoDetails.Status = Convert.ToString(item[0]["cmbStatus"].Value <string>());
}
if (Convert.ToString(item[0]["cmbStatus"].Value <string>()) == "Pending" && Convert.ToString(item[0]["txtMasterId"].Value <string>()) != "0")
{
decimal SalaryVoucherDetailsId = Convert.ToDecimal(item[0]["txtDetailsId"].Value <string>());
spDetails.SalaryVoucherDetailsDelete(SalaryVoucherDetailsId);
spMaster.SalaryVoucherMasterEdit(infoMaster);
//LedgerUpdate();
}
if (Convert.ToString(item[0]["cmbStatus"].Value <string>()) == "Paid" && Convert.ToString(item[0]["txtMasterId"].Value <string>()) == "0")
{
infoDetails.SalaryVoucherMasterId = masterID;
spDetails.MonthlySalaryVoucherDetailsAdd(infoDetails);
spMaster.SalaryVoucherMasterEdit(infoMaster);
//LedgerUpdate();
}
if (Convert.ToString(item[0]["cmbStatus"].Value <string>()) == "Pending" && Convert.ToString(item[0]["txtMasterId"].Value <string>()) == "0")
{
spMaster.SalaryVoucherMasterEdit(infoMaster);
//LedgerUpdate();
}
}
if (spDetails.SalaryVoucherDetailsCount(masterID) == 0)
{
spMaster.SalaryVoucherMasterDelete(masterID);
}
//GridFillVoucher(isEditMode, Convert.ToDateTime(month), voucherNo);
}
catch (Exception ex)
{
//MessageBox.Show("MSV8:" + ex.Message, "Masterfine", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void SaveFunction_MSV(string tableData, string editMode)
{
try
{
List <Object> dgvMonthlySalary = JsonConvert.DeserializeObject <List <Object> >(tableData);
JArray itemFirst = (JArray)dgvMonthlySalary[0];
string voucherNo = Convert.ToString(itemFirst[0]["voucherNo"].Value <string>());
string voucherDate = Convert.ToString(itemFirst[0]["voucherDate"].Value <string>());
string month = Convert.ToString(itemFirst[0]["month"].Value <string>());
string cash = Convert.ToString(itemFirst[0]["cash"].Value <string>());
string totalAmount = Convert.ToString(itemFirst[0]["totalAmount"].Value <string>());
string narration = Convert.ToString(itemFirst[0]["narration"].Value <string>());
SalaryVoucherMasterSP spMaster = new SalaryVoucherMasterSP();
SalaryVoucherMasterInfo infoMaster = new SalaryVoucherMasterInfo();
SalaryVoucherDetailsSP spDetails = new SalaryVoucherDetailsSP();
SalaryVoucherDetailsInfo infoDetails = new SalaryVoucherDetailsInfo();
DateTime dtpMonth = Convert.ToDateTime(month);
bool isEditMode = Convert.ToBoolean(editMode);
int decMonthlyVoucherTypeId = 27;
decimal typeId = Convert.ToDecimal(decMonthlyVoucherTypeId);
VoucherTypeSP spVoucherType = new VoucherTypeSP();
var isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(typeId);
//------------------------------- In the case of multi user check whether salary is paying for the sam person ----------------//
int inCounts = dgvMonthlySalary.Count;
int incont = 0;
decimal decVal = 0;
string strEployeeNames = "";
for (int i = 0; i < inCounts; i++)
{
JArray item = (JArray)dgvMonthlySalary[i];
decVal = Convert.ToDecimal(item[0]["txtEmployeeId"].Value <string>());
if (spDetails.CheckWhetherSalaryAlreadyPaid(decVal, dtpMonth) != "0")
{
strEployeeNames = strEployeeNames + spDetails.CheckWhetherSalaryAlreadyPaid(decVal, dtpMonth) + ",";
foreach (char ch in strEployeeNames)
{
if (ch == ',')
{
incont++;
}
}
if (incont == 15)
{
incont = 0;
strEployeeNames = strEployeeNames + Environment.NewLine;
}
}
}
if (spDetails.CheckWhetherSalaryAlreadyPaid(decVal, dtpMonth) != "0")
{
// Messages.InformationMessage("Salary already paid for - " + " " + strEployeeNames);
//GridFillVoucher(isEditMode, dtpMonth, voucherNo);
}
infoMaster.LedgerId = Convert.ToDecimal(cash);
infoMaster.VoucherNo = voucherNo;
infoMaster.Month = Convert.ToDateTime(dtpMonth);
infoMaster.Date = Convert.ToDateTime(voucherDate);
infoMaster.Narration = narration;
infoMaster.InvoiceNo = voucherNo;
if (totalAmount != string.Empty)
{
infoMaster.TotalAmount = Math.Round(Convert.ToDecimal(totalAmount), PublicVariables._inNoOfDecimalPlaces);
}
infoMaster.Extra1 = string.Empty; // Fields not in design//
infoMaster.Extra2 = string.Empty; // Fields not in design//
infoMaster.SuffixPrefixId = Convert.ToDecimal(ViewData["decMonthlySuffixPrefixId"]);
infoMaster.VoucherTypeId = typeId;
infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
int inCount = dgvMonthlySalary.Count;
int inValue = 0;
for (int i = 0; i < inCount; i++)
{
JArray item = (JArray)dgvMonthlySalary[i];
if (Convert.ToString(item[0]["cmbStatus"].Value <string>()) == "Paid")
{
inValue++;
}
}
if (inValue > 0)
{
//-------------------------In the case of Multi-User Check the VoucherNo. again (Max of VoucherNumber )---------------------//
DataTable dtbl = new DataTable();
decimal decMasterId = 0;
string strUpdatedVoucherNo = "", strUpdatedInvoiceNo = "";
dtbl = spMaster.MonthlySalaryVoucherMasterAddWithIdentity(infoMaster, isAutomatic);
foreach (DataRow dr in dtbl.Rows)
{
decMasterId = Convert.ToDecimal(dr.ItemArray[0].ToString());
strUpdatedVoucherNo = dr.ItemArray[1].ToString();
strUpdatedInvoiceNo = dr.ItemArray[2].ToString();
}
string strVoucherNo = "";
string strInvoiceNo = "";
if (!isAutomatic)
{
strVoucherNo = voucherNo;
}
if (isAutomatic)
{
if (strUpdatedVoucherNo != "" && Convert.ToDecimal(strUpdatedVoucherNo) != Convert.ToDecimal(voucherNo))
{
//Messages.InformationMessage("Voucher number changed from " + strInvoiceNo + " to " + strUpdatedInvoiceNo);
strVoucherNo = strUpdatedVoucherNo.ToString();
strInvoiceNo = strUpdatedInvoiceNo;
}
}
//LedgerPosting(Convert.ToDecimal(cash));
infoDetails.Extra1 = string.Empty;
infoDetails.Extra2 = string.Empty;
infoDetails.SalaryVoucherMasterId = decMasterId;
int inRowCount = dgvMonthlySalary.Count;
for (int i = 0; i < inRowCount; i++)
{
JArray item = (JArray)dgvMonthlySalary[i];
if (item[0]["txtEmployeeId"] != null)
{
infoDetails.EmployeeId = Convert.ToDecimal(item[0]["txtEmployeeId"].Value <string>());
}
if (item[0]["txtBonus"] != null)
{
infoDetails.Bonus = Convert.ToDecimal(item[0]["txtBonus"].Value <string>());
}
if (item[0]["txtDeduction"] != null)
{
infoDetails.Deduction = Convert.ToDecimal(item[0]["txtDeduction"].Value <string>());
}
if (item[0]["txtAdvance"] != null)
{
infoDetails.Advance = Convert.ToDecimal(item[0]["txtAdvance"].Value <string>());
}
if (item[0]["txtLop"] != null)
{
infoDetails.Lop = Convert.ToDecimal(item[0]["txtLop"].Value <string>());
}
if (item[0]["txtSalary"] != null)
{
infoDetails.Salary = Convert.ToDecimal(item[0]["txtSalary"].Value <string>());
}
if (item[0]["cmbStatus"] != null)
{
infoDetails.Status = Convert.ToString(item[0]["cmbStatus"].Value <string>()) == "Paid"? "Paid": string.Empty;
}
if (Convert.ToString(item[0]["cmbStatus"].Value <string>()) == "Paid" && Convert.ToString(item[0]["txtMasterId"].Value <string>()) == "0")
{
infoDetails.SalaryVoucherMasterId = decMasterId;
spDetails.MonthlySalaryVoucherDetailsAdd(infoDetails);
}
}
//GridFillVoucher(isEditMode,dtpMonth, voucherNo);
VoucherClear(strVoucherNo, voucherDate, editMode);
}
else
{
//Messages.InformationMessage("Can't save without atleast one employee");
voucherNo = spMaster.SalaryVoucherMasterGetMax(typeId);
}
}
catch (Exception ex)
{
//MessageBox.Show("MSV7:" + ex.Message, "Masterfine", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public ActionResult SaveOrEdit(string masterId, string tableData, string editMode)
{
try
{
List <Object> dgvMonthlySalary = JsonConvert.DeserializeObject <List <Object> >(tableData);
JArray itemFirst = (JArray)dgvMonthlySalary[0];
decimal masterID = Convert.ToDecimal(masterId);
SalaryVoucherMasterSP spMaster = new SalaryVoucherMasterSP();
bool isEditMode = Convert.ToBoolean(editMode);
int decMonthlyVoucherTypeId = 27;
decimal typeId = Convert.ToDecimal(decMonthlyVoucherTypeId);
VoucherTypeSP spVoucherType = new VoucherTypeSP();
var isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(typeId);
string voucherNo = Convert.ToString(itemFirst[0]["voucherNo"].Value <string>());
if (isEditMode == false)
{
if (PublicVariables.isMessageAdd)
{
if (!isAutomatic)
{
if (spMaster.MonthlySalaryVoucherCheckExistence(voucherNo, typeId, masterID) == false)
{
SaveFunction_MSV(tableData, editMode);
}
}
else
{
SaveFunction_MSV(tableData, editMode);
}
}
else
{
if (!isAutomatic)
{
if (spMaster.MonthlySalaryVoucherCheckExistence(voucherNo, typeId, masterID) == false)
{
SaveFunction_MSV(tableData, editMode);
}
}
else
{
SaveFunction_MSV(tableData, editMode);
}
}
}
//------ Update-------------//
else if (isEditMode)
{
if (PublicVariables.isMessageEdit)
{
if (!isAutomatic)
{
if (spMaster.MonthlySalaryVoucherCheckExistence(voucherNo, typeId, masterID) == false)
{
EditFunction_MSV(masterId, tableData, editMode);
}
}
else
{
EditFunction_MSV(masterId, tableData, editMode);
}
}
else
{
if (!isAutomatic)
{
if (spMaster.MonthlySalaryVoucherCheckExistence(voucherNo, typeId, masterID) == false)
{
EditFunction_MSV(masterId, tableData, editMode);
}
}
else
{
EditFunction_MSV(masterId, tableData, editMode);
}
}
}
return(Json(new { error = "success" }));
}
catch (Exception ex)
{
// MessageBox.Show("MSV6:" + ex.Message, "Masterfine", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(Json(new { error = "error" }));
}
public ActionResult FillFunction(string id)
{
try
{
DataTable dtbl = new DataTable();
SalaryVoucherMasterSP SpMaster = new SalaryVoucherMasterSP();
SalaryVoucherMasterInfo InfoMaster = new SalaryVoucherMasterInfo();
VoucherTypeSP spVoucherType = new VoucherTypeSP();
decimal masterId = Convert.ToDecimal(id);
InfoMaster = SpMaster.SalaryVoucherMasterView(masterId);
var strVoucherNoforEdit = InfoMaster.VoucherNo;
var strVoucherNo = InfoMaster.VoucherNo;
var strInvoiceNo = InfoMaster.InvoiceNo;
var txtVoucherDate = InfoMaster.Date.ToString("yyyy-MM-dd");
var dtpMonth = Convert.ToDateTime(InfoMaster.Month.ToString("yyyy-MM"));
var txtNarration = InfoMaster.Narration;
string txtMonth = InfoMaster.Month.ToString("yyyy-MM");
decimal decTotalAmont = Math.Round(Convert.ToDecimal(InfoMaster.TotalAmount.ToString()), PublicVariables._inNoOfDecimalPlaces);
var lblTotalAmount = decTotalAmont.ToString();
var decMonthlySuffixPrefixId = InfoMaster.SuffixPrefixId;
var decMonthlyVoucherTypeId = InfoMaster.VoucherTypeId;
ViewData["decMonthlyVoucherTypeId"] = decMonthlyVoucherTypeId;
ViewData["decMonthlySuffixPrefixId"] = decMonthlySuffixPrefixId;
var cmbCashOrBankAcc = InfoMaster.LedgerId;
var isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(decMonthlyVoucherTypeId);
bool txtInVoiceNoEnabled = false;
if (isAutomatic)
{
txtInVoiceNoEnabled = false;
}
else
{
txtInVoiceNoEnabled = true;
}
bool dtpMonthEnabled = false;
dtbl = GridFillVoucher(true, dtpMonth, strVoucherNo);
string jsonResult = Utils.ConvertDataTabletoString(dtbl);
return(Json(new
{
error = "false",
data = jsonResult,
voucherNo = strVoucherNo,
strInvoiceNo,
voucherDate = txtVoucherDate,
month = txtMonth,
cash = cmbCashOrBankAcc,
totalAmount = lblTotalAmount,
narration = txtNarration,
txtInVoiceNoEnabled,
dtpMonthEnabled,
masterID = masterId
}));
}
catch (Exception ex)
{
}
return(Json(new{ error = "true" }));
}
/// <summary>
/// On print button click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
frmReport crptReport = new frmReport();
DataSet ds = new DataSet();
DataTable dtblFormat2 = new DataTable();
DataTable dtblTotal = new DataTable();
CompanySP spCompany = new CompanySP();
DataTable dtblCompany = new DataTable();
dtblCompany = spCompany.CompanyViewAll();
if (dgvVatreturn.Rows.Count > 0)
{
if (dtblFill.Rows.Count > 0)
{
DataTable dtblReportFill = new DataTable();
dtblReportFill.Columns.Add("SlNO");
dtblReportFill.Columns.Add("Invoice No");
dtblReportFill.Columns.Add("Date");
dtblReportFill.Columns.Add("Party Name");
dtblReportFill.Columns.Add("Mailing Name");
dtblReportFill.Columns.Add("Tin No");
dtblReportFill.Columns.Add("qt");
dtblReportFill.Columns.Add("Sales Amound");
dtblReportFill.Columns.Add("Tax Amount");
dtblReportFill.Columns.Add("Cess");
dtblReportFill.Columns.Add("Net Amount");
dtblReportFill.Columns.Add("billDiscount");
dtblReportFill.Columns.Add("grandtotal");
for (int i = 0; i < dgvVatreturn.Rows.Count; i++)
{
DataRow drow = dtblReportFill.NewRow();
if (dgvVatreturn.Rows[i].Cells["dgvtxtSlno"].Value != null)
{
drow["SlNO"] = dgvVatreturn.Rows[i].Cells["dgvtxtSlno"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtInvoiceNo"].Value != null)
{
drow["Invoice No"] = dgvVatreturn.Rows[i].Cells["dgvtxtInvoiceNo"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtDate"].Value != null)
{
drow["Date"] = dgvVatreturn.Rows[i].Cells["dgvtxtDate"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtPartyName"].Value != null)
{
drow["Party Name"] = dgvVatreturn.Rows[i].Cells["dgvtxtPartyName"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtMailingName"].Value.ToString() != string.Empty)
{
drow["Mailing Name"] = dgvVatreturn.Rows[i].Cells["dgvtxtMailingName"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtTinNo"].Value != null)
{
drow["Tin No"] = dgvVatreturn.Rows[i].Cells["dgvtxtTinNo"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtQty"].Value != null)
{
drow["qt"] = dgvVatreturn.Rows[i].Cells["dgvtxtQty"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtSalesAmount"].Value != null)
{
drow["Sales Amound"] = dgvVatreturn.Rows[i].Cells["dgvtxtSalesAmount"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtTaxAmount"].Value != null)
{
drow["Tax Amount"] = dgvVatreturn.Rows[i].Cells["dgvtxtTaxAmount"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtCess"].Value != null)
{
drow["Cess"] = dgvVatreturn.Rows[i].Cells["dgvtxtCess"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtNetAmount"].Value != null)
{
drow["Net Amount"] = dgvVatreturn.Rows[i].Cells["dgvtxtNetAmount"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtbillDiscount"].Value != null)
{
drow["billDiscount"] = dgvVatreturn.Rows[i].Cells["dgvtxtbillDiscount"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtGrandTotal"].Value != null)
{
drow["grandtotal"] = dgvVatreturn.Rows[i].Cells["dgvtxtGrandTotal"].Value.ToString();
}
dtblReportFill.Rows.Add(drow);
}
ds.Tables.Add(dtblReportFill);
ds.Tables.Add(dtblCompany);
crptReport.vatreturnReport(ds);
}
else
{
VoucherTypeSP spVoucher = new VoucherTypeSP();
dtblFormat2 = spVoucher.VatGridFill(DateTime.Parse(dtpFrmDate.Text), DateTime.Parse(dtpToDate.Text), cmbTypeofVoucher.Text, Convert.ToDecimal(cmbVouchertype.SelectedValue.ToString()), strformat, cmbTax.Text);
if (dgvVatreturn.Rows.Count > 1)
{
dtblTotal.Columns.Add("taxableamt");
dtblTotal.Columns.Add("taxAmount");
DataRow dr1 = dtblTotal.NewRow();
dr1["taxableamt"] = dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 2].Cells["dgvtxtTaxableAmount"].Value.ToString();
dr1["taxAmount"] = dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 2].Cells["dgvtxttax"].Value.ToString();
dtblTotal.Rows.Add(dr1);
ds.Tables.Add(dtblCompany);
ds.Tables.Add(dtblFormat2);
ds.Tables.Add(dtblTotal);
crptReport.vatreturnReportFormat(ds);
}
}
}
else
{
MessageBox.Show("No data found", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("VRR:14" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the grid
/// </summary>
public void GridFill()
{
try
{
dgvVatreturn.Rows.Clear();
DataTable dt = new DataTable();
string strVoucherTypeName = string.Empty;
decimal decVoucherTypeId;
if (rbtnFormat1.Checked)
{
strformat = "type1";
}
else
{
strformat = "type2";
}
if (cmbVouchertype.Enabled)
{
decVoucherTypeId = Convert.ToDecimal(cmbVouchertype.SelectedValue.ToString());
}
else
{
decVoucherTypeId = 0;
}
strVoucherTypeName = Convert.ToString(cmbTypeofVoucher.Text);
VoucherTypeSP spVoucher = new VoucherTypeSP();
dt = spVoucher.VatGridFill(Convert.ToDateTime(dtpFrmDate.Text), Convert.ToDateTime(dtpToDate.Text), strVoucherTypeName, decVoucherTypeId, strformat, cmbTax.Text);
dtblFill = dt;
DataTable dtblTaxName = new DataTable();
dtblTaxName = spVoucher.VatViewTaxNames();
if (rbtnFormat1.Checked)
{
dgvVatreturn.Columns["dgvtxtTaxName"].Visible = false;
dgvVatreturn.Columns["dgvtxtTaxableAmount"].Visible = false;
dgvVatreturn.Columns["dgvtxttax"].Visible = false;
dgvVatreturn.Columns["dgvtxtQty"].Visible = true;
dgvVatreturn.Columns["dgvtxtSalesAmount"].Visible = true;
dgvVatreturn.Columns["dgvtxtTaxAmount"].Visible = true;
dgvVatreturn.Columns["dgvtxtNetAmount"].Visible = true;
dgvVatreturn.Columns["dgvtxtbillDiscount"].Visible = true;
foreach (DataRow drowDetails in dt.Rows)
{
dgvVatreturn.Rows.Add();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtInvoiceNo"].Value = drowDetails["Invoice No"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtDate"].Value = drowDetails["Date"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtPartyName"].Value = drowDetails["Party Name"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtMailingName"].Value = drowDetails["Mailing Name"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtsalesmasterid"].Value = drowDetails["SalesMasterId"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtvoucherName"].Value = drowDetails["voucherName"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtVoucherType"].Value = drowDetails["voucherType"].ToString();
decimal dSaleId = Convert.ToDecimal(dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtsalesmasterid"].Value.ToString());
string strVoucherType = Convert.ToString(dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtVoucherType"].Value);
string qt = spVoucher.VoucherreportsumQty(dSaleId, strVoucherType);
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTinNo"].Value = drowDetails["Tin No"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtQty"].Value = qt;
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtSalesAmount"].Value = drowDetails["Sales Amound"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTaxAmount"].Value = Math.Round(Convert.ToDecimal(drowDetails["Tax Amount"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtCess"].Value = drowDetails["Cess"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtNetAmount"].Value = Math.Round(Convert.ToDecimal(drowDetails["Net Amount"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtbillDiscount"].Value = Math.Round(Convert.ToDecimal(drowDetails["billDiscount"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtGrandTotal"].Value = Math.Round(Convert.ToDecimal(drowDetails["grandtotal"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();;
}
if (dgvVatreturn.Rows.Count > 0)
{
SerialNo();
}
}
else
{
dgvVatreturn.Rows.Clear();
dgvVatreturn.Columns["dgvtxtTaxName"].Visible = true;
dgvVatreturn.Columns["dgvtxtTaxableAmount"].Visible = true;
dgvVatreturn.Columns["dgvtxttax"].Visible = true;
dgvVatreturn.Columns["dgvtxtQty"].Visible = false;
dgvVatreturn.Columns["dgvtxtSalesAmount"].Visible = false;
dgvVatreturn.Columns["dgvtxtTaxAmount"].Visible = false;
dgvVatreturn.Columns["dgvtxtNetAmount"].Visible = false;
dgvVatreturn.Columns["dgvtxtbillDiscount"].Visible = false;
foreach (DataRow drowDetails in dt.Rows)
{
dgvVatreturn.Rows.Add();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtInvoiceNo"].Value = drowDetails["Invoice No"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtDate"].Value = drowDetails["Date"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtPartyName"].Value = drowDetails["Party Name"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtMailingName"].Value = drowDetails["Mailing Name"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtsalesmasterid"].Value = drowDetails["SalesMasterId"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTinNo"].Value = drowDetails["Tin No"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtGrandTotal"].Value = drowDetails["grandtotal"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTaxName"].Value = drowDetails["taxName"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTaxableAmount"].Value = drowDetails["rate"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxttax"].Value = drowDetails["taxamount"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtvoucherName"].Value = drowDetails["voucherName"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtVoucherType"].Value = drowDetails["voucherType"].ToString();
}
if (dgvVatreturn.Rows.Count > 0)
{
SerialNo();
dgvVatreturn.Rows.Add();
CalculateTotal();
}
dtblFill.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("VRR:06" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public string SaveDailySalaryVoucher(string dailyMasterId, string voucherTypeId, string voucherNo, string date,
string salaryDate, string cash, string narration, string totalAmount, string details)
{
string message = string.Empty;
try
{
decimal decDailyVoucherTypeId = 0;
VoucherTypeSP spVoucherType = new VoucherTypeSP();
DataTable dtblVouchetType = new DataTable();
dtblVouchetType = spVoucherType.VoucherTypeSelectionComboFill("Daily Salary Voucher");
int nCount = dtblVouchetType.Rows.Count;
string voucherType = string.Empty;
if (nCount == 1)
{
voucherType = dtblVouchetType.Rows[0].ItemArray[0].ToString();
decDailyVoucherTypeId = decimal.Parse(voucherType);
}
string strEployeeNames = string.Empty;
DailySalaryVoucherMasterInfo infoMaster = new DailySalaryVoucherMasterInfo();
DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP();
DailySalaryVoucherDetailsInfo infoDetails = new DailySalaryVoucherDetailsInfo();
DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP();
//-------------In multi user case check whether salary is paying for the same persone--------------//
List <Dictionary <string, object> > detailsData = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(details);
int inCounts = detailsData.Count;
int incont = 0;
decimal decVal = 0;
DateTime dtSalaryDate = Convert.ToDateTime(salaryDate);
for (int i = 0; i < inCounts; i++)
{
decVal = Convert.ToDecimal(detailsData[i]["employeeId"].ToString());
if (spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtSalaryDate) != "0")
{
strEployeeNames = strEployeeNames + spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtSalaryDate) + ",";
foreach (char ch in strEployeeNames)
{
if (ch == ',')
{
incont++;
}
}
if (incont == 15)
{
incont = 0;
strEployeeNames = strEployeeNames + Environment.NewLine;
}
}
}
if (spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtSalaryDate) != "0")
{
message = "Salary already paid for - " + " " + strEployeeNames;
}
else
{
DateTime dtDate = Convert.ToDateTime(date);
if (isAutomatic)
{
infoMaster.VoucherNo = strVoucherNo;
}
else
{
infoMaster.VoucherNo = voucherNo;
}
infoMaster.Date = dtDate;
infoMaster.SalaryDate = dtSalaryDate;
infoMaster.LedgerId = Convert.ToDecimal(cash);
infoMaster.Narration = narration ?? string.Empty;
infoMaster.TotalAmount = Convert.ToDecimal(totalAmount);
infoMaster.Extra1 = string.Empty; // Fields not in design//
infoMaster.Extra2 = string.Empty; // Fields not in design//
if (isAutomatic)
{
infoMaster.InvoiceNo = strInvoiceNo;
}
else
{
infoMaster.InvoiceNo = voucherNo;
}
infoMaster.SuffixPrefixId = 0;//decDailySuffixPrefixId;
infoMaster.VoucherTypeId = decDailyVoucherTypeId;
infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
int inval = 0;
int inCount = detailsData.Count;
for (int i = 0; i < inCount; i++)
{
if (detailsData[i]["status"].ToString() == "paid")
{
inval++;
}
}
if (inval >= 0)
{
decimal decMasterId = 0;
string strUpdatedVoucherNo = string.Empty;
string strUpdatedInvoiceNo = string.Empty;
//-------------checks Voucher No. repeating in Multi user case----------//
DataTable dtbl = new DataTable();
dtbl = spMaster.DailySalaryVoucherMasterAddWithIdentity(infoMaster, true);
foreach (DataRow dr in dtbl.Rows)
{
decMasterId = Convert.ToDecimal(dr.ItemArray[0].ToString());
strUpdatedVoucherNo = dr.ItemArray[1].ToString();
strUpdatedInvoiceNo = dr.ItemArray[2].ToString();
}
if (!isAutomatic)
{
strVoucherNo = voucherNo;
}
if (isAutomatic)
{
if (Convert.ToDecimal(strUpdatedVoucherNo) != Convert.ToDecimal(strVoucherNo))
{
message = "Voucher number changed from " + strInvoiceNo + " to " + strUpdatedInvoiceNo;
strVoucherNo = strUpdatedVoucherNo.ToString();
strInvoiceNo = strUpdatedInvoiceNo;
}
}
//-------------------------------------//
LedgerPostingForDailySalary(Convert.ToDecimal(cash), totalAmount, decDailyVoucherTypeId, voucherNo, date);
infoDetails.DailySalaryVocherMasterId = decMasterId;
infoDetails.Extra1 = string.Empty; // Fields not in design//
infoDetails.Extra2 = string.Empty; // Fields not in design//
int inRowCount = detailsData.Count;
for (int i = 0; i < inRowCount; i++)
{
if (detailsData[i]["employeeId"].GetType().Name != "JObject" && detailsData[i]["employeeId"].ToString() != string.Empty)
{
infoDetails.EmployeeId = Convert.ToDecimal(detailsData[i]["employeeId"].ToString());
}
if (detailsData[i]["dailyWage"].GetType().Name != "JObject" && detailsData[i]["dailyWage"].ToString() != string.Empty)
{
infoDetails.Wage = Convert.ToDecimal(detailsData[i]["dailyWage"].ToString());
}
if (detailsData[i]["status"].GetType().Name != "JObject" && detailsData[i]["status"].ToString() == "paid")
{
infoDetails.Status = detailsData[i]["status"].ToString();
}
if (detailsData[i]["status"].ToString() == "paid" && detailsData[i]["masterId"].ToString() == string.Empty)
{
infoDetails.DailySalaryVocherMasterId = decMasterId;
spDetails.DailySalaryVoucherDetailsAdd(infoDetails);
}
}
}
else
{
strVoucherNo = spMaster.DailySalaryVoucherMasterGetMax(Convert.ToDecimal(decDailyVoucherTypeId));
message = "Can't save without at least one employee";
}
}
}
catch (Exception ex)
{
message = "DSV11:" + ex.Message;
}
return(message);
}
