public AddMaterialMasterResponseDto AddMaterialMaster(AddMaterialMasterRequestDto addMaterialMasterRequestDto)
{
AddMaterialMasterResponseDto addMaterialMasterResponseDto = new AddMaterialMasterResponseDto();
var cModel = new AddMaterialMasterCM
{
MaterialDescription = addMaterialMasterRequestDto.MaterialDescription,
MaterialShortDescription = addMaterialMasterRequestDto.MaterialShortDescription
};
var response = materialMasterRepository.AddMaterialMaster(cModel);
return(new AddMaterialMasterResponseDto());
}
public AddMaterialMasterQM AddMaterialMaster(AddMaterialMasterCM addMaterialMasterCM)
{
var response = new AddMaterialMasterQM();
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new MaterialMasterInsertCommand {
Connection = connection
};
response.MaterialCode = command.Execute(addMaterialMasterCM);
}
return(response);
}
public int Execute(AddMaterialMasterCM model)
{
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspAddMaterialMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@MaterialDescription", SsDbType.VarChar, ParameterDirection.Input, model.MaterialDescription));
sqlCommand.Parameters.Add(AddParameter("@MaterialShortDescription", SsDbType.VarChar, ParameterDirection.Input, model.MaterialShortDescription));
//sqlCommand.Parameters.Add(AddParameter("@CreatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, model.CreatedBy));
//sqlCommand.Parameters.Add(AddParameter("@CreatedDateTime", SsDbType.DateTime, ParameterDirection.Input, model.CreatedDateTime));
sqlCommand.Parameters.Add(AddParameter("@CreatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, new Guid()));
sqlCommand.Parameters.Add(AddParameter("@CreatedDateTime", SsDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow));
sqlCommand.Parameters.Add(AddParameter("@MaterialCode", SsDbType.Decimal, ParameterDirection.Output, default(int)));
sqlCommand.ExecuteNonQuery();
return(Convert.ToInt32(sqlCommand.Parameters["@MaterialCode"].Value));
}
}
