public DataTable GetBankList(String BankName)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select bank_id AS 'Bank ID',bank_code AS 'Bank Code',bank_name as 'Bank Name' from Bank_master (NOLOCK) Where bank_name like '" + BankName + "%'";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
private void databaseBackUpToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (objBackUpDatabase == null || objBackUpDatabase.IsDisposed)
{
objBackUpDatabase = new BackUpDatabase();
((Form)objBackUpDatabase).MdiParent = this;
((Form)objBackUpDatabase).Name = "BackUp Database";
((Form)objBackUpDatabase).Text = "BackUp Database";
((BackUpDatabase)objBackUpDatabase).IDataProvider = IDataProvider;
objBackUpDatabase.StartPosition = FormStartPosition.CenterScreen;
objBackUpDatabase.Show();
}
else
{
objBackUpDatabase.BringToFront();
objBackUpDatabase.StartPosition = FormStartPosition.CenterScreen;
((Form)objBackUpDatabase).MdiParent = this;
objBackUpDatabase.Focus();
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
}
private void userMasterToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (objUserMaster == null || objUserMaster.IsDisposed)
{
objUserMaster = new UserMaster();
((Form)objUserMaster).MdiParent = this;
((Form)objUserMaster).Name = "User Master";
((Form)objUserMaster).Text = "User Master";
((UserMaster)objUserMaster).IDataProvider = IDataProvider;
objUserMaster.StartPosition = FormStartPosition.CenterScreen;
objUserMaster.Show();
}
else
{
objUserMaster.BringToFront();
objUserMaster.StartPosition = FormStartPosition.CenterScreen;
((Form)objUserMaster).MdiParent = this;
objUserMaster.Focus();
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
}
private void dgvBrachList_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
BranchId = Convert.ToInt32(dgvBrachList["Branch ID", e.RowIndex].Value);
cmbBankName.Text = dgvBrachList["Bank Name", e.RowIndex].Value.ToString();
txtBranchCode.Text = dgvBrachList["Branch Code", e.RowIndex].Value.ToString();
txtBranchName.Text = dgvBrachList["Branch Name", e.RowIndex].Value.ToString();
txtBranchAddress.Text = dgvBrachList["Address", e.RowIndex].Value.ToString();
txtPhone.Text = dgvBrachList["Phone", e.RowIndex].Value.ToString();
tabCtlBranchMaster.SelectedIndex = 1;
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
cmbBankName.Enabled = false;
txtBranchName.Enabled = false;
txtBranchAddress.Enabled = false;
txtPhone.Enabled = false;
btnAdd.Enabled = false;
btnModify.Enabled = true;
btnSave.Enabled = false;
btnModify.Focus();
}
private void shareContributionDetailsToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (LoginInfo.YearId != 0)
{
if (objShareContributionDetails == null || objShareContributionDetails.IsDisposed)
{
objShareContributionDetails = new ShareContributionDetails();
((Form)objShareContributionDetails).MdiParent = this;
((Form)objShareContributionDetails).Name = "Share Contribution Details";
((Form)objShareContributionDetails).Text = "Share Contribution Details";
((ShareContributionDetails)objShareContributionDetails).IDataProvider = IDataProvider;
objShareContributionDetails.StartPosition = FormStartPosition.CenterScreen;
objShareContributionDetails.Show();
}
else
{
objShareContributionDetails.BringToFront();
objShareContributionDetails.StartPosition = FormStartPosition.CenterScreen;
((Form)objShareContributionDetails).MdiParent = this;
objShareContributionDetails.Focus();
}
}
else
{
MessageBox.Show("Please set current financial year", "Patpedhi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
}
public DataTable GetSchoolList(String Schoolname)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select school_id AS 'School ID',school_code as 'School Code', School_name AS 'School Name', " +
" Taluka as 'Taluka', School_address as 'School Address', school_phone as 'School Phone' " +
" from School_master SM (NOLOCK) Inner join Taluka_master TM (NOLOCK) on SM.taluka_id=TM.taluka_id " +
" Where School_name like '" + Schoolname + "%'";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
private void DividentInterestRegister_Load(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = IDataProvider.GetTalukaList("");
DataRow dr1 = dt.NewRow();
dr1["Taluka ID"] = 0;
dr1["Taluka Name"] = "All";
dt.Rows.InsertAt(dr1, 0);
cmbTaluka.DisplayMember = "Taluka Name";
cmbTaluka.ValueMember = "Taluka ID";
cmbTaluka.DataSource = dt;
dt = IDataProvider.GetBankList("");
DataRow dr2 = dt.NewRow();
dr2["Bank ID"] = 0;
dr2["Bank Name"] = "All";
dt.Rows.InsertAt(dr2, 0);
cmbBank.DisplayMember = "Bank Name";
cmbBank.ValueMember = "Bank ID";
cmbBank.DataSource = dt;
cmbTag.SelectedIndex = 0;
cmbRoundOff.Items.Insert(0, "No");
cmbRoundOff.Items.Insert(1, "Yes");
cmbRoundOff.SelectedIndex = 0;
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
}
public DataTable GetDefaultYear()
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "Select yearid,yearcode From FinancialYear_master where IsDefault = 1";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public DataTable GetShareContributionList(string MemCode, String MemName)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "Select member_shcontri_id AS 'ShareContriId', MM.member_id as 'MemberId', yearid as 'YearId', Member_code as 'Member Code', " +
" Member_name AS 'Member Name', Share as 'Share', contribution as 'Contribution' FROM Member_ShareContribution_Details SC INNER JOIN Member_master MM " +
" ON MM.Member_id = SC.Member_id Where yearid = " + LoginInfo.YearId + " AND Member_code like '" + MemCode + "%' AND Member_name like '" + MemName + "%' And MM.IsDeleted = 0";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public Int16 UpdateFinancialYear(Int32 YearId, Int16 IsDefault, Int32 EditedBy)
{
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
SqlParameter OutParameter = new SqlParameter();
try
{
using (SqlCommand cmdAddCommand = new SqlCommand())
{
cmdAddCommand.Connection = Con;
cmdAddCommand.CommandType = CommandType.StoredProcedure;
cmdAddCommand.CommandText = "UpdateDefaultFinancialYear";
cmdAddCommand.Parameters.AddWithValue("@YearId", YearId);
cmdAddCommand.Parameters.AddWithValue("@IsDefault", IsDefault);
cmdAddCommand.Parameters.AddWithValue("@edited_by", EditedBy);
OutParameter.ParameterName = "@Flag";
OutParameter.SqlDbType = SqlDbType.Int;
OutParameter.Direction = ParameterDirection.Output;
cmdAddCommand.Parameters.Add(OutParameter);
cmdAddCommand.ExecuteNonQuery();
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(Convert.ToInt16(OutParameter.Value));
}
public DataTable GetRateList()
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "Select rate_id as 'RateId', FM.yearid as 'YearId', yearcode as 'Financial Year',Interest_rate as 'Interest Rate',Divident_rate as 'Divident Rate', Convert(varchar(10),agmdate,103) as 'AGM Date', Convert(varchar(10),RM.CutOffDate,103) AS 'CutOff Date' " +
" FROM Rate_master RM INNER JOIN FinancialYear_master FM ON RM.yearid = FM.yearid ";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public DataTable GetFinancialYear()
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "Select yearid AS 'Year Id',yearstarting AS 'Year Start',yearending AS 'Year End',yearcode AS 'Year Code'," +
" CASE WHEN IsDefault = 0 THEN 'No' ELSE 'Yes' END AS 'Default' FROM FinancialYear_master";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public DataTable GetMemberList(String MemberName)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select Member_id as 'Member ID', Member_code as 'Member Code'," +
" Member_name as 'Member Name',SM.school_name as 'School Name', " +
" bank_name as 'Bank Name',branch_name as 'Branch Name', " +
" account_no as 'Bank Accout No',membership_date as 'Membership Date', " +
" isdefaulter as 'Tag',CASE WHEN Status =0 THEN 'Active' ELSE 'InActive' END AS 'Status', " +
" MM.Address as 'Address', MM.Phone as 'Phone' " +
" FROM Member_master MM (NOLOCK) INNER JOIN School_master SM (NOLOCK) " +
" ON MM.school_id = SM.school_id LEFT JOIN Bank_master BM (NOLOCK) " +
" ON MM.bank_id = BM.bank_id LEFT JOIN Bank_Branch_Details BBD (NOLOCK) " +
" ON BBD.branch_id = MM.branch_id where Member_name like '" + MemberName + "%' and IsDeleted = 0";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public DataTable GetBranchList(String BankName, String BranchName)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select branch_id AS 'Branch ID', BM.bank_id AS 'Bank ID',branch_code as 'Branch Code', " +
" bank_name as 'Bank Name' , branch_name as 'Branch Name',Address as 'Address',Phone as 'Phone' " +
" from Bank_Branch_Details BBD (NOLOCK) INNER JOIN Bank_master BM (NOLOCK) ON BBD.bank_id = BM.bank_id " +
" Where BM.bank_name like '" + BankName + "%' and BBD.branch_name like '" + BranchName + "%'";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public DataTable GetBranchWiseSummaryReport(Int32 BankId, Int32 RoundOff)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "BranchWiseSummeryReport";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BankId", BankId);
cmd.Parameters.AddWithValue("@RoundOff", RoundOff);
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public DataTable GetTalukaList(String TalukaName)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select taluka_id AS 'Taluka ID',taluka AS 'Taluka Name' " +
" from Taluka_master (NOLOCK) Where taluka like '" + TalukaName + "%' Order By taluka";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public DataTable GetYearInterestRateDetails()
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "GetYearIntRateDet";
cmd.CommandType = CommandType.StoredProcedure;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
public String GetMemberName(String MemberCode)
{
String MemberName = String.Empty;
try
{
using (SqlCommand cmd = new SqlCommand())
{
String sql = "Select Member_name FROM Member_master Where Member_code = '" + MemberCode + "'";
cmd.Connection = Con;
cmd.CommandText = sql;
object obj = cmd.ExecuteScalar();
if (obj != null)
{
MemberName = obj.ToString();
}
else
{
MemberName = "";
}
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(MemberName);
}
public Int16 BackUpDatabase(String Path)
{
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
SqlParameter OutParameter = new SqlParameter();
try
{
using (SqlCommand cmdAddCommand = new SqlCommand())
{
cmdAddCommand.Connection = Con;
cmdAddCommand.CommandType = CommandType.StoredProcedure;
cmdAddCommand.CommandText = "BackUpDatabase";
cmdAddCommand.Parameters.AddWithValue("@Path", Path);
OutParameter.ParameterName = "@Flag";
OutParameter.SqlDbType = SqlDbType.Int;
OutParameter.Direction = ParameterDirection.Output;
cmdAddCommand.Parameters.Add(OutParameter);
cmdAddCommand.ExecuteNonQuery();
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(Convert.ToInt16(OutParameter.Value));
}
public DataTable GetMemberCodeName()
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select Member_code as 'Member Code', Member_name as 'Member Name' FROM Member_master Order by Member_code";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
private void BranchMaster_Load(object sender, EventArgs e)
{
try
{
dvBranch = IDataProvider.GetBranchList("", "").DefaultView;
dgvBrachList.DataSource = dvBranch;
dgvBrachList.Columns["Branch ID"].Visible = false;
dgvBrachList.Columns["Bank ID"].Visible = false;
dtBank = IDataProvider.GetBankList("");
DataRow dr1 = dtBank.NewRow();
dr1["Bank ID"] = 0;
dr1["Bank Name"] = "Select";
dtBank.Rows.InsertAt(dr1, 0);
cmbBankName.DataSource = dtBank;
cmbBankName.DisplayMember = "Bank Name";
cmbBankName.ValueMember = "Bank ID";
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
txtBranchCode.Text = "";
txtBranchName.Text = "";
txtBranchAddress.Text = "";
txtPhone.Text = "";
cmbBankName.Enabled = false;
txtBranchName.Enabled = false;
txtBranchAddress.Enabled = false;
txtPhone.Enabled = false;
btnAdd.Enabled = true;
btnModify.Enabled = false;
btnSave.Enabled = false;
}
public DataTable GetUploadedMemberId()
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select Member_code as 'Member Code', SC.Member_id AS 'Member Id' FROM Member_master MM INNER JOIN Member_ShareContribution_Details SC " +
" ON MM.Member_id = SC.Member_id WHERE SC.yearid = " + LoginInfo.YearId + " Order by Member_code";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
private void dgvShareContribution_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
txtShare.BackColor = Color.White;
ShareContriId = Convert.ToInt64(dgvShareContribution["ShareContriId", e.RowIndex].Value);
YearId = Convert.ToInt32(dgvShareContribution["YearId", e.RowIndex].Value);
MemberId = Convert.ToInt32(dgvShareContribution["MemberId", e.RowIndex].Value);
txtMemberCode.Text = dgvShareContribution["Member Code", e.RowIndex].Value.ToString();
txtMemberName.Text = dgvShareContribution["Member Name", e.RowIndex].Value.ToString();
txtShare.Text = dgvShareContribution["Share", e.RowIndex].Value.ToString();
txtContribution.Text = dgvShareContribution["Contribution", e.RowIndex].Value.ToString();
tabCtlShareContribution.SelectedIndex = 1;
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
txtMemberCode.Enabled = false;
txtShare.Enabled = false;
txtContribution.Enabled = false;
btnAdd.Enabled = false;
btnModify.Enabled = true;
btnSave.Enabled = false;
btnModify.Focus();
}
public DataTable GetSchoolsInTaluka(Int32 TalukaId)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select school_id AS 'School ID',school_name as 'School Name'" +
" from School_master SM (NOLOCK) Inner join Taluka_master TM (NOLOCK) on SM.taluka_id=TM.taluka_id " +
" Where TM.taluka_id = CASE WHEN " + TalukaId + " = 0 THEN TM.taluka_id ELSE " + TalukaId + " END";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
private void dividentInterestRegisterToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (LoginInfo.YearId != 0)
{
if (objDividentInterestRegister == null || objDividentInterestRegister.IsDisposed)
{
objDividentInterestRegister = new DividentInterestRegister();
((Form)objDividentInterestRegister).MdiParent = this;
((Form)objDividentInterestRegister).Name = "Divident interest register";
((Form)objDividentInterestRegister).Text = "Divident interest register";
((DividentInterestRegister)objDividentInterestRegister).IDataProvider = IDataProvider;
objDividentInterestRegister.StartPosition = FormStartPosition.CenterScreen;
objDividentInterestRegister.Show();
}
else
{
objDividentInterestRegister.BringToFront();
objDividentInterestRegister.StartPosition = FormStartPosition.CenterScreen;
((Form)objDividentInterestRegister).MdiParent = this;
objDividentInterestRegister.Focus();
}
}
else
{
MessageBox.Show("Please set current financial year", "Patpedhi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
}
public DataTable GetBranchInBank(Int32 BankId)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "select branch_id AS 'Branch ID', branch_name as 'Branch Name' " +
" from Bank_Branch_Details BBD (NOLOCK) INNER JOIN Bank_master BM (NOLOCK) ON BBD.bank_id = BM.bank_id " +
" Where BBD.bank_id = CASE WHEN " + BankId + " = 0 THEN BBD.bank_id ELSE " + BankId + " END";
cmd.Connection = Con;
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
private void branchWiseToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (LoginInfo.YearId != 0)
{
if (objBranchWiseSummary == null || objBranchWiseSummary.IsDisposed)
{
objBranchWiseSummary = new BranchWiseSummary();
((Form)objBranchWiseSummary).MdiParent = this;
((Form)objBranchWiseSummary).Name = "Bank Branch Wise Report";
((Form)objBranchWiseSummary).Text = "Bank Branch Wise Report";
((BranchWiseSummary)objBranchWiseSummary).IDataProvider = IDataProvider;
objBranchWiseSummary.StartPosition = FormStartPosition.CenterScreen;
objBranchWiseSummary.Show();
}
else
{
objBranchWiseSummary.BringToFront();
objBranchWiseSummary.StartPosition = FormStartPosition.CenterScreen;
((Form)objBranchWiseSummary).MdiParent = this;
objBranchWiseSummary.Focus();
}
}
else
{
MessageBox.Show("Please set current financial year", "Patpedhi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
}
public DataTable GetDividentInterestReport(Int32 TalukaId, Int32 SchoolId, Int32 BankId, Int32 BranchId, Int16 Tag, Int32 RoundOff)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
using (SqlCommand cmd = Con.CreateCommand())
{
cmd.CommandText = "DividentInterestReport";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TalukaId", TalukaId);
cmd.Parameters.AddWithValue("@SchoolId", SchoolId);
cmd.Parameters.AddWithValue("@BankId", BankId);
cmd.Parameters.AddWithValue("@BranchId", BranchId);
cmd.Parameters.AddWithValue("@Tag", Tag);
cmd.Parameters.AddWithValue("@RoundOff", RoundOff);
da.SelectCommand = cmd;
da.Fill(dt);
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(dt);
}
private void dgvFinancialYear_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
YearId = Convert.ToInt16(dgvFinancialYear["Year Id", e.RowIndex].Value);
txtYearCode.Text = dgvFinancialYear["Year COde", e.RowIndex].Value.ToString();
dtpYearStarting.Value = Convert.ToDateTime(dgvFinancialYear["Year Start", e.RowIndex].Value);
dtpYearEnding.Value = Convert.ToDateTime(dgvFinancialYear["Year End", e.RowIndex].Value);
if (dgvFinancialYear["Default", e.RowIndex].Value.ToString() == "No")
{
chkDefaulter.Checked = false;
}
else
{
chkDefaulter.Checked = true;
}
tabCtlTalukaMaster.SelectedIndex = 1;
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
chkDefaulter.Enabled = false;
btnModify.Enabled = true;
btnSave.Enabled = false;
}
public Int32 CheckUserLogin(String UserName, String Password)
{
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
SqlParameter OutParameter = new SqlParameter();
try
{
using (SqlCommand cmdAddCommand = new SqlCommand())
{
cmdAddCommand.Connection = Con;
cmdAddCommand.CommandType = CommandType.StoredProcedure;
cmdAddCommand.CommandText = "CheckUserLogin";
cmdAddCommand.Parameters.AddWithValue("@User_code", UserName.Replace("'", "''"));
cmdAddCommand.Parameters.AddWithValue("@Password", Password.Replace("'", "''"));
OutParameter.ParameterName = "@User_id";
OutParameter.SqlDbType = SqlDbType.Int;
OutParameter.Direction = ParameterDirection.Output;
cmdAddCommand.Parameters.Add(OutParameter);
cmdAddCommand.ExecuteNonQuery();
}
}
catch (Exception ex)
{
CustomException.CustomExceptionLog(ex);
}
return(Convert.ToInt32(OutParameter.Value));
}
