protected void btnDelete_Command(object sender, CommandEventArgs e)
{
try
{
string id = Convert.ToString(e.CommandArgument);
if (!string.IsNullOrEmpty(id))
{
BlogPostCategoryBLL blogPostCategoryBLL = new BlogPostCategoryBLL();
BlogPostCategories blogPostCategory = new BlogPostCategories();
blogPostCategory.BlogPostCategoryId = Convert.ToInt32(QuaintSecurityManager.Decrypt(id));
if (blogPostCategory.BlogPostCategoryId > 0)
{
if (blogPostCategoryBLL.Delete(blogPostCategory))
{
Alert(AlertType.Success, "Deleted successfully.");
LoadList();
}
else
{
Alert(AlertType.Error, "Failed to delete.");
}
}
}
}
catch (Exception)
{
Alert(AlertType.Error, "Failed to delete.");
}
}
public bool Delete(BlogPostCategories blogPostCategory)
{
QuaintDatabaseManager db = new QuaintDatabaseManager(true);
try
{
bool flag = false;
db.AddParameters("BlogPostCategoryId", blogPostCategory.BlogPostCategoryId);
int affectedRows = db.ExecuteNonQuery("Delete_BlogPostCategory", true);
if (affectedRows > 0)
{
flag = true;
}
return(flag);
}
catch (Exception)
{
throw;
}
finally
{
db.Disconnect();
}
}
private bool IsNameExist(BlogPostCategories blogPostCategory)
{
try
{
DataTable dtList = GetAll();
var rows = dtList.AsEnumerable().Where(x => ((string)x["Name"]).ToString() == blogPostCategory.Name);
DataTable dt = rows.Any() ? rows.CopyToDataTable() : dtList.Clone();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
protected void btnActiveOrDeactive_Command(object sender, CommandEventArgs e)
{
try
{
string id = Convert.ToString(e.CommandArgument);
if (!string.IsNullOrEmpty(id))
{
BlogPostCategoryBLL blogPostCategoryBLL = new BlogPostCategoryBLL();
DataTable dt = blogPostCategoryBLL.GetById(Convert.ToInt32(QuaintSecurityManager.Decrypt(id)));
if (dt != null)
{
if (dt.Rows.Count > 0)
{
string actionStatus = "Updated";
BlogPostCategories blogPostCategory = new BlogPostCategories();
blogPostCategory.BlogPostCategoryId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["BlogPostCategoryId"]));
blogPostCategory.BlogPostCategoryCode = Convert.ToString(dt.Rows[0]["BlogPostCategoryCode"]);
blogPostCategory.Name = Convert.ToString(dt.Rows[0]["Name"]);
blogPostCategory.Slag = Convert.ToString(dt.Rows[0]["Slag"]);
blogPostCategory.Description = Convert.ToString(dt.Rows[0]["Description"]);
blogPostCategory.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"]));
blogPostCategory.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"]));
blogPostCategory.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]);
blogPostCategory.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]);
blogPostCategory.UpdatedDate = DateTime.Now;
blogPostCategory.UpdatedBy = UserInfo;
blogPostCategory.UpdatedFrom = StationInfo;
if (blogPostCategory.IsActive)
{
blogPostCategory.IsActive = false;
actionStatus = "Deactivated";
}
else
{
blogPostCategory.IsActive = true;
actionStatus = "Activated";
}
if (blogPostCategoryBLL.Update(blogPostCategory))
{
Alert(AlertType.Success, actionStatus + " successfully.");
LoadList();
}
else
{
Alert(AlertType.Error, "Failed to update.");
}
}
}
}
}
catch (Exception)
{
Alert(AlertType.Error, "Failed to process.");
}
}
public bool Delete(BlogPostCategories blogPostCategory)
{
try
{
BlogPostCategoryDAL blogPostCategoryDAL = new BlogPostCategoryDAL();
return(blogPostCategoryDAL.Delete(blogPostCategory));
}
catch (Exception)
{
throw;
}
}
public bool Save(BlogPostCategories blogPostCategory)
{
try
{
BlogPostCategoryDAL blogPostCategoryDAL = new BlogPostCategoryDAL();
if (IsNameExist(blogPostCategory))
{
throw new Exception("Name already exist.");
}
else
{
return(blogPostCategoryDAL.Save(blogPostCategory));
}
}
catch (Exception)
{
throw;
}
}
public bool Update(BlogPostCategories blogPostCategory)
{
QuaintDatabaseManager db = new QuaintDatabaseManager(true);
try
{
bool flag = false;
db.AddParameters("BlogPostCategoryId", blogPostCategory.BlogPostCategoryId);
db.AddParameters("BlogPostCategoryCode", blogPostCategory.BlogPostCategoryCode);
db.AddParameters("Name", blogPostCategory.Name);
db.AddParameters("Slag", blogPostCategory.Slag);
db.AddParameters("Description", blogPostCategory.Description);
db.AddParameters("IsActive", blogPostCategory.IsActive);
db.AddParameters("CreatedDate", ((blogPostCategory.CreatedDate == null) ? blogPostCategory.CreatedDate : blogPostCategory.CreatedDate.Value));
db.AddParameters("CreatedBy", blogPostCategory.CreatedBy);
db.AddParameters("CreatedFrom", blogPostCategory.CreatedFrom);
db.AddParameters("UpdatedDate", ((blogPostCategory.UpdatedDate == null) ? blogPostCategory.UpdatedDate : blogPostCategory.UpdatedDate.Value));
db.AddParameters("UpdatedBy", blogPostCategory.UpdatedBy);
db.AddParameters("UpdatedFrom", blogPostCategory.UpdatedFrom);
int affectedRows = db.ExecuteNonQuery("Update_BlogPostCategory", true);
if (affectedRows > 0)
{
flag = true;
}
return(flag);
}
catch (Exception)
{
throw;
}
finally
{
db.Disconnect();
}
}
private void SaveAndUpdate()
{
try
{
if (string.IsNullOrEmpty(txtName.Text))
{
Alert(AlertType.Warning, "Enter blog post category name.");
txtName.Focus();
}
else
{
QuaintLibraryManager lib = new QuaintLibraryManager();
string name = Convert.ToString(txtName.Text);
string slug = lib.ConvertToSlug(name);
string description = Convert.ToString(txtDescription.Text);
BlogPostCategoryBLL blogPostCategoryBLL = new BlogPostCategoryBLL();
if (this.ModelId > 0)
{
DataTable dt = blogPostCategoryBLL.GetById(this.ModelId);
BlogPostCategories blogPostCategory = new BlogPostCategories();
blogPostCategory.BlogPostCategoryId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["BlogPostCategoryId"]));
blogPostCategory.BlogPostCategoryCode = Convert.ToString(dt.Rows[0]["BlogPostCategoryCode"]);
blogPostCategory.Name = Convert.ToString(dt.Rows[0]["Name"]);
blogPostCategory.Slag = Convert.ToString(dt.Rows[0]["Slag"]);
blogPostCategory.Description = Convert.ToString(dt.Rows[0]["Description"]);
blogPostCategory.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"]));
blogPostCategory.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"]));
blogPostCategory.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]);
blogPostCategory.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]);
blogPostCategory.Name = name.Trim();
blogPostCategory.Slag = slug;
blogPostCategory.Description = description;
blogPostCategory.UpdatedDate = DateTime.Now;
blogPostCategory.UpdatedBy = this.UserInfo;
blogPostCategory.UpdatedFrom = this.StationInfo;
if (blogPostCategoryBLL.Update(blogPostCategory))
{
this.MultiEntryDisallow = true;
Alert(AlertType.Success, "Updated successfully.");
ClearFields();
}
else
{
Alert(AlertType.Error, "Failed to update.");
}
}
else
{
BlogPostCategories blogPostCategory = new BlogPostCategories();
blogPostCategory.BlogPostCategoryCode = this.ModelCode;
blogPostCategory.Name = name.Trim();
blogPostCategory.Slag = slug;
blogPostCategory.Description = description;
blogPostCategory.IsActive = true;
blogPostCategory.CreatedDate = DateTime.Now;
blogPostCategory.CreatedBy = this.UserInfo;
blogPostCategory.CreatedFrom = this.StationInfo;
if (blogPostCategoryBLL.Save(blogPostCategory))
{
Alert(AlertType.Success, "Saved successfully.");
ClearFields();
GenerateCode();
}
else
{
Alert(AlertType.Error, "Failed to save.");
}
}
}
}
catch (Exception ex)
{
Alert(AlertType.Error, ex.Message.ToString());
}
}
