public string SaveSubComponent(utblMstSubComponent model)
{
var parSubComponentID = new SqlParameter("@SubComponentID", model.SubComponentID);
var parSubComponentName = new SqlParameter("@SubComponentName", model.SubComponentName);
var parComponentID = new SqlParameter("@ComponentID", model.ComponentID);
var parTransDate = new SqlParameter("@TransDate", model.TransDate);
var parUserID = new SqlParameter("@UserID", model.UserID);
return(db.Database.SqlQuery <string>("udspSubComponentSave @SubComponentID,@SubComponentName, @ComponentID, @TransDate, @UserID",
parSubComponentID, parSubComponentName, parComponentID, parTransDate, parUserID).FirstOrDefault());
}
public string DeleteSubComponent(long id)
{
try
{
utblMstSubComponent model = db.utblMstSubComponents.Find(id);
db.utblMstSubComponents.Remove(model);
db.SaveChanges();
return("SubComponent Removed");
}
catch (Exception)
{
return("Error: Server error, try again later");
}
}
