//END - create //BEGIN - update public void UpdateCustomercustomerdemo(CustomercustomerdemoSingle customercustomerdemo) { try // handle exogenous exceptions { try // log all exceptions { using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("spUpdateCustomercustomerdemo", con) { CommandType = CommandType.StoredProcedure }) { cmd.Parameters.AddWithValue("@CustomerID", customercustomerdemo.CustomerID); cmd.Parameters.AddWithValue("@CustomerTypeID", customercustomerdemo.CustomerTypeID); 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; } }
//END - delete //BEGIN - read public List <CustomercustomerdemoSingle> GetAllCustomercustomerdemos() { try // handle exogenous exceptions { try // log all exceptions { List <CustomercustomerdemoSingle> customercustomerdemos = new List <CustomercustomerdemoSingle>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spGetAllCustomercustomerdemo", con) { CommandType = CommandType.StoredProcedure }; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { CustomercustomerdemoSingle customercustomerdemo = new CustomercustomerdemoSingle { // EXAMPLES: //EmployeeId = Convert.ToInt32(rdr["EmployeeId"]), //Name = rdr["Name"].ToString(), //IsPermanent = (bool)rdr["IsPermanent"], //Salary = Convert.ToDecimal(rdr["Salary"]), //DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]) //CustomerID = (string)rdr["CustomerID"] CustomerID = rdr["CustomerID"] == DBNull.Value ? "" : (string)rdr["CustomerID"] //,CustomerTypeID = (string)rdr["CustomerTypeID"] , CustomerTypeID = rdr["CustomerTypeID"] == DBNull.Value ? "" : (string)rdr["CustomerTypeID"] }; customercustomerdemos.Add(customercustomerdemo); } con.Close(); cmd.Dispose(); } return(customercustomerdemos); } 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 CustomercustomerdemoSingle GetCustomercustomerdemoData(string CustomerID) { try // handle exogenous exceptions { try // log all exceptions { CustomercustomerdemoSingle customercustomerdemo = new CustomercustomerdemoSingle(); using (SqlConnection con = new SqlConnection(connectionString)) { string sqlQuery = "SELECT * FROM [CustomerCustomerDemo] WHERE CustomerID= '" + CustomerID.ToString() + "'"; using (SqlCommand cmd = new SqlCommand(sqlQuery, con)) { con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { //customercustomerdemo.CustomerID = (string)rdr["CustomerID"]; customercustomerdemo.CustomerID = rdr["CustomerID"] == DBNull.Value ? "" : (string)rdr["CustomerID"]; //customercustomerdemo.CustomerTypeID = (string)rdr["CustomerTypeID"]; customercustomerdemo.CustomerTypeID = rdr["CustomerTypeID"] == DBNull.Value ? "" : (string)rdr["CustomerTypeID"]; //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(customercustomerdemo); } 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 Create_Post() { try // handle exogenous exceptions { try // log all exceptions { CustomersBusinessModelLayers customersLUBusinessModelLayers = new CustomersBusinessModelLayers(); ViewBag.Customerss = new SelectList(customersLUBusinessModelLayers.CustomersSelect, "CustomerID", "CompanyName"); CustomerdemographicsBusinessModelLayers customerdemographicsLUBusinessModelLayers = new CustomerdemographicsBusinessModelLayers(); ViewBag.CustomerDemographicss = new SelectList(customerdemographicsLUBusinessModelLayers.CustomerdemographicsSelect, "CustomerTypeID", "CustomerDesc"); CustomercustomerdemoBusinessModelLayers customercustomerdemoBusinessModelLayers = new CustomercustomerdemoBusinessModelLayers(); BusinessModelLayer.CustomercustomerdemoSingle customercustomerdemo = new BusinessModelLayer.CustomercustomerdemoSingle(); TryUpdateModel(customercustomerdemo); if (ModelState.IsValid) { //mm customercustomerdemoBusinessModelLayers.AddCustomercustomerdemo(customercustomerdemo); return(RedirectToAction("List")); } else { return(View()); } } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }