An exception of type 'System.NotSupportedException' occurred

sangeetha k

8y1.2kLearn iOS Programming

#controller

public ActionResult Employee(int txtEmployeeId, string txtEmployeeName, string txtEmployeeDesignation, HttpPostedFileBase Empimage, double txtSalary, string txtEmployeeDpt, byte[] bytes)
{
EmployeeBusiness EmpBusiness = new EmployeeBusiness();
EmployeeEntity emp = new EmployeeEntity();
emp.Empid = Convert.ToInt32(txtEmployeeId);
emp.Empname = txtEmployeeName;
emp.Designation = txtEmployeeDesignation;
emp.Salary = Convert.ToDouble(txtSalary);
emp.Department = txtEmployeeDpt;
emp.Empimage = savetophysicallocation(Empimage);
EmpBusiness.saveEmployeeDetails(emp);
return View();
}
private string savetophysicallocation(HttpPostedFileBase Empimage)
{
if(Empimage.ContentLength>0){
var fileName=Path.GetFileName(Empimage.FileName);
var upload="~/C:/Users/sangeetha.k/Desktop/images";
var path = Path.Combine(Server.MapPath(upload), fileName);
Empimage.SaveAs(path);
return path;
}
return string.Empty;
}
}
}

#Business Layer

namespace EmployeeBusinessLayer
{
public class EmployeeBusiness
{
EmployeeDataAcess empdata = new EmployeeDataAcess();
public void saveEmployeeDetails(EmployeeEntity emp)
{
empdata.saveEmployeeDetails(emp);
}
}
}

#Data AccessLayer

public class EmployeeDataAcess
{
string ConnectionString = ConfigurationManager.ConnectionStrings["Employee"].ConnectionString;
AdventureWorksEntities EmpDbEntity = new AdventureWorksEntities();
tblEmployee EmployeeDbContext = new tblEmployee();
public void saveEmployeeDetails(EmployeeEntity emp)
{
using (AdventureWorksEntities EmpDbEntity = new AdventureWorksEntities())
{
tblEmployee EmployeeDbContext = null;
if(EmpDbEntity.tblEmployees==null)
{
EmployeeDbContext.Empid = emp.Empid;
EmployeeDbContext.Empname = emp.Empname;
EmployeeDbContext.Designation = emp.Designation;
EmployeeDbContext.Empimage = emp.Empimage;
EmployeeDbContext.Empimage = emp.Empimage;
EmployeeDbContext.Salary = emp.Salary;
EmployeeDbContext.Email = emp.Email;
EmployeeDbContext.Department = emp.Department;
}
if(EmpDbEntity.tblEmployees!=null)
{
EmployeeDbContext = EmpDbEntity.tblEmployees.Where(x => x.Empid == emp.Empid).FirstOrDefault();
}
}
}
}
}

and #entity Layer

public class EmployeeEntity
{
public int Empid { get; set; }
public string Empname { get; set; }
public string Designation { get; set; }
public string Empimage { get; set; }
public byte[] ImageData { get; set; }
public Nullable<double> Salary { get; set; }
public string Email { get; set; }
public string Department { get; set; }
//public EmployeeEntity()
//{
//}
//public EmployeeEntity(int Empid, string Empname, string Designation, string Empimage, byte[] ImageData, double Salary, string Email, string Department)
//{
// this.Empid = Empid;
// this.Empname = Empname;
// this.Designation = Designation;
// this.Empimage = Empimage;
// this.ImageData = ImageData;
// this.Salary = Salary;
// this.Email = Email;
// this.Department = Department;
}
}

#sql Table structure

Empid int

Empname nvarchar

Designation nvarchar

Empimage nvarchar

ImageData varbinary

Salary float

Email nvarchar

Department nvarchar

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

sangeetha k8y ago
but the grid is displayed but the image is not i am using the size of the image to fetch the image back to the screen but its not bringing
<tbody>
@foreach (var item in Model)
{
<tr>
<td scope="row">@Html.DisplayFor(model => item.Empid)td>
<td>@Html.DisplayFor(model => item.Empname)td>
<td>@Html.DisplayFor(model => item.Designation)td>
<td>@{
var base64 = Convert.ToBase64String(item.ImageData);
var imagesrc = String.Format("data:image/jpeg;base64,{0}", base64);
<img src='@imagesrc' style="max-width:100px;max-height:100px;" />
}td>
<td>@Html.DisplayFor(model => item.Salary)td>
<td>@Html.DisplayFor(model => item.Email)td>
<td>@Html.DisplayFor(model => item.Department)td>
tr>
}
tbody>
#Dal
try
{
using (AdventureWorksEntities empDbentity = new AdventureWorksEntities())
{
List emp = (from employee in EmpDbEntity.tblEmployees
select new EmployeeEntity
{
Empid = employee.Empid,
Empname = employee.Empname,
Designation = employee.Designation,
Empimage = employee.Empimage,
Salary = employee.Salary,
Email = employee.Email,
ImageData=employee.ImageData,
Department = employee.Department
}).ToList();
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = data;
//DataSet myrec=new DataSet();
//da.Fill(myrec);
//cmd.ExecuteNonQuery();
//return myrec;
return emp;
}
but it appears like this why is it like that
0
sangeetha k8y ago
@{
var base64 = Convert.ToBase64String(item.ImageData);
var imagesrc = String.Format("data:image/jpeg;base64,{0}", base64);

}
@Html.DisplayFor(model => item.Salary)
@Html.DisplayFor(model => item.Email)

this was the missing piece it worked
0
Ramesh Palanivel8y ago
Hi Sangeetha,

please share your html code for reference.
0
sangeetha k8y ago
db first approach and i am trying to save data into the datatable with along with an image but iam getting exception in path format y is it so?
0
Ramesh Palanivel8y ago
Hi Sangeetha,

As per my understanding you are trying to save your employee information on your employee table using above code .

Which approach you are using DB first approach or Code first approach?

please share your html code for reference
0
Sagar Pandurang Kap8y ago
Hi,
Refer below link :-

https://stackoverflow.com/questions/36432769/an-exception-of-type-system-notsupportedexception-thrown-in-asp-net-program

Hope it helps...
-1