public string SaveComponent(utblMstComponent model)
{
var parComponentID = new SqlParameter("@ComponentID", model.ComponentID);
var parComponentName = new SqlParameter("@ComponentName", model.ComponentName);
var parCategoryID = new SqlParameter("@CategoryID", model.CompCategoryID);
var parUserID = new SqlParameter("@UserID", model.UserID);
return(db.Database.SqlQuery <string>("udspComponentSave @ComponentID,@ComponentName, @CategoryID, @UserID",
parComponentID, parComponentName, parCategoryID, parUserID).FirstOrDefault());
}
public string DeleteComponent(long id)
{
try
{
utblMstComponent model = db.utblMstComponents.Find(id);
db.utblMstComponents.Remove(model);
db.SaveChanges();
return("Component Removed");
}
catch (Exception)
{
return("Error: Server error, try again later");
}
}
