public ActionResult Create_Post() { try // handle exogenous exceptions { try // log all exceptions { CategoriesBusinessModelLayers categoriesBusinessModelLayers = new CategoriesBusinessModelLayers(); BusinessModelLayer.CategoriesSingle categories = new BusinessModelLayer.CategoriesSingle(); TryUpdateModel(categories); if (ModelState.IsValid) { //mm categoriesBusinessModelLayers.AddCategories(categories); return(RedirectToAction("List")); } else { return(View()); } } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
//END - readBy //BEGIN - create public void AddCategories(CategoriesSingle categories) { try // handle exogenous exceptions { try // log all exceptions { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spAddCategories", con) { CommandType = CommandType.StoredProcedure }; SqlParameter paramCategoryID = new SqlParameter { ParameterName = "@CategoryID", Value = categories.CategoryID }; cmd.Parameters.Add(paramCategoryID); SqlParameter paramCategoryName = new SqlParameter { ParameterName = "@CategoryName", Value = categories.CategoryName }; cmd.Parameters.Add(paramCategoryName); SqlParameter paramDescription = new SqlParameter { ParameterName = "@Description", Value = categories.Description }; cmd.Parameters.Add(paramDescription); SqlParameter paramPicture = new SqlParameter { ParameterName = "@Picture", Value = categories.Picture }; cmd.Parameters.Add(paramPicture); con.Open(); cmd.ExecuteNonQuery(); cmd.Dispose(); } } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); //errResult = "A Technical Error occurred, Please visit after some time."; throw; } } catch (Exception fx) { errResult = fx.Message.ToString(); throw; } }
//BEGIN - readBy public CategoriesSingle GetCategoriesData(int CategoryID) { try // handle exogenous exceptions { try // log all exceptions { CategoriesSingle categories = new CategoriesSingle(); using (SqlConnection con = new SqlConnection(connectionString)) { string sqlQuery = "SELECT * FROM [Categories] WHERE CategoryID= " + CategoryID.ToString(); using (SqlCommand cmd = new SqlCommand(sqlQuery, con)) { con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { //categories.CategoryID = (int)rdr["CategoryID"]; categories.CategoryID = rdr["CategoryID"] == DBNull.Value ? default(int) : (int)rdr["CategoryID"]; //categories.CategoryName = (string)rdr["CategoryName"]; categories.CategoryName = rdr["CategoryName"] == DBNull.Value ? "" : (string)rdr["CategoryName"]; //categories.Description = (string)rdr["Description"]; categories.Description = rdr["Description"] == DBNull.Value ? "" : (string)rdr["Description"]; //categories.Picture = (byte[])rdr["Picture"]; categories.Picture = rdr["Picture"] == DBNull.Value ? default(byte[]) : (byte[])rdr["Picture"]; //EXAMPLES: //employee.EmployeeId = Convert.ToInt32(rdr["EmployeeID"]); //employee.Name = rdr["Name"].ToString(); //employee.Gender = rdr["Gender"].ToString(); //employee.Salary = (decimal)rdr["Salary"]; //employee.City = rdr["City"].ToString(); //employee.IsPermanent = (bool)rdr["IsPermanent"]; //employee.DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]); } } } return(categories); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); //errResult = "A Technical Error occurred, Please visit after some time."; throw; } } catch (Exception fx) { errResult = fx.Message.ToString(); throw; } }
//END - create //BEGIN - update public void UpdateCategories(CategoriesSingle categories) { try // handle exogenous exceptions { try // log all exceptions { using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("spUpdateCategories", con) { CommandType = CommandType.StoredProcedure }) { cmd.Parameters.AddWithValue("@CategoryID", categories.CategoryID); cmd.Parameters.AddWithValue("@CategoryName", categories.CategoryName); cmd.Parameters.AddWithValue("@Description", (object)categories.Description ?? DBNull.Value); cmd.Parameters.AddWithValue("@Picture", (object)categories.Picture ?? DBNull.Value); con.Open(); cmd.ExecuteNonQuery(); } con.Close(); } } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); //errResult = "A Technical Error occurred, Please visit after some time."; throw; } } catch (Exception fx) { errResult = fx.Message.ToString(); throw; } }
public ActionResult Details(int CategoryID) { try // handle exogenous exceptions { try // log all exceptions { CategoriesBusinessModelLayers categoriesBusinessModelLayers = new CategoriesBusinessModelLayers(); BusinessModelLayer.CategoriesSingle categories = categoriesBusinessModelLayers.GetAllCategoriess().FirstOrDefault(x => x.CategoryID == CategoryID); return(View(categories)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
//END - delete //BEGIN - read public List <CategoriesSingle> GetAllCategoriess() { try // handle exogenous exceptions { try // log all exceptions { List <CategoriesSingle> categoriess = new List <CategoriesSingle>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spGetAllCategories", con) { CommandType = CommandType.StoredProcedure }; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { CategoriesSingle categories = new CategoriesSingle { // EXAMPLES: //EmployeeId = Convert.ToInt32(rdr["EmployeeId"]), //Name = rdr["Name"].ToString(), //IsPermanent = (bool)rdr["IsPermanent"], //Salary = Convert.ToDecimal(rdr["Salary"]), //DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]) //CategoryID = (int)rdr["CategoryID"] CategoryID = rdr["CategoryID"] == DBNull.Value ? default(int) : (int)rdr["CategoryID"] //,CategoryName = (string)rdr["CategoryName"] , CategoryName = rdr["CategoryName"] == DBNull.Value ? "" : (string)rdr["CategoryName"] //,Description = (string)rdr["Description"] , Description = rdr["Description"] == DBNull.Value ? "" : (string)rdr["Description"] //,Picture = (byte[])rdr["Picture"] , Picture = rdr["Picture"] == DBNull.Value ? default(byte[]) : (byte[])rdr["Picture"] }; categoriess.Add(categories); } con.Close(); cmd.Dispose(); } return(categoriess); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); //errResult = "A Technical Error occurred, Please visit after some time."; throw; } } catch (Exception fx) { errResult = fx.Message.ToString(); throw; } }