public static int SaveNotes(NotesDbModel 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_Notes_Save] @Id OUT,@Name,@Description,@ContactId,@CreatedBy,@IsActive",
new Object[]
{
outParam,
new SqlParameter("Name", Model.Name),
new SqlParameter("Description", Model.Description),
new SqlParameter("ContactId", Model.ContactId),
new SqlParameter("CreatedBy", Model.CreatedBy),
new SqlParameter("IsActive", Model.IsActive)
}
);
}
result = Convert.ToInt32(outParam.Value);
return(result);
}
public static int SaveNoteLinks(NotesDbModel Model)
{
using (var Context = new CRMContext())
{
return(Context.Database.ExecuteSqlCommand(
"exec dbo.[usp_Sales_NoteLinks_Save] @Id,@NoteId,@LinkId,@LinkType",
new Object[]
{
new SqlParameter("Id", Model.NoteLinkId),
new SqlParameter("NoteId", Model.Id),
new SqlParameter("LinkId", Model.LinkId),
new SqlParameter("LinkType", (int)Model.LinkType)
}
));
}
}