private void LoadCounter() { try { InstituteBLL instituteBLL = new InstituteBLL(); DataTable dtInstitute = instituteBLL.GetAllActive(); lblTotalUniversity.Text = Convert.ToString(dtInstitute.Rows.Count); LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dtLenderBank = lenderBankBLL.GetAllActive(); lblTotalBank.Text = Convert.ToString(dtLenderBank.Rows.Count); CourseBLL courseBLL = new CourseBLL(); DataTable dtCourse = courseBLL.GetAllActive(); lblTotalCourse.Text = Convert.ToString(dtCourse.Rows.Count); BlogPostBLL blogPostBLL = new BlogPostBLL(); DataTable dtBlogPost = blogPostBLL.GetAllActive(); lblTotalBlogPost.Text = Convert.ToString(dtBlogPost.Rows.Count); UserBLL userBLL = new UserBLL(); DataTable dtUser = userBLL.GetAllActiveMember(); lblTotalMember.Text = Convert.ToString(dtUser.Rows.Count); } catch (Exception) { //throw; } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { try { string id = Convert.ToString(e.CommandArgument); if (!string.IsNullOrEmpty(id)) { LenderBankBLL lenderBankBLL = new LenderBankBLL(); LenderBanks lenderBank = new LenderBanks(); lenderBank.LenderBankId = Convert.ToInt32(QuaintSecurityManager.Decrypt(id)); if (lenderBank.LenderBankId > 0) { if (lenderBankBLL.Delete(lenderBank)) { Alert(AlertType.Success, "Deleted successfully."); LoadList(); } else { Alert(AlertType.Error, "Failed to delete."); } } } } catch (Exception) { Alert(AlertType.Error, "Failed to delete."); } }
protected void btnActiveOrDeactive_Command(object sender, CommandEventArgs e) { try { string id = Convert.ToString(e.CommandArgument); if (!string.IsNullOrEmpty(id)) { LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dt = lenderBankBLL.GetById(Convert.ToInt32(QuaintSecurityManager.Decrypt(id))); if (dt != null) { if (dt.Rows.Count > 0) { string actionStatus = "Updated"; LenderBanks lenderBank = new LenderBanks(); lenderBank.LenderBankId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["LenderBankId"])); lenderBank.LenderBankCode = Convert.ToString(dt.Rows[0]["LenderBankCode"]); lenderBank.BankName = Convert.ToString(dt.Rows[0]["BankName"]); lenderBank.Url = Convert.ToString(dt.Rows[0]["Url"]); lenderBank.Description = Convert.ToString(dt.Rows[0]["Description"]); lenderBank.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"])); lenderBank.CountryId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CountryId"])); lenderBank.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"])); lenderBank.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]); lenderBank.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]); lenderBank.UpdatedDate = DateTime.Now; lenderBank.UpdatedBy = UserInfo; lenderBank.UpdatedFrom = StationInfo; if (lenderBank.IsActive) { lenderBank.IsActive = false; actionStatus = "Deactivated"; } else { lenderBank.IsActive = true; actionStatus = "Activated"; } if (lenderBankBLL.Update(lenderBank)) { Alert(AlertType.Success, actionStatus + " successfully."); LoadList(); } else { Alert(AlertType.Error, "Failed to update."); } } } } } catch (Exception) { Alert(AlertType.Error, "Failed to process."); } }
private void LoadList() { try { LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dt = lenderBankBLL.GetAll(); rptrList.DataSource = dt; rptrList.DataBind(); } catch (Exception) { //throw; } }
private void GenerateCode() { try { QuaintLibraryManager lib = new QuaintLibraryManager(); this.ModelCode = CodePrefix.Bank + "-" + lib.GetSixDigitNumber(1); LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dt = lenderBankBLL.GetAll(); if (dt != null) { if (dt.Rows.Count > 0) { string[] lastCode = dt.Rows[dt.Rows.Count - 1]["LenderBankCode"].ToString().Split('-'); int lastCodeNumber = Convert.ToInt32(lastCode[1]); this.ModelCode = CodePrefix.Bank + "-" + lib.GetSixDigitNumber(lastCodeNumber + 1); } } } catch (Exception) { Alert(AlertType.Error, "Failed to load."); } }
private void LoadList(int countryId) { try { LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dt = new DataTable(); if (countryId > 0) { dt = lenderBankBLL.GetByCountryId(countryId); } else { dt = lenderBankBLL.GetAllActive(); } rptrList.DataSource = dt; rptrList.DataBind(); } catch (Exception) { //throw; } }
private void LoadDashboardInfo() { try { //Total Member UserBLL userBLL = new UserBLL(); DataTable dtUser = userBLL.GetAllActive(); lblTotalMember.Text = (dtUser == null) ? "0" : Convert.ToString(Convert.ToInt32(dtUser.Rows.Count)); //Total University //InstituteBLL instituteBLL = new InstituteBLL(); //DataTable dtInstitute = instituteBLL.GetAllActive(); RankingBLL rankingBLL = new RankingBLL(); DataTable dtRanking = rankingBLL.GetAllActive(); lblTotalUniversity.Text = (dtRanking == null) ? "0" : Convert.ToString(dtRanking.Rows.Count); //Total Course CourseBLL courseBLL = new CourseBLL(); DataTable dtCourse = courseBLL.GetAllActive(); lblTotalCourse.Text = (dtCourse == null) ? "0" : Convert.ToString(dtCourse.Rows.Count); //Total Bank LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dtLenderBank = lenderBankBLL.GetAllActive(); lblTotalBank.Text = (dtLenderBank == null) ? "0" : Convert.ToString(dtLenderBank.Rows.Count); //Total Blog Post BlogPostBLL blogPostBLL = new BlogPostBLL(); DataTable dtBlogPost = blogPostBLL.GetAllActive(); lblTotalBlogPost.Text = (dtBlogPost == null) ? "0" : Convert.ToString(dtBlogPost.Rows.Count); } catch (Exception) { //throw; } }
private void Edit(int id) { try { LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dt = lenderBankBLL.GetById(id); if (dt != null) { if (dt.Rows.Count > 0) { this.ModelId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["LenderBankId"])); this.ModelCode = Convert.ToString(dt.Rows[0]["LenderBankCode"]); txtBankName.Text = Convert.ToString(dt.Rows[0]["BankName"]); txtUrl.Text = Convert.ToString(dt.Rows[0]["Url"]); txtDescription.Text = Convert.ToString(dt.Rows[0]["Description"]); ddlCountry.SelectedValue = Convert.ToString(dt.Rows[0]["CountryId"]); } } } catch (Exception) { Alert(AlertType.Error, "Failed to edit."); } }
private void SaveAndUpdate() { try { if (string.IsNullOrEmpty(txtBankName.Text)) { Alert(AlertType.Warning, "Enter bank name."); txtBankName.Focus(); } else if (ddlCountry.SelectedIndex < 1) { Alert(AlertType.Warning, "Select country"); ddlCountry.Focus(); } else { string bankName = Convert.ToString(txtBankName.Text); string url = Convert.ToString(txtUrl.Text); string description = Convert.ToString(txtDescription.Text); int countryId = Convert.ToInt32(Convert.ToString(ddlCountry.SelectedValue)); LenderBankBLL lenderBankBLL = new LenderBankBLL(); if (this.ModelId > 0) { DataTable dt = lenderBankBLL.GetById(this.ModelId); LenderBanks lenderBank = new LenderBanks(); lenderBank.LenderBankId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["LenderBankId"])); lenderBank.LenderBankCode = Convert.ToString(dt.Rows[0]["LenderBankCode"]); lenderBank.BankName = Convert.ToString(dt.Rows[0]["BankName"]); lenderBank.Url = Convert.ToString(dt.Rows[0]["Url"]); lenderBank.Description = Convert.ToString(dt.Rows[0]["Description"]); lenderBank.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"])); lenderBank.CountryId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CountryId"])); lenderBank.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"])); lenderBank.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]); lenderBank.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]); lenderBank.BankName = bankName.Trim(); lenderBank.Url = url; lenderBank.Description = description; lenderBank.CountryId = countryId; lenderBank.UpdatedDate = DateTime.Now; lenderBank.UpdatedBy = this.UserInfo; lenderBank.UpdatedFrom = this.StationInfo; if (lenderBankBLL.Update(lenderBank)) { this.MultiEntryDisallow = true; Alert(AlertType.Success, "Updated successfully."); ClearFields(); } else { Alert(AlertType.Error, "Failed to update."); } } else { LenderBanks lenderBank = new LenderBanks(); lenderBank.LenderBankCode = this.ModelCode; lenderBank.BankName = bankName.Trim(); lenderBank.Url = url; lenderBank.Description = description; lenderBank.CountryId = countryId; lenderBank.IsActive = true; lenderBank.CreatedDate = DateTime.Now; lenderBank.CreatedBy = this.UserInfo; lenderBank.CreatedFrom = this.StationInfo; if (lenderBankBLL.Save(lenderBank)) { Alert(AlertType.Success, "Saved successfully."); ClearFields(); GenerateCode(); } else { Alert(AlertType.Error, "Failed to save."); } } } } catch (Exception ex) { Alert(AlertType.Error, ex.Message.ToString()); } }