public bool insertAndUpdate(CategoriesBLL c)
{
bool isSuccess = false;
try
{
SqlCommand cmd = new SqlCommand("USP_InsertCategoriesDetails", AppManager.ConnectionManager);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("id", SqlDbType.Int).Value = c.id;
cmd.Parameters.Add("title", SqlDbType.VarChar).Value = c.title;
cmd.Parameters.Add("description", SqlDbType.VarChar).Value = c.description;
cmd.Parameters.Add("added_date", SqlDbType.DateTime).Value = c.added_date;
cmd.Parameters.Add("added_by", SqlDbType.Int).Value = c.added_by;
int row = cmd.ExecuteNonQuery();
if (row > 0)
{
isSuccess = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(isSuccess);
}
public bool Delete(CategoriesBLL b)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(this.connect.connection);
try
{
string sql = "DELETE FROM [dbo].[tblcategories]" +
" WHERE id = @id";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@id", b.ID);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(isSuccess);
}
public MainForm()
{
InitializeComponent();
productBLL = new ProductBLL();
categoriesBLL = new CategoriesBLL();
txtId.ReadOnly = true;
txtCateId.ReadOnly = true;
}
public bool Update(CategoriesBLL c)
{
bool isSuccess = false;
//Creating SQL connection
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Sql query to update
String sql = "UPDATE tbl_categories SET title=@title,description=@description,added_date=@added_date,added_by=@added_by WHERE id=@id";
//Sql command to pass the value on sql query
SqlCommand cmd = new SqlCommand(sql, conn);
//Passing the value using command
cmd.Parameters.AddWithValue("@title", c.title);
cmd.Parameters.AddWithValue("@description", c.description);
cmd.Parameters.AddWithValue("@added_date", c.added_date);
cmd.Parameters.AddWithValue("@added_by", c.added_by);
cmd.Parameters.AddWithValue("@id", c.id);
conn.Open();
//Create int variable to count executing query
int rows = cmd.ExecuteNonQuery();
//Checking the count whether greater than 0 or not
if (rows > 0)
{
//Query successful
isSuccess = true;
}
else
{
//Query failed
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
protected void Categories_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Determine the PDF path for the category being deleted...
int categoryID = Convert.ToInt32(e.Keys["CategoryID"]);
CategoriesBLL categoryAPI = new CategoriesBLL();
Northwind.CategoriesDataTable categories = categoryAPI.GetCategoryByCategoryID(categoryID);
Northwind.CategoriesRow category = categories[0];
if (category.IsBrochurePathNull())
deletedCategorysPdfPath = null;
else
deletedCategorysPdfPath = category.BrochurePath;
}
public bool Insert(CategoriesBLL c)
{
bool isSuccess = false;
//Sql connection
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Query to add new category
String sql = "INSERT INTO tbl_categories (title,description,added_date,added_by) VALUES(@title,@description,@added_date,@added_by)";
SqlCommand cmd = new SqlCommand(sql, conn);
//Passing values through parameters
cmd.Parameters.AddWithValue("@title", c.title);
cmd.Parameters.AddWithValue("@description", c.description);
cmd.Parameters.AddWithValue("@added_date", c.added_date);
cmd.Parameters.AddWithValue("@added_by", c.added_by);
//Open dtabase connection
conn.Open();
//creating a int variable to count Executing sql query
int rows = cmd.ExecuteNonQuery();
//Checking rows count
if (rows > 0)
{
//Query successfull
isSuccess = true;
}
else
{
//Query Failed..
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Delete(CategoriesBLL c)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Query to delete from database
String sql = "DELETE FROM tbl_categories WHERE id=@id";
SqlCommand cmd = new SqlCommand(sql, conn);
//Passing the values using command
cmd.Parameters.AddWithValue("@id", c.id);
//Open sql connection
conn.Open();
//Count Query Executing
int rows = cmd.ExecuteNonQuery();
//If the query is executed successfully, the value of rows will be greater than 0 else less than 0
if (rows > 0)
{
//Query Success
isSuccess = true;
}
else
{
//Query failed
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
protected void Page_Load(object sender, EventArgs e)
{
int categoryID = Convert.ToInt32(Request.QueryString["CategoryID"]);
// Get information about the specified category
CategoriesBLL categoryAPI = new CategoriesBLL();
Northwind.CategoriesDataTable categories = categoryAPI.GetCategoryWithBinaryDataByCategoryID(categoryID);
Northwind.CategoriesRow category = categories[0];
// For new categories, images are JPGs...
// Output HTTP headers providing information about the binary data
Response.ContentType = "image/jpeg";
// Output the binary data
Response.BinaryWrite(category.Picture);
}
public bool Insert(CategoriesBLL b)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(this.connect.connection);
try
{
string sql = "INSERT INTO [dbo].[tblcategories]" +
"([title]" +
",[description]" +
",[addeddate]" +
",[addedby])" +
"VALUES" +
"(@title," +
" @description," +
"@addeddate," +
"@addedby)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@title", b.Title);
cmd.Parameters.AddWithValue("@description", b.Description);
cmd.Parameters.AddWithValue("@addeddate", b.AddedDate);
cmd.Parameters.AddWithValue("@addedby", b.AddedBy);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(isSuccess);
}
public bool Update(CategoriesBLL b)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(this.connect.connection);
try
{
string sql = "UPDATE [dbo].[tblcategories]" +
"SET[title] = @title," +
"[description] = @description," +
"[addeddate] = @addeddate," +
"[addedby] = @addedby" +
"WHERE id =@id";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@title", b.Title);
cmd.Parameters.AddWithValue("@description", b.Description);
cmd.Parameters.AddWithValue("@addeddate", b.AddedDate);
cmd.Parameters.AddWithValue("@addedby", b.AddedBy);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(isSuccess);
}
public bool delete(CategoriesBLL c)
{
bool isSuccess = false;
try
{
SqlCommand cmd = new SqlCommand("USP_DeleteCategories", AppManager.ConnectionManager);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("id", SqlDbType.Int).Value = c.id;
int row = cmd.ExecuteNonQuery();
if (row > 0)
{
isSuccess = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(isSuccess);
}
// GET: Admin/Categories
public CategoriesController()
{
bll = new CategoriesBLL();
}
protected void Categories_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// Reference the PictureUpload FileUpload
FileUpload PictureUpload = (FileUpload)Categories.Rows[e.RowIndex].FindControl("PictureUpload");
if (PictureUpload.HasFile)
{
// Make sure the picture upload is valid
if (ValidPictureUpload(PictureUpload))
{
e.NewValues["picture"] = PictureUpload.FileBytes;
}
else
{
// Invalid file upload, cancel update and exit event handler
e.Cancel = true;
return;
}
}
// Reference the RadioButtonList
RadioButtonList BrochureOptions = (RadioButtonList)Categories.Rows[e.RowIndex].FindControl("BrochureOptions");
// Get BrochurePath information about the record being updated
int categoryID = Convert.ToInt32(e.Keys["CategoryID"]);
CategoriesBLL categoryAPI = new CategoriesBLL();
Northwind.CategoriesDataTable categories = categoryAPI.GetCategoryByCategoryID(categoryID);
Northwind.CategoriesRow category = categories[0];
if (BrochureOptions.SelectedValue == "1")
{
// Use current value for BrochurePath
if (category.IsBrochurePathNull())
e.NewValues["brochurePath"] = null;
else
e.NewValues["brochurePath"] = category.BrochurePath;
}
else if (BrochureOptions.SelectedValue == "2")
{
// Remove the current brochure (set it to NULL in the database)
e.NewValues["brochurePath"] = null;
}
else if (BrochureOptions.SelectedValue == "3")
{
// Reference the BrochurePath FileUpload control
FileUpload BrochureUpload = (FileUpload)Categories.Rows[e.RowIndex].FindControl("BrochureUpload");
// Process the BrochureUpload
bool cancelOperation = false;
e.NewValues["brochurePath"] = ProcessBrochureUpload(BrochureUpload, out cancelOperation);
e.Cancel = cancelOperation;
}
else
{
// Unknown value!
throw new ApplicationException(string.Format("Invalid BrochureOptions value, {0}", BrochureOptions.SelectedValue));
}
if (BrochureOptions.SelectedValue == "2" || BrochureOptions.SelectedValue == "3")
{
// "Remember" that we need to delete the old PDF file
if (category.IsBrochurePathNull())
deletedCategorysPdfPath = null;
else
deletedCategorysPdfPath = category.BrochurePath;
}
}
public void ProcessRequest(HttpContext context)
{
var json = new StreamReader(context.Request.InputStream).ReadToEnd();
var responseMsg = new Dictionary <string, string>();
bool isUpdate = false;
int Records = 0;
int AssignCategoryID = 0;
string TableName = "";
string Search = "";
string Order = "";
int PageNumnber = 0;
var _categoryobj = new CategoriesBLL();
var _ld_categories_json = JsonConvert.DeserializeObject <Category_Struct_V2>(json);
var _ld_post_data = new Dictionary <string, CategoryObject>();
if ((context.Request.Params["action"] != null))
{
switch (context.Request.Params["action"])
{
case "process":
var cat = JsonConvert.DeserializeObject <Category_Struct_V2>(json);
isUpdate = false;
if (context.Request.Params["isupdate"] != null)
{
isUpdate = Convert.ToBoolean(context.Request.Params["isupdate"]);
isUpdate = true;
}
if (isUpdate)
{
CategoriesBLL.Process(cat, isUpdate);
}
context.Response.Write(responseMsg);
break;
case "delete":
var _delcategory = JsonConvert.DeserializeObject <Category_Struct>(json);
if (context.Request.Params["assigncategoryid"] != null)
{
AssignCategoryID = Convert.ToInt32(context.Request.Params["assigncategoryid"]);
CategoriesBLL.Delete(_delcategory.ID, AssignCategoryID);
}
else
{
CategoriesBLL.Delete(_delcategory.ID);
}
break;
// This update is only for pubplishing pending videos (unpublished videos only)
case "update_category":
// Authentication
if (!context.User.Identity.IsAuthenticated)
{
responseMsg["status"] = "error";
responseMsg["message"] = "Authentication Failed";
context.Response.Write(responseMsg);
return;
}
if (context.Request.Params["assigncategoryid"] != null)
{
AssignCategoryID = Convert.ToInt32(context.Request.Params["assigncategoryid"]);
}
if (context.Request.Params["tablename"] != null)
{
TableName = context.Request.Params["tablename"].ToString();
}
CategoriesBLL.Update_Category(JsonConvert.DeserializeObject <Category_Struct_V2>(json).CategoryID, AssignCategoryID, TableName);
responseMsg["status"] = "success";
responseMsg["message"] = "Operation Commit";
context.Response.Write(responseMsg);
break;
case "load_categories":
bool isAll = false;
if (context.Request.Params["isall"] != null)
{
isAll = Convert.ToBoolean(context.Request.Params["isall"]);
}
var _query = JsonConvert.DeserializeObject <Category_Struct_V2>(json);
var _lst_sm = CategoriesBLL.Load_CategoriesSummary(_query.CategoryID, _query.Type, isAll, _query.isPrivate, _query.Mode, "categoryname asc", _query.Records, 1);
var _vObject = new CategoryObject()
{
Data = _lst_sm,
Count = CategoriesBLL.Count_CategoriesSummary(_query.Type, _query.isPrivate, _query.Mode)
};
context.Response.Write(_vObject);
break;
case "fetch_category_names":
CategoriesBLL.Fetch_Category_Names(_ld_categories_json.Type);
responseMsg["status"] = "success";
//context.Response.Write(responseMsg);
break;
}
}
else
{
// No action found
responseMsg["status"] = "error";
responseMsg["message"] = "No action found";
context.Response.Write(JsonConvert.SerializeObject(responseMsg));
}
}
