public static int SaveTasks(TasksDbModel Model) { var outParam = new SqlParameter(); outParam.ParameterName = "Id"; outParam.Value = Model.Id; outParam.SqlDbType = SqlDbType.BigInt; outParam.Direction = ParameterDirection.InputOutput; int result = 0; using (var Context = new CRMContext()) { Context.Database.ExecuteSqlCommand( "exec dbo.[usp_Sales_Tasks_Save] @Id OUT,@Subject,@Description,@StartDateTime,@EndDateTime," + "@TasksPriorityId,@TasksStatusId,@TasksRelatedTo,@CreatedBy,@IsActive", new Object[] { outParam, new SqlParameter("Subject", Model.Subject), new SqlParameter("Description", Model.Description), new SqlParameter("StartDateTime", Model.StartDateTime), new SqlParameter("EndDateTime", Model.EndDateTime), new SqlParameter("TasksPriorityId", Model.TasksPriorityId), new SqlParameter("TasksStatusId", Model.TasksStatusId), new SqlParameter("TasksRelatedTo", Model.TasksRelatedTo), new SqlParameter("CreatedBy", Model.CreatedBy), new SqlParameter("IsActive", Model.IsActive) } ); } result = Convert.ToInt32(outParam.Value); return(result); }
public static int SaveTaskLinks(TasksDbModel Model) { using (var Context = new CRMContext()) { return(Context.Database.ExecuteSqlCommand( "exec dbo.[usp_Sales_TaskLinks_Save] @Id,@TaskId,@LinkId,@LinkType", new Object[] { new SqlParameter("Id", Model.TaskLinkId), new SqlParameter("TaskId", Model.Id), new SqlParameter("LinkId", Model.LinkId), new SqlParameter("LinkType", (int)Model.LinkType) } )); } }