public int InsertGuardian(GuadianEntity oGuardianEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblGuardian (GuardianID,GuardianRightPercentage,GuardianName,GuardianFatherName,GuardianRelationWithN," + "GuardianSex,GuardianDOB,GuardianReligion,GuardianCountryID,GuardianNID,GuardianTIN,GuardianPermanentAddress,GuardianPermanentContact,GuardianPresentAddress," + "GuardianPresentContact,NomineeID,GuardianCreateBy,GuardianLastModified)" + "VALUES('" + oGuardianEntity.GuardianID + "','" + oGuardianEntity.GuardianRightPercentage + "','" + oGuardianEntity.GuardianName + "'," + "'" + oGuardianEntity.GuardianFatherName + "','" + oGuardianEntity.GuardianRelationWithN + "','" + oGuardianEntity.GuardianSex + "','" + oGuardianEntity.GuardianDOB + "'," + "'" + oGuardianEntity.GuardianReligion + "','" + oGuardianEntity.GuardianCountryID + "','" + oGuardianEntity.GuardianNID + "','" + oGuardianEntity.GuardianTIN + "','" + oGuardianEntity.GuardianPermanentAddress + "'," + "'" + oGuardianEntity.GuardianPermanentContact + "','" + oGuardianEntity.GuardianPresentAddress + "','" + oGuardianEntity.GuardianPresentContact + "'," + "'" + oGuardianEntity.NomineeID + "','" + oGuardianEntity.GuardianCreateBy + "','" + oGuardianEntity.GuardianLastModified + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertUserInfo(UserInfoEntity oUserInfoEntity) { con = oConnectionDatabase.DatabaseConnection(); try { con.Open(); } catch { } int i = 0; //cmd = new SqlCommand("INSERT INTO tblCustomerImage (CustomerID,CustomerImage,CustomerSignature,Creatby,LastModifiedBy) VALUES('" + customerId + "','" + image + "','" + signature + "','" + Creatby + "','" + LastModifiedBy + "')", con); cmd = new SqlCommand("INSERT INTO tblUserInfo (UserID,UserType,Password,ConfirmPassword,Active,EmployeeID,CreateBy,LastModifiedBy) VALUES(@UserID,@UserType,@Password,@ConfirmPassword,@Active,@EmployeeID,@CreateBy,@LastModifiedBy)", con); cmd.Parameters.AddWithValue("@UserID", SqlDbType.VarChar).Value = oUserInfoEntity.UserID; cmd.Parameters.AddWithValue("@UserType", SqlDbType.Image).Value = oUserInfoEntity.UserType; cmd.Parameters.AddWithValue("@Password", SqlDbType.VarChar).Value = oUserInfoEntity.Password; cmd.Parameters.AddWithValue("@ConfirmPassword", SqlDbType.Image).Value = oUserInfoEntity.ConfirmPassword; cmd.Parameters.AddWithValue("@Active", SqlDbType.VarChar).Value = oUserInfoEntity.Active; cmd.Parameters.AddWithValue("@EmployeeID", SqlDbType.VarChar).Value = oUserInfoEntity.EmployeeID; cmd.Parameters.AddWithValue("@CreateBy", SqlDbType.Image).Value = oUserInfoEntity.CreateBy; cmd.Parameters.AddWithValue("@LastModifiedBy", SqlDbType.VarChar).Value = oUserInfoEntity.LastModifiedBy; try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertUserAssignRight(UserAssignRightEntity oUserAssignRightEntity) { con = oConnectionDatabase.DatabaseConnection(); try { con.Open(); } catch { } int i = 0; //cmd = new SqlCommand("INSERT INTO tblCustomerImage (CustomerID,CustomerImage,CustomerSignature,Creatby,LastModifiedBy) VALUES('" + customerId + "','" + image + "','" + signature + "','" + Creatby + "','" + LastModifiedBy + "')", con); cmd = new SqlCommand("INSERT INTO tblUserAssignRights (UserID,MenuNo,MenuRights,SubMenuNo,SubMenuRights,CreateBy,LastModifiedBy) VALUES(@UserID,@MenuNo,@MenuRights,@SubMenuNo,@SubMenuRights,@CreateBy,@LastModifiedBy)", con); cmd.Parameters.AddWithValue("@UserID", SqlDbType.VarChar).Value = oUserAssignRightEntity.UserID; cmd.Parameters.AddWithValue("@MenuNo", SqlDbType.Image).Value = oUserAssignRightEntity.MenuNo; cmd.Parameters.AddWithValue("@SubMenuNo", SqlDbType.VarChar).Value = oUserAssignRightEntity.SubMenuNo; cmd.Parameters.AddWithValue("@MenuRights", SqlDbType.Image).Value = oUserAssignRightEntity.MenuRights; cmd.Parameters.AddWithValue("@SubMenuRights", SqlDbType.VarChar).Value = oUserAssignRightEntity.SubMenuRights; cmd.Parameters.AddWithValue("@CreateBy", SqlDbType.Image).Value = oUserAssignRightEntity.CreateBy; cmd.Parameters.AddWithValue("@LastModifiedBy", SqlDbType.VarChar).Value = oUserAssignRightEntity.LastModifiedBy; try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertMenu(MenuEntity oMenuEntity) { con = oConnectionDatabase.DatabaseConnection(); ////try { con.Open(); } ////catch { } int i = 0; //cmd = new SqlCommand("INSERT INTO tblCustomerImage (CustomerID,CustomerImage,CustomerSignature,Creatby,LastModifiedBy) VALUES('" + customerId + "','" + image + "','" + signature + "','" + Creatby + "','" + LastModifiedBy + "')", con); cmd = new SqlCommand("INSERT INTO tblMenuItem (MenuNo,MenuName,CreateBy,LastModifiedBy) VALUES(@MenuNo,@MenuName,@CreateBy,@LastModifiedBy)", con); cmd.Parameters.AddWithValue("@MenuNo", SqlDbType.VarChar).Value = oMenuEntity.MenuNo; cmd.Parameters.AddWithValue("@MenuName", SqlDbType.Image).Value = oMenuEntity.MenuName; cmd.Parameters.AddWithValue("@CreateBy", SqlDbType.VarChar).Value = oMenuEntity.CreateBy; cmd.Parameters.AddWithValue("@LastModifiedBy", SqlDbType.Image).Value = oMenuEntity.LastModifiedBy; try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
//Load BankName private void LoadBankName() { SqlConnection con; SqlCommand cmd; string sqlQuery = null; oTransactionDAL = new TransactionDAL(); DataTable dt = new DataTable(); Condition = ""; if (getValue == "Branch Admin" && division == "Branch Admin") { sqlQuery = "SELECT TOP 1 0 BANK_ID, 'All Item' BANK_NAME FROM ISS_BANK_INFO ORDER BY BANK_NAME"; con = oConnectionDatabase.DatabaseConnection(); cmd = new SqlCommand(sqlQuery, con); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); try { da.Fill(dt); } catch { } con.Close(); } else { dt = oTransactionDAL.Bank_Name(Condition); } drpBankName.DataSource = dt; drpBankName.DataTextField = "BANK_NAME"; drpBankName.DataValueField = "BANK_ID"; drpBankName.DataBind(); }
public int InsertEmployeeInfo(EmployeeInfoEntity oEmployeeInfoEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblEmployeeInfo (EmployeeID,EmployeeName,Designation,RegistrationNo,BranchCode,MobileNo,CreateBy,LastModifiedBy) VALUES('" + oEmployeeInfoEntity.EmployeeID + "','" + oEmployeeInfoEntity.EmployeeName + "','" + oEmployeeInfoEntity.Designation + "','" + oEmployeeInfoEntity.RegistrationNo + "','" + oEmployeeInfoEntity.BranchCode + "','" + oEmployeeInfoEntity.MobileNo + "','" + oEmployeeInfoEntity.CreateBy + "','" + oEmployeeInfoEntity.LastModifiedBy + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertClientType(ClientTypeEntity oClientTypeEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblClientType (ClientTypeCode,ClientTypeDetais,ClientTypeRemarks,ClientTypeChargePercentage,ClientTypeCreateBy,ClientTypeLastModifiedBy) VALUES('" + oClientTypeEntity.ClientTypeCode + "','" + oClientTypeEntity.ClientTypeDetais + "','" + oClientTypeEntity.ClientTypeRemarks + "','" + oClientTypeEntity.ClientTypeChargePercentage + "','" + oClientTypeEntity.ClientTypeCreateBy + "','" + oClientTypeEntity.ClientTypeLastModifiedBy + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertTransactionRole(TransactionRoleEntity oTransactionRoleEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblRole (RoleCode,RoleDetails,RoleRemarks,RoleCreateBy,RoleLastModifiedBy) VALUES('" + oTransactionRoleEntity.RoleCode + "','" + oTransactionRoleEntity.RoleDetails + "','" + oTransactionRoleEntity.RoleRemarks + "','" + oTransactionRoleEntity.RoleCreateBy + "','" + oTransactionRoleEntity.RoleLastModifiedBy + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertAccountGroupReport(AccountGroupReportEntity oAccountGroupReportEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblAccountGroupReport (AccGrpCodeR,AccGrpNameR) VALUES('" + oAccountGroupReportEntity.AccGrpCodeR + "','" + oAccountGroupReportEntity.AccGrpNameR + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertCustomer(CustomerEntity oCustomerEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblCustomer (CustomerID,CustomerName,CustomerFatherName,CustomerMotherName,CustomerSex," + "CustomerDOB,CustomerReligion,CountryID,CustomerNID,CustomerTIN,CustomerPassportNO,CustomerMeritalStatus,CustomerEmail,CustomerPermanentAddress," + "CustomerPermanentContact,CustomerPresentAddress,CustomerPresentContact,CustomerMailingAddress,CustomerMailingContact,CustomerNo,Bankid,BranchID,CustomerBankAccount," + "CustommerCreateBY,CustomerApprovedby,CustomerLastModified,CustomerCleintID,CustomerIsCompany,CustomerMobileNo)" + "VALUES('" + oCustomerEntity.CustomerID + "','" + oCustomerEntity.CustomerName + "','" + oCustomerEntity.CustomerFatherName + "'," + "'" + oCustomerEntity.CustomerMotherName + "','" + oCustomerEntity.CustomerSex + "','" + oCustomerEntity.CustomerDOB + "','" + oCustomerEntity.CustomerReligion + "'," + "'" + oCustomerEntity.CountryID + "','" + oCustomerEntity.CustomerNID + "','" + oCustomerEntity.CustomerTIN + "','" + oCustomerEntity.CustomerPassportNO + "','" + oCustomerEntity.CustomerMeritalStatus + "'," + "'" + oCustomerEntity.CustomerEmail + "','" + oCustomerEntity.CustomerPermanentAddress + "','" + oCustomerEntity.CustomerPermanentContact + "'," + "'" + oCustomerEntity.CustomerPresentAddress + "','" + oCustomerEntity.CustomerPresentContact + "','" + oCustomerEntity.CustomerMailingAddress + "','" + oCustomerEntity.CustomerMailingContact + "'," + "'" + oCustomerEntity.CustomerNo + "','" + oCustomerEntity.Bankid + "','" + oCustomerEntity.BranchID + "','" + oCustomerEntity.CustomerBankAccount + "'," + "'" + oCustomerEntity.CustommerCreateBY + "','" + oCustomerEntity.CustomerApprovedby + "','" + oCustomerEntity.CustomerLastModified + "','" + oCustomerEntity.CustomerCleintID + "'," + "'" + oCustomerEntity.CustomerIsCompany + "','" + oCustomerEntity.CustomerMobileNo + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertNominee(NomineeEntity oNomineeEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblNominee (NomineeID,NomineeRightPercentage,NomineeName,NomineeFatherName,NomineeRelationWithC," + "NomineeSex,NomineeDOB,NomineeReligion,NomineeCountryID,NomineeNID,NomineeTIN,NomineePermanentAddress,NomineePermanentContact,NomineePresentAddress," + "NomineePresentContact,ClientID,NomineeIsMature,NomineeCreateBy,NomineeLastModified)" + "VALUES('" + oNomineeEntity.NomineeID + "','" + oNomineeEntity.NomineeRightPercentage + "','" + oNomineeEntity.NomineeName + "'," + "'" + oNomineeEntity.NomineeFatherName + "','" + oNomineeEntity.NomineeRelationWithC + "','" + oNomineeEntity.NomineeSex + "','" + oNomineeEntity.NomineeDOB + "'," + "'" + oNomineeEntity.NomineeReligion + "','" + oNomineeEntity.NomineeCountryID + "','" + oNomineeEntity.NomineeNID + "','" + oNomineeEntity.NomineeTIN + "','" + oNomineeEntity.NomineePermanentAddress + "'," + "'" + oNomineeEntity.NomineePermanentContact + "','" + oNomineeEntity.NomineePresentAddress + "','" + oNomineeEntity.NomineePresentContact + "'," + "'" + oNomineeEntity.ClientID + "','" + oNomineeEntity.NomineeIsMature + "','" + oNomineeEntity.NomineeCreateBy + "','" + oNomineeEntity.NomineeLastModified + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertChartOfAccount(ChartOfAccountEntity oChartOfAccountEntity) { con = oConnectionDatabase.DatabaseConnection(); try { con.Open(); } catch { } int i = 0; //cmd = new SqlCommand("INSERT INTO tblCustomerImage (CustomerID,CustomerImage,CustomerSignature,Creatby,LastModifiedBy) VALUES('" + customerId + "','" + image + "','" + signature + "','" + Creatby + "','" + LastModifiedBy + "')", con); cmd = new SqlCommand("INSERT INTO tblChartOfAccount (CoAccNo,CoAccName,OpenDate,GrpAccSL,AccGrpSLR,AccTypeSL,SGrpAccSL,Posted,OpenDayBalance,ClossingBalance,AvailableBalance,CurrentBalance,CreateBy,LastModifiedBy) VALUES(@CoAccNo,@CoAccName,@OpenDate,@GrpAccSL,@AccGrpSLR,@AccTypeSL,@SGrpAccSL,@Posted,@OpenDayBalance,@ClossingBalance,@AvailableBalance,@CurrentBalance,@CreateBy,@LastModifiedBy)", con); cmd.Parameters.AddWithValue("@CoAccNo", SqlDbType.VarChar).Value = oChartOfAccountEntity.CoAccNo; cmd.Parameters.AddWithValue("@CoAccName", SqlDbType.VarChar).Value = oChartOfAccountEntity.CoAccName; cmd.Parameters.AddWithValue("@OpenDate", SqlDbType.VarChar).Value = oChartOfAccountEntity.OpenDate; cmd.Parameters.AddWithValue("@GrpAccSL", SqlDbType.VarChar).Value = oChartOfAccountEntity.GrpAccSL; cmd.Parameters.AddWithValue("@AccGrpSLR", SqlDbType.VarChar).Value = oChartOfAccountEntity.AccGrpSLR; cmd.Parameters.AddWithValue("@AccTypeSL", SqlDbType.VarChar).Value = oChartOfAccountEntity.AccTypeSL; cmd.Parameters.AddWithValue("@SGrpAccSL", SqlDbType.VarChar).Value = oChartOfAccountEntity.SGrpAccSL; cmd.Parameters.AddWithValue("@Posted", SqlDbType.VarChar).Value = oChartOfAccountEntity.Posted; cmd.Parameters.AddWithValue("@OpenDayBalance", SqlDbType.VarChar).Value = oChartOfAccountEntity.OpenDayBalance; cmd.Parameters.AddWithValue("@ClossingBalance", SqlDbType.VarChar).Value = oChartOfAccountEntity.ClossingBalance; cmd.Parameters.AddWithValue("@AvailableBalance", SqlDbType.VarChar).Value = oChartOfAccountEntity.AvailableBalance; cmd.Parameters.AddWithValue("@CurrentBalance", SqlDbType.VarChar).Value = oChartOfAccountEntity.CurrentBalance; cmd.Parameters.AddWithValue("@CreateBy", SqlDbType.VarChar).Value = oChartOfAccountEntity.CreateBy; cmd.Parameters.AddWithValue("@LastModifiedBy", SqlDbType.VarChar).Value = oChartOfAccountEntity.LastModifiedBy; try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertBank(BankInformationEntity oBankInformationEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblBank (BankName,BankRemarks) VALUES('" + oBankInformationEntity.BankName + "','" + oBankInformationEntity.BankRemarks + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertTransaction(TransactionEntity oTransactionEntity, List <TransactionAccEntity> oTransactionAccEntityList) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; SqlTransaction oSqlTransaction; oSqlTransaction = con.BeginTransaction("s"); cmd = new SqlCommand("INSERT INTO tblTransaction (VoucherNo,VoucherDate,BrSL,TranTypeSL,PartiCulars,Posted,Approved,BillSL,RevTranSL,CreateBy,LastModifiedBy) VALUES(@VoucherNo,@VoucherDate,@BrSL,@TranTypeSL,@PartiCulars,@Posted,@Approved,@BillSL,@RevTranSL,@CreateBy,@LastModifiedBy)", con); cmd.Transaction = oSqlTransaction; cmd.Parameters.AddWithValue("@VoucherNo", SqlDbType.VarChar).Value = oTransactionEntity.VoucherNo; cmd.Parameters.AddWithValue("@VoucherDate", SqlDbType.DateTime).Value = oTransactionEntity.VoucherDate; cmd.Parameters.AddWithValue("@BrSL", SqlDbType.VarChar).Value = oTransactionEntity.BrSL; cmd.Parameters.AddWithValue("@TranTypeSL", SqlDbType.VarChar).Value = oTransactionEntity.TranTypeSL; cmd.Parameters.AddWithValue("@PartiCulars", SqlDbType.Image).Value = oTransactionEntity.PartiCulars; cmd.Parameters.AddWithValue("@Posted", SqlDbType.VarChar).Value = oTransactionEntity.Posted; cmd.Parameters.AddWithValue("@Approved", SqlDbType.VarChar).Value = oTransactionEntity.Approved; cmd.Parameters.AddWithValue("@BillSL", SqlDbType.Image).Value = oTransactionEntity.BillSL; cmd.Parameters.AddWithValue("@RevTranSL", SqlDbType.VarChar).Value = oTransactionEntity.RevTranSL; cmd.Parameters.AddWithValue("@CreateBy", SqlDbType.Image).Value = oTransactionEntity.CreateBy; cmd.Parameters.AddWithValue("@LastModifiedBy", SqlDbType.VarChar).Value = oTransactionEntity.LastModifiedBy; try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; int m = 0; for (int l = 0; l < oTransactionAccEntityList.Count; l++) { TransactionAccEntity oTransactionAccEntity = oTransactionAccEntityList[l]; m += InsertTransactionAcc(oTransactionAccEntity, oSqlTransaction, con); } if (m == oTransactionAccEntityList.Count) { oSqlTransaction.Commit(); } } catch { oSqlTransaction.Rollback(); } con.Close(); return(i); }
public DataTable LoadGridView() { con = oConnectionDatabase.DatabaseConnection(); cmd = new SqlCommand("select * from tblCountry", con); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); try { da.Fill(dt); } catch { } con.Close(); return(dt); }
public int InsertClient(ClientEntity oClientEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblClient (ClientID,ClientBIO,MBHouseCode,ClientIntroducer,RoleCode,ClientTypeCode," + "ChargeCategoryCode,ClientPowerAtonyDetais,ClientSpecialComissionRate,ClientTransactionAccount,AccountType,ClientCreateBy,ClientLastModified,acccountOpeningDate)" + "VALUES('" + oClientEntity.ClientID + "','" + oClientEntity.ClientBIO + "','" + oClientEntity.MBHouseCode + "','" + oClientEntity.ClientIntroducer + "'," + "'" + oClientEntity.RoleCode + "','" + oClientEntity.ClientTypeCode + "','" + oClientEntity.ChargeCategoryCode + "','" + oClientEntity.ClientPowerAtonyDetais + "'," + "'" + oClientEntity.ClientSpecialComissionRate + "','" + oClientEntity.ClientTransactionAccount + "','" + oClientEntity.AccountType + "','" + oClientEntity.ClientCreateBy + "'," + "'" + oClientEntity.ClientLastModified + "','" + oClientEntity.AcccountOpeningDate + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
//Load Category Data private void LoadCategorydrpdownList() { SqlConnection con; SqlCommand cmd; string sqlQuery = null; oTransactionDAL = new TransactionDAL(); if (getValue == "Branch Admin" && division == "Branch Admin") { sqlQuery = "SELECT TOP 1 0 CATEGORY_ID, 'All Item' CATEGORY_NAME FROM ISS_CATEGORY "; con = oConnectionDatabase.DatabaseConnection(); cmd = new SqlCommand(sqlQuery, con); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); try { da.Fill(dt); } catch { } con.Close(); drpCategory.DataSource = dt; drpCategory.DataTextField = "CATEGORY_NAME"; drpCategory.DataValueField = "CATEGORY_ID"; drpCategory.DataBind(); } else { listatus = oTransactionDAL.GetOneReturnOne("ISS_USER_INFO", "USER_ID", Session["UserId"].ToString(), "HO_STATUS"); if (listatus == 1) { Condition = " WHERE HO_STATUS = 1"; } else { Condition = " WHERE BRANCH_STATUS = 1"; } DataTable dt = oTransactionDAL.GetCategory(Condition); drpCategory.DataSource = dt; drpCategory.DataTextField = "CATEGORY_NAME"; drpCategory.DataValueField = "CATEGORY_ID"; drpCategory.DataBind(); } }
public int InsertGroupAccount(GroupAccountEntity oGroupAccountEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblGroupAccount (GrpAccNo,AccGTSL,GrpAccName,Remarks,CrateBy,LastModifiedBy) VALUES('" + oGroupAccountEntity.GrpAccNo + "','" + oGroupAccountEntity.AccGTSL + "','" + oGroupAccountEntity.GrpAccName + "','" + oGroupAccountEntity.Remarks + "','" + oGroupAccountEntity.CrateBy + "','" + oGroupAccountEntity.LastModifiedBy + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
protected void btnSearch_Click(object sender, EventArgs e) { ReturnVal oRtnValue = new ReturnVal(); //string BrCode = oRtnValue.ReturnValue("View_BranchInfo", "userid", "'" + Session["userID"] + "'", "BranchCode"); if (oRtnValue.ReturnValue("LoanAplicationFinancial", "AcountNo", "'" + txtAplication.Text + "' and sub_Sl ='" + txtPlSL.Text + "'", "AcountNo") != "") { ConnectionDatabase oConnectionDatabase = new ConnectionDatabase(); SqlConnection con; SqlCommand cmd; string condition = "Where AcountNo='" + txtAplication.Text + "' and sub_Sl ='" + txtPlSL.Text + "'"; con = oConnectionDatabase.DatabaseConnection(); cmd = new SqlCommand("SELECT * from LoanAplicationFinancial " + condition, con); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); try { da.Fill(dt); } catch { } con.Close(); DrpType.Text = dt.Rows[0]["Type"].ToString(); DropNature.Text = dt.Rows[0]["Nature"].ToString(); txtExistingLimmit.Text = dt.Rows[0]["ExistingLimitAmount"].ToString(); txtProposedLimit.Text = dt.Rows[0]["ProposedLimit"].ToString(); txtRevisedLimit.Text = dt.Rows[0]["RevisedLimit"].ToString(); txtOutStanding.Text = dt.Rows[0]["Outstanding"].ToString(); txtOverDeu.Text = dt.Rows[0]["OverDue"].ToString(); txtEOL.Text = dt.Rows[0]["EOL"].ToString(); txtExistingSanction.Text = dt.Rows[0]["ExistingSanction"].ToString(); txtSanctionAmount.Text = dt.Rows[0]["ProposedSanction"].ToString(); txtRevisedSanction.Text = dt.Rows[0]["RevisedSanction"].ToString(); txtexixtingTenor.Text = dt.Rows[0]["ExistingTenor"].ToString(); txtProposedTenor.Text = dt.Rows[0]["ProposedTenor"].ToString(); txtTenorRevised.Text = dt.Rows[0]["RevisedTenor"].ToString(); txtExixtingInstallmentAmount.Text = dt.Rows[0]["ExistingInstallmentAmount"].ToString(); txtProposedInstallment.Text = dt.Rows[0]["ProposedInstallmentAmount"].ToString(); txtRevisedInstallment.Text = dt.Rows[0]["RevisedInstallmentAmount"].ToString(); txtExistingLCComission.Text = dt.Rows[0]["ExistingLC_Comission"].ToString(); txtProposedLCComission.Text = dt.Rows[0]["ProposedLC_Comission"].ToString(); txtRevisedLCComission.Text = dt.Rows[0]["RevisedLC_Comission"].ToString(); txtExistingAcceptedComission.Text = dt.Rows[0]["ExistingAcceptedComision"].ToString(); txtAcceptedCommisionProposed.Text = dt.Rows[0]["proposedAcceptedComision"].ToString(); txtAcceptedComissionRevised.Text = dt.Rows[0]["RevisedAcceptedComision"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[0]["SanctionDate"].ToString())) { txtSanctionDate.Text = DateTime.Parse(dt.Rows[0]["SanctionDate"].ToString()).ToString("dd/MM/yyyy"); } if (!string.IsNullOrEmpty(dt.Rows[0]["ProposedDate"].ToString())) { txtProposedDate.Text = DateTime.Parse(dt.Rows[0]["SanctionDate"].ToString()).ToString("dd/MM/yyyy"); } txtExistingInterestRate.Text = dt.Rows[0]["ExistingInttRate"].ToString(); txtProposedInttRate.Text = dt.Rows[0]["ProposedInttRate"].ToString(); txtRevisedInttRate.Text = dt.Rows[0]["RevisedInttRate"].ToString(); txtExistingGracePriod.Text = dt.Rows[0]["ExixtingGrascePriod"].ToString(); txtProposedGracePreiod.Text = dt.Rows[0]["ProposedGrascePriod"].ToString(); txtRevisedGracePreiod.Text = dt.Rows[0]["RevisedGrascePriod"].ToString(); DropStatus.Text = dt.Rows[0]["Status"].ToString(); txtMargin.Text = dt.Rows[0]["Margin"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[0]["ValidityDate"].ToString())) { txtvalidityDate.Text = DateTime.Parse(dt.Rows[0]["ValidityDate"].ToString()).ToString("dd/MM/yyyy"); } if (!string.IsNullOrEmpty(dt.Rows[0]["GroupSL"].ToString())) { YrChkBox.Checked = true; Group.Visible = true; SubGroup.Visible = true; drpGroup.SelectedValue = dt.Rows[0]["GroupSL"].ToString(); LoadSubGroup(1, drpGroup.SelectedValue); if (!string.IsNullOrEmpty(dt.Rows[0]["SubGroupSL"].ToString())) { DropSubGroup.SelectedValue = dt.Rows[0]["SubGroupSL"].ToString(); //ReturnVal oRtnValue1 = new ReturnVal(); //DropSubGroup.Text = oRtnValue.ReturnValue("SubGroupInfo", "SubgroupSL", "'" + dt.Rows[0]["SubGroupSL"].ToString() + "'", "SubGroupName"); } } else { YrChkBox.Checked = false; Group.Visible = false; SubGroup.Visible = false; } } else { //txtPlSL.Text = ""; DrpType.Text = ""; DropNature.Text = ""; txtExistingLimmit.Text = ""; txtProposedLimit.Text = ""; txtRevisedLimit.Text = ""; txtTenorRevised.Text = ""; txtOutStanding.Text = ""; txtOverDeu.Text = ""; txtEOL.Text = ""; txtExistingSanction.Text = ""; txtSanctionAmount.Text = ""; txtRevisedSanction.Text = ""; txtexixtingTenor.Text = ""; txtProposedTenor.Text = ""; txtTenorRevised.Text = ""; txtExixtingInstallmentAmount.Text = ""; txtProposedInstallment.Text = ""; txtRevisedInstallment.Text = ""; txtExistingLCComission.Text = ""; txtProposedLCComission.Text = ""; txtRevisedLCComission.Text = ""; txtExistingAcceptedComission.Text = ""; txtAcceptedCommisionProposed.Text = ""; txtAcceptedComissionRevised.Text = ""; txtSanctionDate.Text = ""; txtProposedDate.Text = ""; txtExistingInterestRate.Text = ""; txtProposedInttRate.Text = ""; txtRevisedInttRate.Text = ""; txtExistingGracePriod.Text = ""; txtProposedGracePreiod.Text = ""; txtRevisedGracePreiod.Text = ""; DropStatus.Text = ""; txtMargin.Text = ""; txtvalidityDate.Text = ""; } }
public int InsertChargeItem(ChargeItemEntity oChargeItemEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblChargeItem (ChargeCode,ChargeDetails,ChargeAmount,CApplyLowerLimit,CApplyHigherLimit,ChargePercentage,ChargeItemType,ChargeRemarks,ChargeCreatedBy,ChargeLastModifiedBy) VALUES('" + oChargeItemEntity.ChargeCode + "','" + oChargeItemEntity.ChargeDetails + "','" + oChargeItemEntity.ChargeAmount + "','" + oChargeItemEntity.CApplyLowerLimit + "','" + oChargeItemEntity.CApplyHigherLimit + "','" + oChargeItemEntity.ChargePercentage + "','" + oChargeItemEntity.ChargeItemType + "','" + oChargeItemEntity.ChargeRemarks + "','" + oChargeItemEntity.ChargeCreatedBy + "','" + oChargeItemEntity.ChargeLastModifiedBy + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public void pickReqData() { ldConditionOne = 0.0; ldConditionTwo = 0.0; ldConditionThree = 0.0; ldConditionFour = 0.0; ldConditionFive = 0.0; ldConditionSix = 0.0; ldConditionSeven = 0.0; ldConditionEight = 0.0; ldConditionNine = 0.0; ldConditionTen = 0.0; string Subcategory = ""; double balance = 0; string BranchCode = branchDropDownList.SelectedValue.ToString(); con = oConnectionDatabase.DatabaseConnection(); sqlQuery = "SELECT * FROM [ISS].[dbo].[ISS_TRANSACTION] WHERE TRAN_ID = '" + pssTransactionId + "' AND BRANCH_CODE = '" + BranchCode + "' AND SUBCATEGORY_ID IN ('17102','17104','17106','18101','18102','18103','18104','18105','20101','20102','20103','21101','21102','22101','22102','22103','28101','28102','28103','28104','31101','31102','31103','31104','31110','31111','31112','31113','31114') "; cmd = new SqlCommand(sqlQuery, con); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { try { Subcategory = Convert.ToString(dr["SUBCATEGORY_ID"]); balance = Convert.ToDouble(dr["AMOUNT"]); if (Subcategory == "17102") { ldtotlnOut = balance; } else if (Subcategory == "17104") { ldovrduelnAmount = balance; } else if (Subcategory == "17106") { ldtotnplOut = balance; } else if (Subcategory == "28101") { ldtotresculedlnOut = balance; } else if (Subcategory == "28104") { ldtotdeclassifiedlnOut = balance; } else if (Subcategory == "31104") { ldtotOutofAccepIssued = balance; } else if (Subcategory == "31110") { ldtotOutBlnceofIssedBnkGrnt = balance; } else if (Subcategory == "18101" || Subcategory == "18102" || Subcategory == "18103" || Subcategory == "18104" || Subcategory == "18105") { if (Subcategory == "18101" || Subcategory == "18102") { ldConditionOne = ldConditionOne + balance; } else { ldConditionOne = ldConditionOne + balance; ldConditionTwo = ldConditionTwo + balance; } } else if (Subcategory == "20101" || Subcategory == "20102" || Subcategory == "20103") { ldConditionFour = ldConditionFour + balance; } else if (Subcategory == "21101" || Subcategory == "21102") { ldConditionFive = ldConditionFive + balance; } else if (Subcategory == "22101" || Subcategory == "22102" || Subcategory == "22103") { ldConditionSix = ldConditionSix + balance; } else if (Subcategory == "28102" || Subcategory == "28103") { ldConditionSeven = ldConditionSeven + balance; } else if (Subcategory == "31101" || Subcategory == "31102" || Subcategory == "31103") { ldConditionNine = ldConditionNine + balance; } else if (Subcategory == "31111" || Subcategory == "31112" || Subcategory == "31113" || Subcategory == "31114") { ldConditionTen = ldConditionTen + balance; } } catch { } } dr.Close(); } con.Close(); }