public int Insert(LendingCarsDetailModel model) { int Id = 0; DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext(); int F_IDrequstAmani = (int)model.F_IDrequstAmani; int F_IDCar = (int)model.F_IDCar; int AcceptanceType = (int)model.AcceptanceType; int F_color = (int)model.F_color; int num = (int)model.num; int radif = (int)model.radif; int Days = (int)model.Days; int DelivType = (int)model.DelivType; int F_Deliver = (int)model.F_Deliver; string NameDeliv = model.NameDeliv; int F_UsageType = model.F_UsageType; string sql = @"DECLARE @Out int EXEC [sale].[STP_T00050060];1 @F_IDrequstAmani ={0}, @F_IDCar ={1}, @AcceptanceType= {2}, @F_color ={3}, @num ={4}, @radif ={5}, @Days ={6}, @DelivType ={7}, @F_Deliver ={8}, @NameDeliv ={9}, @F_UsageType ={10}, @Out = @Out OUTPUT SELECT @Out as N'@Out'"; Id = context.ExecuteQuery <int>(sql, F_IDrequstAmani, F_IDCar, AcceptanceType, F_color, num, radif, Days, DelivType, F_Deliver, NameDeliv, F_UsageType).FirstOrDefault(); DataLayer.AtsTotalNewDataContext NewContext = new DataLayer.AtsTotalNewDataContext(); var query = (from t in NewContext.T00050060s where t.IDDetailReqAmani == Id select t).FirstOrDefault(); query.status = 801; query.Statusdate = Core.StaticData.DateNow.Date; query.StatusTime = Core.StaticData.DateNow.Time; NewContext.SubmitChanges(); return(Id); }