public void Add(CreateNaklModel createNaklModel)
{
const string commandText = @"Insert Into chz_nakls(subject_id,shipper_id,operation_date,doc_num,doc_date,receive_type,source,contract_type,contract_num,is_direct,chz_nakl_status_id)
Values(@subject_id,@shipper_id,@operation_date,@doc_num,@doc_date,@receive_type,@source,@contract_type,@contract_num,0,1)";
var transaction = Transact <object> .Create(ConnectionString, commandText, parameter : createNaklModel);
transaction.ExecuteNonQuery();
}
public int Add([FromBody] CreateNaklModel createNaklModel)
{
try
{
naklDataBase.Add(createNaklModel);
return(naklDataBase.GetMaxId());
}
catch (Exception e)
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
public void SaveChanges(CreateNaklModel createNaklModel)
{
const string commandText = @"Update chz_nakls
Set subject_id= @subject_id,shipper_id= @shipper_id,operation_date= @operation_date,doc_num= @doc_num,doc_date= @doc_date,receive_type= @receive_type,
source= @source,contract_type= @contract_type,contract_num= @contract_num,is_direct= 0,chz_nakl_status_id=1
Where chz_nakl_id=@chz_nakl_id";
var parameter = new NaklIdParameter()
{
NaklId = createNaklModel.Id
};
var transaction = Transact <object> .Create(ConnectionString, commandText, parameter : createNaklModel);
transaction.ExecuteNonQuery();
}
public void Update([FromBody] CreateNaklModel createNaklModel)
{
naklDataBase.SaveChanges(createNaklModel);
}
