hi all,
i hv a piece of code , please go thru the below code and help me how to save image into database.
Backend:
=====
create table Employee(empid int primary key,name varchar(max),age int,gender varchar(max),designation varchar(max),mobile int,image varbinary(max))
Csharp code:
========
Emp.cs:
=====
public class Emp
{
public int ID { get; set; }
public string Name { get; set; }
public int Age { get; set; }
public DateTime DOB { get; set; }
public string Gender { get; set; }
public byte[] image { get; set; }
public string Designation { get; set; }
public string Mobile { get; set; }
}
======== DAL logic:
----------
public void SaveEmp(Emp emp)
{
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection con = new SqlConnection(cs);
con.Open();
string save = "insert into Employee values(@empid, @name, @age,@designation, @mobile,@gender,@dob)";
SqlCommand cmd = new SqlCommand(save, con);
cmd.Parameters.AddWithValue("@empid", emp.ID);
cmd.Parameters.AddWithValue("@name", emp.Name);
cmd.Parameters.AddWithValue("@age", emp.Age);
cmd.Parameters.AddWithValue("@designation", emp.Designation);
cmd.Parameters.AddWithValue("@mobile", emp.Mobile);
cmd.Parameters.AddWithValue("@gender", emp.Gender);
cmd.Parameters.AddWithValue("@dob", emp.DOB);
cmd.Parameters.AddWithValue("@dob", emp.Image);
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdateEmp(Emp emp)
{
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection con = new SqlConnection(cs);
con.Open();
sstring update = "update Employee set name=@name, age=@age,designation=@designation, mobile=@mobile,gender=@gender,dob=@dob ,image=@image where empid=@empid";
SqlCommand cmd = new SqlCommand(save, con);
cmd.Parameters.AddWithValue("@empid", emp.ID);
cmd.Parameters.AddWithValue("@name", emp.Name);
cmd.Parameters.AddWithValue("@age", emp.Age);
cmd.Parameters.AddWithValue("@designation", emp.Designation);
cmd.Parameters.AddWithValue("@mobile", emp.Mobile);
cmd.Parameters.AddWithValue("@gender", emp.Gender);
cmd.Parameters.AddWithValue("@dob", emp.DOB);
cmd.Parameters.AddWithValue("@dob", emp.Image);
cmd.ExecuteNonQuery();
con.Close();
}
public void DeleteEmp(Emp emp)
{
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection con = new SqlConnection(cs);
con.Open();
string delete = "delete from Employee where empid=@empid";
SqlCommand cmd = new SqlCommand(delete, con);
cmd.Parameters.AddWithValue("@empid", emp.ID);
cmd.ExecuteNonQuery();
con.Close();
}
Home Controller.cs:
=================
Except image i wrote remaining code,Can anybody write the logic for image in HomeController and Index.cshtml page.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using AngularUiGrid.Models;
using System.Globalization;
namespace AngularUiGrid.Controllers
{
public class HomeController : Controller
{
// GET: Home
public ActionResult Index()
{
return View();
}
public JsonResult GetAllEmployee()
{
DALEmp empdal = new DALEmp();
List employee = empdal.ListAll().ToList();
return Json(employee, JsonRequestBehavior.AllowGet);
}
[HttpPost]
public ActionResult Create(Emp employee, int pday, int pmonth, int pyear)
{
try
{
if (ModelState.ContainsKey("dob"))
{
if (ModelState["dob"].Errors.Count > 0)
{
ModelState["dob"].Errors.Clear();
}
}
employee.DOB = new DateTime(pyear, pmonth, pday);
if (ModelState.IsValid)
{
DALEmp empdal = new DALEmp();
empdal.SaveEmp(employee);
return RedirectToAction("Index");
}
else
{
ModelState.AddModelError("", "Data Not Saved");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return View();
}
[HttpPost]
public ActionResult Edit(Emp emp, int pday, int pmonth, int pyear)
{
#region Update
try
{
if (ModelState.ContainsKey("dob"))
{
if (ModelState["dob"].Errors.Count > 0)
{
ModelState["dob"].Errors.Clear();
}
}
emp.DOB = new DateTime(pyear, pmonth, pday);
if (ModelState.IsValid)
{
DALEmp empdal = new DALEmp();
empdal.Update(emp);
return RedirectToAction("Index");
}
else
{
ModelState.AddModelError("", "Record is not Updated");
return View();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return View();
#endregion
}
[HttpPost]
public ActionResult Delete(Emp emp)
{
#region Delete
try
{
if (ModelState.IsValid)
{
DALEmp empdal = new DALEmp();
empdal.DeleteEmp(emp);
return RedirectToAction("Index");
}
else
{
ModelState.AddModelError("", "Record is not Deleted");
return View();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return View();
#endregion
}
public ActionResult Details()
{
return View();
}
}
}
Index.cshtml code:
===========
AngularJS UI Grid
@*ui-grid-pagination provides paging style for grid. if we remove it then paging cannot displayed*@
Save Details
@Html.TextBox("Id", string.Empty, new { @class = "ControlWidth", ng_model = "id" }) | |||
@Html.TextBox("Name", string.Empty, new { @class = "ControlWidth", ng_model = "name" }) | |||
@Html.TextBox("Age", string.Empty, new { @class = "ControlWidth", ng_model = "age", ng_keypress = "onlyNumbers($event)", type = "number", min = "1", max = "100" }) | |||
@Html.TextBox("DOB", string.Empty, new { @class = "ControlWidth", ng_model = "dob" }) | |||
@Html.DropDownList("Gender", new List new SelectListItem {Text="Female",Value="Female"}}, "--Select List--", new { @class = "ControlWidth", ng_model = "gender" }) | |||
@Html.TextBox("Designation", string.Empty, new { @class = "ControlWidth", ng_model = "designation" }) | |||
@Html.TextBox("Mobile", string.Empty, new { @class = "ControlWidth", ng_model = "mobile" }) | |||
Regards,
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manoj BhoirPosted May 19, 2019, 2:12 AM
Satyaprakash SamantarayPosted Aug 16, 2017, 7:31 AM