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