private void Edit(int id)
{
try
{
InstituteBLL instituteBLL = new InstituteBLL();
DataTable dt = instituteBLL.GetById(id);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
this.ModelId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["InstituteId"]));
this.ModelCode = Convert.ToString(dt.Rows[0]["InstituteCode"]);
txtName.Text = Convert.ToString(dt.Rows[0]["Name"]);
imgLogo.Src = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["Logo"]))) ? "~/Assets/images/avater-public.png" : FilePath.Institute + Convert.ToString(dt.Rows[0]["Logo"]);
this.ModelLogo = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["Logo"]))) ? string.Empty : Convert.ToString(dt.Rows[0]["Logo"]);
txtUrl.Text = Convert.ToString(dt.Rows[0]["Url"]);
txtDescription.Text = Convert.ToString(dt.Rows[0]["Description"]);
txtSerialNumber.Text = Convert.ToString(dt.Rows[0]["SerialNumber"]);
ddlCourse.SelectedValue = Convert.ToString(dt.Rows[0]["CourseId"]);
}
}
}
catch (Exception)
{
Alert(AlertType.Error, "Failed to edit.");
}
}
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))
{
InstituteBLL instituteBLL = new InstituteBLL();
Institutes institute = new Institutes();
institute.InstituteId = Convert.ToInt32(QuaintSecurityManager.Decrypt(id));
if (institute.InstituteId > 0)
{
if (instituteBLL.Delete(institute))
{
Alert(AlertType.Success, "Deleted successfully.");
LoadList();
}
else
{
Alert(AlertType.Error, "Failed to delete.");
}
}
}
}
catch (Exception)
{
Alert(AlertType.Error, "Failed to delete.");
}
}
private void LoadList()
{
try
{
InstituteBLL instituteBLL = new InstituteBLL();
DataTable dt = instituteBLL.GetAll();
rptrList.DataSource = dt;
rptrList.DataBind();
}
catch (Exception)
{
//throw;
}
}
private void LoadTopInstitutes()
{
try
{
InstituteBLL instituteBLL = new InstituteBLL();
DataTable dt = instituteBLL.GetAllActiveTop();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
rptrTopInstitute.DataSource = dt;
rptrTopInstitute.DataBind();
}
}
}
catch (Exception)
{
//throw;
}
}
private void GenerateCode()
{
try
{
QuaintLibraryManager lib = new QuaintLibraryManager();
ModelCode = CodePrefix.Institute + "-" + lib.GetSixDigitNumber(1);
InstituteBLL instituteBLL = new InstituteBLL();
DataTable dt = instituteBLL.GetAll();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
string[] lastCode = dt.Rows[dt.Rows.Count - 1]["InstituteCode"].ToString().Split('-');
int lastCodeNumber = Convert.ToInt32(lastCode[1]);
ModelCode = CodePrefix.Institute + "-" + lib.GetSixDigitNumber(lastCodeNumber + 1);
}
}
}
catch (Exception)
{
Alert(AlertType.Error, "Failed to load.");
}
}
private void LoadList(int courseId)
{
try
{
InstituteBLL instituteBLL = new InstituteBLL();
DataTable dt = new DataTable();
if (courseId > 0)
{
dt = instituteBLL.GetByCourseId(courseId);
}
else
{
dt = instituteBLL.GetAllActive();
}
rptrList.DataSource = dt;
rptrList.DataBind();
}
catch (Exception)
{
//throw;
}
}
private void SaveAndUpdate()
{
try
{
if (string.IsNullOrEmpty(txtName.Text))
{
Alert(AlertType.Warning, "Enter institute name.");
txtName.Focus();
}
else if (string.IsNullOrEmpty(txtSerialNumber.Text))
{
Alert(AlertType.Warning, "Enter serial number");
txtSerialNumber.Focus();
}
else if (ddlCourse.SelectedIndex < 1)
{
Alert(AlertType.Warning, "Select course.");
ddlCourse.Focus();
}
else
{
string name = Convert.ToString(txtName.Text);
string url = Convert.ToString(txtUrl.Text);
string description = Convert.ToString(txtDescription.Text);
int serialNumber = Convert.ToInt32(txtSerialNumber.Text);
int courseId = Convert.ToInt32(ddlCourse.SelectedValue);
string logo = string.Empty;
if (fuLogo.HasFile)
{
logo = UploadLogo();
}
else
{
logo = this.ModelLogo;
}
InstituteBLL instituteBLL = new InstituteBLL();
if (this.ModelId > 0)
{
DataTable dt = instituteBLL.GetById(this.ModelId);
Institutes institute = new Institutes();
institute.InstituteId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["InstituteId"]));
institute.InstituteCode = Convert.ToString(dt.Rows[0]["InstituteCode"]);
institute.Name = Convert.ToString(dt.Rows[0]["Name"]);
institute.Logo = Convert.ToString(dt.Rows[0]["Logo"]);
institute.Url = Convert.ToString(dt.Rows[0]["Url"]);
institute.Description = Convert.ToString(dt.Rows[0]["Description"]);
institute.SerialNumber = Convert.ToInt32(dt.Rows[0]["SerialNumber"]);
institute.Attachment = Convert.ToString(dt.Rows[0]["Attachment"]);
institute.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"]));
institute.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"]));
institute.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]);
institute.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]);
institute.CourseId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CourseId"]));
institute.Name = name.Trim();
institute.Url = url;
institute.SerialNumber = serialNumber;
institute.CourseId = courseId;
institute.Logo = logo;
institute.UpdatedDate = DateTime.Now;
institute.UpdatedBy = this.UserInfo;
institute.UpdatedFrom = this.StationInfo;
if (instituteBLL.Update(institute))
{
this.MultiEntryDisallow = true;
Alert(AlertType.Success, "Updated successfully.");
ClearFields();
}
else
{
Alert(AlertType.Error, "Failed to update.");
}
}
else
{
Institutes institute = new Institutes();
institute.InstituteCode = this.ModelCode;
institute.Name = name;
institute.Logo = logo;
institute.Url = url;
institute.Description = description;
institute.SerialNumber = serialNumber;
institute.Attachment = string.Empty;
institute.CourseId = courseId;
institute.IsActive = true;
institute.CreatedDate = DateTime.Now;
institute.CreatedBy = this.UserInfo;
institute.CreatedFrom = this.StationInfo;
if (instituteBLL.Save(institute))
{
Alert(AlertType.Success, "Saved successfully.");
ClearFields();
GenerateCode();
}
else
{
Alert(AlertType.Error, "Failed to save.");
}
}
}
}
catch (Exception ex)
{
Alert(AlertType.Error, ex.Message.ToString());
}
}
protected void btnActiveOrDeactive_Command(object sender, CommandEventArgs e)
{
try
{
string id = Convert.ToString(e.CommandArgument);
if (!string.IsNullOrEmpty(id))
{
InstituteBLL instituteBLL = new InstituteBLL();
DataTable dt = instituteBLL.GetById(Convert.ToInt32(QuaintSecurityManager.Decrypt(id)));
if (dt != null)
{
if (dt.Rows.Count > 0)
{
string actionStatus = "Updated";
Institutes institute = new Institutes();
institute.InstituteId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["InstituteId"]));
institute.InstituteCode = Convert.ToString(dt.Rows[0]["InstituteCode"]);
institute.Name = Convert.ToString(dt.Rows[0]["Name"]);
institute.Logo = Convert.ToString(dt.Rows[0]["Logo"]);
institute.Url = Convert.ToString(dt.Rows[0]["Url"]);
institute.Description = Convert.ToString(dt.Rows[0]["Description"]);
institute.SerialNumber = Convert.ToInt32(dt.Rows[0]["SerialNumber"]);
institute.Attachment = Convert.ToString(dt.Rows[0]["Attachment"]);
institute.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"]));
institute.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"]));
institute.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]);
institute.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]);
institute.CourseId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CourseId"]));
institute.UpdatedDate = DateTime.Now;
institute.UpdatedBy = UserInfo;
institute.UpdatedFrom = StationInfo;
if (institute.IsActive)
{
institute.IsActive = false;
actionStatus = "Deactivated";
}
else
{
institute.IsActive = true;
actionStatus = "Activated";
}
if (instituteBLL.Update(institute))
{
Alert(AlertType.Success, actionStatus + " successfully.");
LoadList();
}
else
{
Alert(AlertType.Error, "Failed to update.");
}
}
}
}
}
catch (Exception)
{
Alert(AlertType.Error, "Failed to process.");
}
}