public int Insert(LendingCarsModel model)
{
int Id = 0;
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
string sal = (Core.StaticData.DateNow.Date.Split('/')[0]).Substring(2);
string DateA = model.DateA;
int F_AgnID = (int)model.F_AgnID;
int? FlgTaahod = (model.FlgTaahod == true) ? 1 : 0;
string sql = @"DECLARE @Out int
EXEC [sale].[STP_T00050061];1
@sal ={0},
@DateA ={1},
@F_AgnID= {2},
@FlgTaahod ={3},
@Out = @Out OUTPUT
SELECT @Out as N'@Out'";
Id = context.ExecuteQuery <int>(sql,
sal,
DateA,
F_AgnID,
FlgTaahod).FirstOrDefault();
return(Id);
}
public LendingCarsModel GetById(int id)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
LendingCarsModel model = new LendingCarsModel();
var query = (from t in context.T00050061s
where (t.IDrequstAmani == id)
select t).FirstOrDefault();
model.code = query.code;
model.DateA = query.DateA;
model.F_AgnID = query.F_AgnID;
model.FlgTaahod = Convert.ToBoolean(query.FlgTaahod);
model.TrackID = (int?)query.TrackID;
return(model);
}
public Boolean Update(LendingCarsModel model)
{
Boolean Result = false;
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
string DateA = model.DateA;
int F_AgnID = (int)model.F_AgnID;
int? FlgTaahod = (model.FlgTaahod == true) ? 1 : 0;
int IDrequstAmani = model.IDrequstAmani;
string sql = @"EXEC [sale].[STP_T00050061];2
@IDrequstAmani ={0},
@DateA ={1},
@F_AgnID= {2},
@FlgTaahod ={3}" ;
context.ExecuteCommand(sql,
IDrequstAmani,
DateA,
F_AgnID,
FlgTaahod);
return(Result);
}