protected void btnMoney_Click(object sender, EventArgs e)
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = doubleEntry.Count;
aCC_Journal.HeadID = int.Parse(hfHeadIDMoney.Value);
aCC_Journal.HeadName = lblHeadNameMoney.Text;
aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmountMoney.Text : "0");
aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmountMoney.Text : "0");
aCC_Journal.JournalMasterID = int.Parse("1");
aCC_Journal.JournalVoucherNo = "";
aCC_Journal.UserID = ddlAccountingUserMoney.SelectedValue;
aCC_Journal.AccountID = int.Parse(ddlAccountForMoney.SelectedValue);
aCC_Journal.UserTypeID = int.Parse(ddlUserTypeIDMoney.SelectedValue);
aCC_Journal.AddedBy = Profile.card_id;
aCC_Journal.AddedDate = DateTime.Now;
aCC_Journal.UpdatedBy = Profile.card_id;
aCC_Journal.UpdateDate = DateTime.Now;
aCC_Journal.RowStatusID = 1;
doubleEntry.Add(aCC_Journal);
loadJournal();
loadSubmitButton();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ACC_Journal aCC_Journal = new ACC_Journal ();
aCC_Journal.JournalID= int.Parse(Request.QueryString["ID"].ToString());
aCC_Journal.HeadID= int.Parse(ddlHeadID.SelectedValue);
aCC_Journal.Debit= decimal.Parse(txtDebit.Text);
aCC_Journal.Credit= decimal.Parse(txtCredit.Text);
//aCC_Journal.VoucherID= int.Parse(ddlVoucherID.SelectedValue);
aCC_Journal.JournalVoucherNo= txtJournalVoucherNo.Text;
aCC_Journal.AddedBy= Profile.card_id;
aCC_Journal.AddedDate= DateTime.Now;
aCC_Journal.UpdatedBy= Profile.card_id;
aCC_Journal.UpdateDate= DateTime.Now;
aCC_Journal.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue);
bool resutl =ACC_JournalManager.UpdateACC_Journal(aCC_Journal);
Response.Redirect("AdminDisplayACC_Journal.aspx");
}
public bool ProcessACC_AdvanceSalaryFromCPF(string userID, ACC_Journal aCC_Jounal)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("ProcessACC_AdvanceSalaryFromCPF", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = userID;
cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = aCC_Jounal.Balance;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = aCC_Jounal.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = aCC_Jounal.AddedDate.AddHours(double.Parse(ConfigurationManager.AppSettings["ServerTimeDiff"].ToString()));
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_Jounal.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_Jounal.UpdateDate.AddHours(double.Parse(ConfigurationManager.AppSettings["ServerTimeDiff"].ToString()));
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
protected void btnAddInstallment_Click(object sender, EventArgs e)
{
try
{
ACC_Journal pfACC_Journal = new ACC_Journal();
pfACC_Journal.UserID = hfStudentID.Value;
pfACC_Journal.Balance = Convert.ToDecimal(txtJournalHistoryAmount.Text);
pfACC_Journal.AddedBy = Profile.card_id;
pfACC_Journal.AddedDate = DateTime.Parse(txtJournalHistoryDate.Text);
pfACC_Journal.UpdatedBy = Profile.card_id;
pfACC_Journal.UpdateDate = DateTime.Now;
pfACC_Journal.EmployPayRoleSalaryID = 0;
ACC_AccountingCommonManager.ProcessACC_JournalHistory(hfStudentID.Value, pfACC_Journal);
showPaymentHistory();
}
catch (Exception ex)
{ }
}
private void processRefundCPF(decimal amount)
{
try
{
ACC_Journal RefundCPFACC_Journal = new ACC_Journal();
RefundCPFACC_Journal.UserID = Request.QueryString["ID"];
RefundCPFACC_Journal.Balance = amount;
RefundCPFACC_Journal.AddedBy = Profile.card_id;
RefundCPFACC_Journal.AddedDate = DateTime.Now;
RefundCPFACC_Journal.UpdatedBy = Profile.card_id;
RefundCPFACC_Journal.UpdateDate = DateTime.Now;
ACC_AccountingCommonManager.ProcessACC_RefundCPF(Request.QueryString["ID"], RefundCPFACC_Journal);
}
catch (Exception ex)
{ }
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtStudentCode.Visible != false)
{
if (IsUser(txtStudentCode.Text))
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = doubleEntry.Count;
aCC_Journal.HeadID = int.Parse(hfHeadID.Value);
aCC_Journal.HeadName = lblHeadName.Text;
aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmount.Text : "0");
aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmount.Text : "0");
aCC_Journal.JournalMasterID = int.Parse("1");
aCC_Journal.JournalVoucherNo = "";
aCC_Journal.UserID = hfStudentID.Value;
aCC_Journal.AccountID = int.Parse(ddlAccountID.SelectedValue);
aCC_Journal.UserTypeID = int.Parse(ddlUserTypeID.SelectedValue);
aCC_Journal.AddedBy = Profile.card_id;
aCC_Journal.AddedDate = DateTime.Now;
aCC_Journal.UpdatedBy = Profile.card_id;
aCC_Journal.UpdateDate = DateTime.Now;
aCC_Journal.RowStatusID = 1;
doubleEntry.Add(aCC_Journal);
loadJournal();
loadSubmitButton();
lblUser.Text = "";
}
else
{
lblUser.Text = "User is not exist";
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('User is not exist')", true);
}
}
else
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = doubleEntry.Count;
aCC_Journal.HeadID = int.Parse(hfHeadID.Value);
aCC_Journal.HeadName = lblHeadName.Text;
aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmount.Text : "0");
aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmount.Text : "0");
aCC_Journal.JournalMasterID = int.Parse("1");
aCC_Journal.JournalVoucherNo = "";
aCC_Journal.UserID = ddlAccountingUser.SelectedValue;
aCC_Journal.AccountID = int.Parse(ddlAccountID.SelectedValue);
aCC_Journal.UserTypeID = int.Parse(ddlUserTypeID.SelectedValue);
aCC_Journal.AddedBy = Profile.card_id;
aCC_Journal.AddedDate = DateTime.Now;
aCC_Journal.UpdatedBy = Profile.card_id;
aCC_Journal.UpdateDate = DateTime.Now;
aCC_Journal.RowStatusID = 1;
doubleEntry.Add(aCC_Journal);
loadJournal();
loadSubmitButton();
}
}
catch (Exception ex)
{
}
}
private void processEPF(decimal amount, int journalMasterID)
{
try
{
ACC_Journal advSalaryACC_Journal = new ACC_Journal();
advSalaryACC_Journal.UserID = Request.QueryString["ID"];
advSalaryACC_Journal.JournalMasterID = journalMasterID;
advSalaryACC_Journal.Balance = amount;
advSalaryACC_Journal.AddedBy = Profile.card_id;
advSalaryACC_Journal.AddedDate = DateTime.Now;
advSalaryACC_Journal.UpdatedBy = Profile.card_id;
advSalaryACC_Journal.UpdateDate = DateTime.Now;
ACC_AccountingCommonManager.ProcessACC_EPF(Request.QueryString["ID"], advSalaryACC_Journal);
}
catch (Exception ex)
{ }
}
private void processFullTimeSalary(decimal amount,int journalMasterID)
{
try
{
ACC_Journal advSalaryACC_Journal = new ACC_Journal();
advSalaryACC_Journal.UserID = Request.QueryString["ID"];
advSalaryACC_Journal.JournalMasterID = journalMasterID;
advSalaryACC_Journal.Balance = amount;
advSalaryACC_Journal.AddedBy = Profile.card_id;
advSalaryACC_Journal.AddedDate = DateTime.Now;
advSalaryACC_Journal.UpdatedBy = Profile.card_id;
advSalaryACC_Journal.UpdateDate = DateTime.Now;
advSalaryACC_Journal.SalaryOfDate = DateTime.Parse(txtResignDate.Text).ToString("MMMM, yyyy");
ACC_AccountingCommonManager.ProcessACC_FullTimeSalary(Request.QueryString["ID"], advSalaryACC_Journal);
}
catch (Exception ex)
{ }
}
private void showACC_JournalData()
{
ACC_Journal aCC_Journal = new ACC_Journal ();
aCC_Journal = ACC_JournalManager.GetACC_JournalByJournalID(Int32.Parse(Request.QueryString["ID"]));
ddlHeadID.SelectedValue =aCC_Journal.HeadID.ToString();
txtDebit.Text =aCC_Journal.Debit.ToString();
txtCredit.Text =aCC_Journal.Credit.ToString();
ddlVoucherID.SelectedValue =aCC_Journal.JournalMasterID.ToString();
txtJournalVoucherNo.Text =aCC_Journal.JournalVoucherNo.ToString();
ddlRowStatusID.SelectedValue =aCC_Journal.RowStatusID.ToString();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (decimal.Parse(hfHeadIDMoney.Value) == 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Please select the Account for Money entry.')", true);
return;
}
try
{
List<ACC_Journal> doubleEntry = new List<ACC_Journal>();
if (Session["doubleEntry"] != null)
{
doubleEntry = (List<ACC_Journal>)Session["doubleEntry"];
}
int journalID = 0;
journalID = doubleEntry.Count;
List<ACC_CUCCheck> aCC_CUCCheckList = new List<ACC_CUCCheck>();
if (Session["cucCheck"] != null)
{
aCC_CUCCheckList = (List<ACC_CUCCheck>)Session["cucCheck"];
}
if (ddlAccountForMoney.SelectedValue == "2")
{
ACC_CUCCheck aCC_CUCCheck = new ACC_CUCCheck();
// aCC_CUCCheck.CUCCheckID= int.Parse(ddlCUCCheckID.SelectedValue);
aCC_CUCCheck.CUCCheckName = lblHeadNameMoney.Text;
aCC_CUCCheck.CUCCheckNo = txtCUCCheckNo.Text;
aCC_CUCCheck.BankAccountID = int.Parse(ddlBank.SelectedValue);
aCC_CUCCheck.CheckDate = DateTime.Parse(txtCUCCheckDate.Text);
aCC_CUCCheck.PaytoHeadID = int.Parse(hfHeadIDMoney.Value);
aCC_CUCCheck.JournalID = journalID;
aCC_CUCCheck.Amount = decimal.Parse(txtAmountToPay.Text);
aCC_CUCCheck.ExtraField1 = "";
aCC_CUCCheck.ExtraField2 = "";
aCC_CUCCheck.ExtraField3 = "";
aCC_CUCCheck.ExtraField4 = "";
aCC_CUCCheck.ExtraField5 = "";
aCC_CUCCheck.AddedBy = Profile.card_id;
aCC_CUCCheck.AddedDate = DateTime.Now;
aCC_CUCCheck.UpdatedBy = Profile.card_id;
aCC_CUCCheck.UpdatedDate = DateTime.Now;
aCC_CUCCheck.RowStatusID = 1;//Temporary Inserted In DB
//hfCUCCheck.Value = ACC_CUCCheckManager.InsertACC_CUCCheck(aCC_CUCCheck).ToString();
aCC_CUCCheckList.Add(aCC_CUCCheck);
Session["cucCheck"] = aCC_CUCCheckList;
}
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = doubleEntry.Count;
aCC_Journal.HeadID = int.Parse(hfHeadIDMoney.Value);
aCC_Journal.HeadName = lblHeadNameMoney.Text;
aCC_Journal.Debit = 0;
aCC_Journal.Credit = decimal.Parse(txtAmountToPay.Text);
aCC_Journal.JournalMasterID = int.Parse("1");
aCC_Journal.JournalVoucherNo = "";//temporay we are using to manage the check #
aCC_Journal.UserID = hfUserID.Value;
aCC_Journal.AccountID = int.Parse(ddlAccountForMoney.SelectedValue);
aCC_Journal.UserTypeID = int.Parse(hfUserTypeID.Value);
aCC_Journal.AddedBy = Profile.card_id;
aCC_Journal.AddedDate = DateTime.Now;
aCC_Journal.UpdatedBy = Profile.card_id;
aCC_Journal.UpdateDate = DateTime.Now;
aCC_Journal.RowStatusID = 1;
aCC_Journal.IsNotCheck = ddlAccountForMoney.SelectedValue == "42" ? false : true;
doubleEntry.Add(aCC_Journal);
Session["doubleEntry"] = doubleEntry;
btnSave.Visible = false;
lblPaidAmount.Text = (decimal.Parse(lblPaidAmount.Text) + decimal.Parse(txtAmountToPay.Text)).ToString("00");
txtAmountToPay.Text = "0";
loadJournal();
loadSubmitButton();
}
catch (Exception ex)
{
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
List<ACC_Journal> doubleEntry = new List<ACC_Journal>();
if (Session["doubleEntry"] != null)
{
doubleEntry = (List<ACC_Journal>)Session["doubleEntry"];
}
if (txtStudentCode.Visible != false)
{
if (IsUser(txtStudentCode.Text))
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = doubleEntry.Count;
aCC_Journal.HeadID = int.Parse(hfHeadID.Value);
aCC_Journal.HeadName = lblHeadName.Text;
aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmount.Text : "0");
aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmount.Text : "0");
aCC_Journal.JournalMasterID = int.Parse("1");
aCC_Journal.JournalVoucherNo = "";
aCC_Journal.SubBasicAccountID = int.Parse(Request.QueryString["SubBasicAccountID"] == null ? ddlSubBasicAccountID.SelectedValue : Request.QueryString["SubBasicAccountID"]);
aCC_Journal.UserID = hfStudentID.Value;
aCC_Journal.AccountID = int.Parse(ddlAccountID.SelectedValue);
aCC_Journal.UserTypeID = int.Parse(ddlUserTypeID.SelectedValue);
aCC_Journal.AddedBy = Profile.card_id;
aCC_Journal.AddedDate = DateTime.Now;
aCC_Journal.UpdatedBy = Profile.card_id;
aCC_Journal.UpdateDate = DateTime.Now;
aCC_Journal.RowStatusID = 1;
aCC_Journal.IsNotCheck = true;
doubleEntry.Add(aCC_Journal);
Session["doubleEntry"] = doubleEntry;
loadJournal();
loadSubmitButton();
lblUser.Text = "";
}
else
{
lblUser.Text = "User is not exist";
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('User is not exist')", true);
}
}
else
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = doubleEntry.Count;
aCC_Journal.HeadID = int.Parse(hfHeadID.Value);
aCC_Journal.HeadName = lblHeadName.Text;
aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmount.Text : "0");
aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmount.Text : "0");
aCC_Journal.JournalMasterID = int.Parse("1");
aCC_Journal.JournalVoucherNo = "";
aCC_Journal.UserID = ddlAccountingUser.SelectedValue;
aCC_Journal.AccountID = int.Parse(ddlAccountID.SelectedValue);
aCC_Journal.UserTypeID = int.Parse(ddlUserTypeID.SelectedValue);
aCC_Journal.AddedBy = Profile.card_id;
aCC_Journal.AddedDate = DateTime.Now;
aCC_Journal.UpdatedBy = Profile.card_id;
aCC_Journal.UpdateDate = DateTime.Now;
aCC_Journal.RowStatusID = 1;
aCC_Journal.IsNotCheck = true;
aCC_Journal.SubBasicAccountID = 0;
doubleEntry.Add(aCC_Journal);
Session["doubleEntry"] = doubleEntry;
loadJournal();
loadSubmitButton();
}
//load the Check from
hfCheckFrom.Value += hfHeadID.Value + "," + lblHeadName.Text + ";";
ListItem litems = new ListItem(lblHeadName.Text, hfHeadID.Value);
ddlCheckFrom.Items.Add(litems);
ddlCheckFrom.DataBind();
ClearAllControllJournalEntry();
}
catch (Exception ex)
{
}
}
public static bool ProcessACC_RefundCPF(string userID, ACC_Journal aCC_Jounal)
{
SqlACC_AccountingCommonProvider sqlACC_AccountingCommonProvider = new SqlACC_AccountingCommonProvider();
return sqlACC_AccountingCommonProvider.ProcessACC_RefundCPF(userID, aCC_Jounal);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["sP"] = null;
Session["sumdebit"] = null;
lblPayTo.Text = "...............................................................................";
lblPurpose.Text = ".................................................................. A/C";
if (Request.QueryString["Payto"] != null)
{
lblPayTo.Text = " : " + Request.QueryString["Payto"];
}
if (Request.QueryString["Purpose"] != null)
{
lblPurpose.Text = " : " + Request.QueryString["Purpose"];
}
if (Request.QueryString["JournalMasterID"] != null)
{
int i = 0;
//lblDate.Text = DateTime.Now.ToShortDateString();
lblVoucherNo.Text = Request.QueryString["JournalMasterID"];
List<ACC_Journal> voucher = new List<ACC_Journal>();
int id = Convert.ToInt32(Request.QueryString["JournalMasterID"]);
DataSet journals = ACC_JournalManager.GetACC_VoucherByJournalMasterID(id);
foreach (DataRow dr in journals.Tables[0].Rows)
{
ACC_Journal journal = new ACC_Journal();
if (dr["BasicAccountID"].ToString() == "1")
{
i = 1;
break;
}
}
if (i == 1)
{
bool IsAllAsset = true;
foreach (DataRow dr in journals.Tables[0].Rows)
{
ACC_Journal journal = new ACC_Journal();
if (dr["BasicAccountID"].ToString() != "1")
{
if (dr["Credit"].ToString() != "0.00")
{
lblVoucherName.Text = "Credit";
lblVoucher.Text = "Credit";
}
else
{
lblVoucherName.Text = "Debit";
lblVoucher.Text = "Debit";
}
lblDate.Text = DateTime.Parse(dr["UpdateDate"].ToString()).ToString("dd MMM yyyy");
journal.HeadName = dr["HeadName"].ToString();
journal.Debit = Convert.ToDecimal(dr["Debit"].ToString()) + Convert.ToDecimal(dr["Credit"].ToString());
voucher.Add(journal);
IsAllAsset = false;
}
}
if (IsAllAsset)
{
foreach (DataRow dr in journals.Tables[0].Rows)
{
ACC_Journal journal = new ACC_Journal();
if (Convert.ToDecimal(dr["Credit"].ToString()) != decimal.Parse("0"))
{
lblVoucherName.Text = "Transaction";
lblVoucher.Text = "Transaction";
journal.HeadName = dr["HeadName"].ToString();
journal.Debit = Convert.ToDecimal(dr["Credit"].ToString());
voucher.Add(journal);
}
}
}
if (voucher.Count > 0)
{
gvACC_Journal.DataSource = voucher;
gvACC_Journal.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Voucher is not avaiable')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Voucher is not avaiable')", true);
}
}
}
}
private void loadMaserterID()
{
if(Request.QueryString["JournalMasterID"]!=null)
{
List<ACC_Journal> doubleEntry = new List<ACC_Journal>();
Session.Remove("doubleEntry");
DataSet ds= ACC_JournalManager.GetACC_JournalsByJournalMasterID(int.Parse(Request.QueryString["JournalMasterID"]));
decimal balance = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = int.Parse(dr["JournalID"].ToString());
aCC_Journal.HeadID = int.Parse(dr["HeadID"].ToString());
aCC_Journal.HeadName = dr["HeadName"].ToString();
aCC_Journal.Debit = decimal.Parse(dr["Debit"].ToString());
aCC_Journal.Credit = decimal.Parse(dr["Credit"].ToString());
aCC_Journal.JournalMasterID = int.Parse(dr["JournalMasterID"].ToString());
aCC_Journal.JournalVoucherNo = dr["JournalVoucherNo"].ToString();
aCC_Journal.UserID = dr["UserID"].ToString();
aCC_Journal.AccountID = int.Parse(dr["AccountID"].ToString());
aCC_Journal.UserTypeID = int.Parse(dr["UserTypeID"].ToString());
aCC_Journal.AddedBy = dr["AddedBy"].ToString();
aCC_Journal.AddedDate = DateTime.Parse(dr["AddedDate"].ToString());
aCC_Journal.UpdatedBy = dr["UpdatedBy"].ToString();
aCC_Journal.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString());
aCC_Journal.RowStatusID = int.Parse(dr["RowStatusID"].ToString());
aCC_Journal.IsNotCheck = true;
balance += aCC_Journal.Debit;
doubleEntry.Add(aCC_Journal);
txtDate.Text = aCC_Journal.UpdateDate.ToString("dd MMM yyyy");
hfDate.Value = aCC_Journal.UpdateDate.ToString("dd MMM yyyy");
}
lblTotalAmount.Text = balance.ToString("0,0.00");
Session["doubleEntry"] = doubleEntry;
gvACC_Journal.DataSource = doubleEntry;
gvACC_Journal.DataBind();
}
}
public bool UpdateACC_Journal(ACC_Journal aCC_Journal)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateACC_Journal", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@JournalID", SqlDbType.Int).Value = aCC_Journal.JournalID;
cmd.Parameters.Add("@HeadID", SqlDbType.Int).Value = aCC_Journal.HeadID;
cmd.Parameters.Add("@Debit", SqlDbType.Decimal).Value = aCC_Journal.Debit;
cmd.Parameters.Add("@Credit", SqlDbType.Decimal).Value = aCC_Journal.Credit;
cmd.Parameters.Add("@JournalMasterID", SqlDbType.Int).Value = aCC_Journal.JournalMasterID;
cmd.Parameters.Add("@JournalVoucherNo", SqlDbType.NVarChar).Value = aCC_Journal.JournalVoucherNo;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_Journal.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_Journal.UpdateDate.AddHours(double.Parse(ConfigurationManager.AppSettings["ServerTimeDiff"].ToString()));
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_Journal.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public ACC_Journal GetACC_JournalFromReader(IDataReader reader)
{
try
{
ACC_Journal aCC_Journal = new ACC_Journal
(
DataAccessObject.IsNULL<int>(reader["JournalID"]),
DataAccessObject.IsNULL<int>(reader["HeadID"]),
DataAccessObject.IsNULL<decimal>(reader["Debit"]),
DataAccessObject.IsNULL<decimal>(reader["Credit"]),
DataAccessObject.IsNULL<int>(reader["JournalMasterID"]),
DataAccessObject.IsNULL<string>(reader["JournalVoucherNo"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
aCC_Journal.HeadName = DataAccessObject.IsNULL<string>(reader["HeadName"].ToString());
return aCC_Journal;
}
catch(Exception ex)
{
return null;
}
}
public static bool ProcessACC_SecurityAmount(string userID, ACC_Journal aCC_Jounal)
{
SqlACC_AccountingCommonProvider sqlACC_AccountingCommonProvider = new SqlACC_AccountingCommonProvider();
return sqlACC_AccountingCommonProvider.ProcessACC_SecurityAmount(userID, aCC_Jounal);
}
private void showACC_VoucherEntry(int journalID)
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal = doubleEntry[journalID];
if (aCC_Journal.Debit == decimal.Parse("0") && Request.QueryString["DrOrCr"] == "Cr")
{
//Voucher
hfIsMoney.Value = "0";
lblHeadName.Text = aCC_Journal.HeadName.ToString();
txtAmount.Text = aCC_Journal.Credit.ToString();
ddlAccountID.SelectedValue = aCC_Journal.AccountID.ToString();
ddlUserTypeID.SelectedValue = aCC_Journal.UserTypeID.ToString();
ddlUserTypeID_SelectedIndexChanged(this, new EventArgs());
ddlAccountingUser.SelectedValue = aCC_Journal.UserID;
ddlAccountingUser_SelectedIndexChanged(this, new EventArgs());
hfHeadID.Value = aCC_Journal.HeadID.ToString();
hfJournalID.Value = journalID.ToString();
btnAdd.Visible = false;
btnUpdate.Visible = true;
}
else
{
//money
hfIsMoney.Value = "1";
lblHeadNameMoney.Text = aCC_Journal.HeadName.ToString();
txtAmountMoney.Text = aCC_Journal.Debit.ToString();
ddlAccountForMoney.SelectedValue = aCC_Journal.AccountID.ToString();
ddlUserTypeIDMoney.SelectedValue = aCC_Journal.UserTypeID.ToString();
ddlUserTypeIDMoney_SelectedIndexChanged(this, new EventArgs());
ddlAccountingUserMoney.SelectedValue = aCC_Journal.UserID;
ddlAccountingUserMoney_SelectedIndexChanged(this, new EventArgs());
hfHeadID.Value = aCC_Journal.HeadID.ToString();
hfJournalID.Value = journalID.ToString();
btnMoneyAdd.Visible = false;
btnMoneyUpdate.Visible = true;
}
}
protected void btnMoney_Click(object sender, EventArgs e)
{
if (ddlAccountForMoney.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Please select the Account for Money entry.')", true);
return;
}
try
{
List<ACC_Journal> doubleEntry = new List<ACC_Journal>();
if (Session["doubleEntry"] != null)
{
doubleEntry = (List<ACC_Journal>)Session["doubleEntry"];
}
int journalID = 0;
journalID = doubleEntry.Count;
List<ACC_Check> checks = new List<ACC_Check>();
if (Session["checks"] != null)
{
checks = (List<ACC_Check>)Session["checks"];
}
if (ddlAccountForMoney.SelectedValue == "42")
{
//If check info is given then we need to save that check
ACC_Check aCC_Check = new ACC_Check();
aCC_Check.CheckID = checks.Count;
aCC_Check.CheckNo = txtCheckNo.Text;
aCC_Check.BankAccountNo = txtAccountNo.Text;
aCC_Check.BankID = int.Parse(ddlBank.SelectedValue);
aCC_Check.BranchNOtherDetails = txtBranchInfo.Text;
aCC_Check.Remarks = txtAmountMoney.Text; ;
aCC_Check.IsCashCheck = chkCashCheck.Checked;
aCC_Check.ExtraField1 = !chkCashCheck.Checked ? ddlBankAccountID.SelectedValue : "";
aCC_Check.ExtraField2 = hfHeadIDMoney.Value;
aCC_Check.ExtraField3 = "";
aCC_Check.ExtraField4 = ddlCheckFrom.SelectedValue;
aCC_Check.ExtraField5 = txtCheckDate.Text;
aCC_Check.AddedBy = Profile.card_id;
aCC_Check.AddedDate = DateTime.Now;
aCC_Check.UpdatedBy = Profile.card_id;
aCC_Check.UpdateDate = DateTime.Now;
aCC_Check.RowStatusID = 1;//temporary we are using this to keep info about the
checks.Add(aCC_Check);
Session["checks"] = checks;
//hfcheckIDs.Value += ACC_CheckManager.InsertACC_Check(aCC_Check).ToString()+",";
}
List<ACC_CUCCheck> aCC_CUCCheckList = new List<ACC_CUCCheck>();
if (Session["cucCheck"] != null)
{
aCC_CUCCheckList = (List<ACC_CUCCheck>)Session["cucCheck"];
}
if (ddlAccountForMoney.SelectedValue == "2" )
{
ACC_CUCCheck aCC_CUCCheck = new ACC_CUCCheck();
// aCC_CUCCheck.CUCCheckID= int.Parse(ddlCUCCheckID.SelectedValue);
aCC_CUCCheck.CUCCheckName = ddlAccountingUserMoney.SelectedItem.Text;
aCC_CUCCheck.CUCCheckNo = ddlAccountingUserMoney.SelectedItem.Text;
aCC_CUCCheck.BankAccountID = int.Parse(ddlAccountingUserMoney.SelectedValue);
aCC_CUCCheck.CheckDate = DateTime.Parse(txtCUCCheckDate.Text);
aCC_CUCCheck.PaytoHeadID = int.Parse(hfHeadIDMoney.Value);
aCC_CUCCheck.JournalID = journalID;
aCC_CUCCheck.Amount = decimal.Parse(txtAmountMoney.Text);
aCC_CUCCheck.ExtraField1 = "";
aCC_CUCCheck.ExtraField2 = "";
aCC_CUCCheck.ExtraField3 = "";
aCC_CUCCheck.ExtraField4 = "";
aCC_CUCCheck.ExtraField5 = "";
aCC_CUCCheck.AddedBy = Profile.card_id;
aCC_CUCCheck.AddedDate = DateTime.Now;
aCC_CUCCheck.UpdatedBy = Profile.card_id;
aCC_CUCCheck.UpdatedDate = DateTime.Now;
aCC_CUCCheck.RowStatusID = 1;//Temporary Inserted In DB
//hfCUCCheck.Value = ACC_CUCCheckManager.InsertACC_CUCCheck(aCC_CUCCheck).ToString();
aCC_CUCCheckList.Add(aCC_CUCCheck);
Session["cucCheck"] = aCC_CUCCheckList;
}
if (txtStudentCodeMoney.Visible != false)
{
if (IsUser(txtStudentCodeMoney.Text))
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = doubleEntry.Count;
aCC_Journal.HeadID = int.Parse(hfHeadIDMoney.Value);
aCC_Journal.HeadName = lblHeadNameMoney.Text;
aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmountMoney.Text : "0");
aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmountMoney.Text : "0");
aCC_Journal.JournalMasterID = int.Parse("1");
aCC_Journal.JournalVoucherNo = ddlAccountForMoney.SelectedValue == "42" ? txtCheckNo.Text : "";
aCC_Journal.UserID = txtStudentCodeMoney.Text;
aCC_Journal.AccountID = int.Parse(ddlAccountForMoney.SelectedValue);
aCC_Journal.UserTypeID = int.Parse(ddlUserTypeIDMoney.SelectedValue);
aCC_Journal.AddedBy = Profile.card_id;
aCC_Journal.AddedDate = DateTime.Now;
aCC_Journal.UpdatedBy = Profile.card_id;
aCC_Journal.UpdateDate = DateTime.Now;
aCC_Journal.RowStatusID = 1;
aCC_Journal.IsNotCheck = ddlAccountForMoney.SelectedValue == "42" ? false : true;
doubleEntry.Add(aCC_Journal);
Session["doubleEntry"] = doubleEntry;
loadJournal();
loadSubmitButton();
}
else
{
lblUserMoney.Text = "User is not exist";
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('User is not exist')", true);
}
}
else
{
ACC_Journal aCC_Journal = new ACC_Journal();
aCC_Journal.JournalID = doubleEntry.Count;
aCC_Journal.HeadID = int.Parse(hfHeadIDMoney.Value);
aCC_Journal.HeadName = lblHeadNameMoney.Text;
aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmountMoney.Text : "0");
aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmountMoney.Text : "0");
aCC_Journal.JournalMasterID = int.Parse("1");
aCC_Journal.JournalVoucherNo = ddlAccountForMoney.SelectedValue == "42" ? txtCheckNo.Text : "";//temporay we are using to manage the check #
aCC_Journal.UserID = ddlAccountingUserMoney.SelectedValue;
aCC_Journal.AccountID = int.Parse(ddlAccountForMoney.SelectedValue);
aCC_Journal.UserTypeID = int.Parse(ddlUserTypeIDMoney.SelectedValue);
aCC_Journal.AddedBy = Profile.card_id;
aCC_Journal.AddedDate = DateTime.Now;
aCC_Journal.UpdatedBy = Profile.card_id;
aCC_Journal.UpdateDate = DateTime.Now;
aCC_Journal.RowStatusID = 1;
aCC_Journal.IsNotCheck = ddlAccountForMoney.SelectedValue == "42" ? false : true;
doubleEntry.Add(aCC_Journal);
Session["doubleEntry"] = doubleEntry;
loadJournal();
loadSubmitButton();
}
ClearAllControllMoney();
}
catch (Exception ex)
{
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
try
{
int newEntry = 0;
int prevEntry = 0;
string userID = Profile.card_id;
List<string> newPostings = new List<string>();
List<string> prevPostings = new List<string>();
foreach (GridViewRow row in gvSalaryDetailBreakdown.Rows)
{
CheckBox chkBox = (CheckBox)row.FindControl("chkBoxSelect");
if (chkBox.Checked)
{
HiddenField hfEmployID = (HiddenField)row.FindControl("hfEmployID");
Label lblTotalSalary = (Label)row.FindControl("lblTotalSalary");
Label lblEmployeeName = (Label)row.FindControl("lblEmployeeName");
Label lblPFAmount = (Label)row.FindControl("lblPFAmount");
Label lblSecurityAmount = (Label)row.FindControl("lblSecurityAmount");
GridView gridViewSalaryBreakdown = (GridView)row.FindControl("gvSalaryOnly");
TextBox txtLoanDeduction = (TextBox)row.FindControl("txtLoanDeduction");
Label lbGrandTotal = (Label)row.FindControl("lblGrandTotal");
ACC_EmployPayRoleSalary paySalary = new ACC_EmployPayRoleSalary();
paySalary.AddedBy = userID;
paySalary.AddedDate = DateTime.Now;
paySalary.UpdatedBy = userID;
paySalary.UpdatedDate = DateTime.Now;
paySalary.EmployeeID = hfEmployID.Value;
paySalary.SalaryAmount = Convert.ToDecimal(lbGrandTotal.Text);
paySalary.PaidSalaryAmount = Convert.ToDecimal("0");
paySalary.UnpaidSalaryAmount = Convert.ToDecimal(lbGrandTotal.Text);
paySalary.Status = 1;
paySalary.RowStatusID = 1;
paySalary.SalaryOfDate = ddlMonths.SelectedItem.Text + ", " + ddlYears.SelectedValue;
string salBreakDownHistory = string.Empty;
foreach (GridViewRow salBreakRow in gridViewSalaryBreakdown.Rows)
{
Label lblDescription = (Label)salBreakRow.FindControl("lblDescription");
Label lblSalaryValue = (Label)salBreakRow.FindControl("lblSalaryValue");
salBreakDownHistory += lblDescription.Text + ":" + lblSalaryValue.Text+";";
}
paySalary.ExtraField1 = salBreakDownHistory;
paySalary.ExtraField2 = lblTotalSalary.Text.Trim();
paySalary.ExtraField3 = string.Empty;
paySalary.ExtraField4 = string.Empty;
paySalary.ExtraField5 = string.Empty;
paySalary.ExtraField6 = string.Empty;
paySalary.ExtraField7 = string.Empty;
paySalary.ExtraField8 = Convert.ToDecimal(lbGrandTotal.Text).ToString("0.0");
paySalary.ExtraField9 = string.Empty;
paySalary.ExtraField10 = string.Empty;
int insertedID = ACC_EmployPayRoleSalaryManager.InsertEmployPayRoleSalary(paySalary);
if (insertedID > 0)
{
List<HR_ProvidentFundRegister> providentFundRegisterColl = new List<HR_ProvidentFundRegister>();
HR_ProvidentFundRegister pfRegister = new HR_ProvidentFundRegister();
pfRegister.EmployeeID = hfEmployID.Value;
pfRegister.ExtraField1 = insertedID.ToString();
pfRegister.PayrollMonthDate = Convert.ToDateTime(DateTime.DaysInMonth(Convert.ToInt32(ddlYears.SelectedValue), Convert.ToInt32(ddlMonths.SelectedValue)) + " " + ddlMonths.SelectedItem.Text + " " + ddlYears.SelectedValue);
pfRegister.EPF = Convert.ToDecimal(lblPFAmount.Text);
pfRegister.CPF = Convert.ToDecimal(lblPFAmount.Text);
pfRegister.ExtraField2 = paySalary.ExtraField8;
pfRegister.TotalPFAmount = pfRegister.EPF + pfRegister.CPF;
//pfRegister.WithdrawLastDate = Nullable<DateTime>;
pfRegister.AddedBy = userID;
pfRegister.AddedDate = DateTime.Now;
pfRegister.RowStatusID = 1;
providentFundRegisterColl.Add(pfRegister);
HR_ProvidentFundRegisterManager.InsertHR_ProvidentFundRegister(providentFundRegisterColl);
providentFundRegisterColl.Clear();
if (Convert.ToDecimal(lblPFAmount.Text) != 0)
{
ACC_Journal pfACC_Journal = new ACC_Journal();
pfACC_Journal.UserID = hfEmployID.Value;
pfACC_Journal.Balance = Convert.ToDecimal(lblPFAmount.Text);
pfACC_Journal.AddedBy = userID;
pfACC_Journal.AddedDate = DateTime.Now;
pfACC_Journal.UpdatedBy = userID;
pfACC_Journal.UpdateDate = DateTime.Now;
pfACC_Journal.EmployPayRoleSalaryID = insertedID;
ACC_AccountingCommonManager.ProcessACC_ProvidentFund(hfEmployID.Value, pfACC_Journal);
}
if (Convert.ToDecimal(lblSecurityAmount.Text) != 0)
{
ACC_Journal pfACC_Journal = new ACC_Journal();
pfACC_Journal.UserID = hfEmployID.Value;
pfACC_Journal.Balance = Convert.ToDecimal(lblSecurityAmount.Text);
pfACC_Journal.AddedBy = userID;
pfACC_Journal.AddedDate = DateTime.Now;
pfACC_Journal.UpdatedBy = userID;
pfACC_Journal.UpdateDate = DateTime.Now;
pfACC_Journal.EmployPayRoleSalaryID = insertedID;
ACC_AccountingCommonManager.ProcessACC_SecurityAmount(hfEmployID.Value, pfACC_Journal);
}
if (txtLoanDeduction.Text.Trim() != string.Empty)
{
ACC_Journal advSalaryACC_Journal = new ACC_Journal();
advSalaryACC_Journal.UserID = hfEmployID.Value;
advSalaryACC_Journal.Balance = Convert.ToDecimal(txtLoanDeduction.Text);
advSalaryACC_Journal.AddedBy = userID;
advSalaryACC_Journal.AddedDate = DateTime.Now;
advSalaryACC_Journal.UpdatedBy = userID;
advSalaryACC_Journal.UpdateDate = DateTime.Now;
advSalaryACC_Journal.SalaryOfDate = paySalary.SalaryOfDate;
ACC_AccountingCommonManager.ProcessACC_AdvanceSalary(hfEmployID.Value, advSalaryACC_Journal);
}
newEntry++;
//"<td>" + hfEmployID.Value + "</td>"
newPostings.Add("<td>" + lblEmployeeName.Text + "</td>");
}
else
{
prevEntry++;
//<td>" + hfEmployID.Value + "</td>
prevPostings.Add("<td>" + lblEmployeeName.Text + "</td>");
}
}
}
litSummary.Text = "<table style=\"width:50%;float:left;\"><tr><td style=\"color:Green;font-weight:bold;\">New Postings</td></tr>";
foreach (string entity in newPostings)
{
litSummary.Text += "<tr>"+entity+"</tr>";
}
if (newPostings.Count == 0)
litSummary.Text += "<td>No New Postings</td>";
litSummary.Text += "</table>";
litSummary.Text += "<table style=\"width:50%;float:left;\"><tr><td style=\"color:Green;font-weight:bold;\">Posted Before</td></tr>";
foreach (string entity in prevPostings)
{
litSummary.Text += "<tr>" + entity + "</tr>";
}
if (prevPostings.Count == 0)
litSummary.Text += "<td>No Old Postings</td>";
litSummary.Text += "</table>";
string scriptText = "alert('New Entry : " + newEntry.ToString() + " Old Entry : " + prevEntry.ToString() + "');";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "Summary", scriptText, true);
}
catch (Exception ex)
{
if (ex != null)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "Error", ex.Message, true);
}
}
}
public static bool ProcessACC_FullTimeSalary(string userID, ACC_Journal aCC_Jounal)
{
SqlACC_AccountingCommonProvider sqlACC_AccountingCommonProvider = new SqlACC_AccountingCommonProvider();
return sqlACC_AccountingCommonProvider.ProcessACC_FullTimeSalary(userID, aCC_Jounal);
}
