public static List <InputHelpModel> ToInputHelp(DbDataReader readers)
{
if (readers == null)
{
return(null);
}
var models = new List <InputHelpModel>();
while (readers.Read())
{
var model = new InputHelpModel
{
Id = Convert.ToInt32(readers["Id"]),
Name = Convert.IsDBNull(readers["Name"]) ? string.Empty : Convert.ToString(readers["Name"]),
InputHelpTypeId = Convert.ToInt32(readers["InputHelpTypeId"]),
CreatedAt = Convert.ToDateTime(readers["CreatedAt"]),
CreatedById = Convert.ToString(readers["CreatedById"]),
CreatedByName = Convert.IsDBNull(readers["CreatedByName"]) ? string.Empty : Convert.ToString(readers["CreatedByName"]),
UpdatedAt = Convert.IsDBNull(readers["UpdatedAt"]) ? (DateTime?)null : Convert.ToDateTime(readers["UpdatedAt"]),
};
models.Add(model);
}
return(models);
}
public ResponseModel Save(InputHelpModel model)
{
var err = string.Empty;
const string sql = @"IF NOT EXISTS(SELECT TOP 1 * FROM InputHelp WHERE Id=@Id)
BEGIN
INSERT INTO InputHelp(Name,InputHelpTypeId,CreatedAt,CreatedById)
VALUES(@Name,@InputHelpTypeId,@CreatedAt,@CreatedById)
END
ELSE
BEGIN
UPDATE InputHelp SET Name=@Name,InputHelpTypeId=@InputHelpTypeId,UpdatedAt=@CreatedAt,UpdatedById=@CreatedById
WHERE Id=@Id
END";
var queryParamList = new QueryParamList
{
new QueryParamObj {
ParamName = "@Id", ParamValue = model.Id
},
new QueryParamObj {
ParamName = "@Name", ParamValue = string.IsNullOrEmpty(model.Name)?null:model.Name
},
new QueryParamObj {
ParamName = "@InputHelpTypeId", ParamValue = model.InputHelpTypeId
},
new QueryParamObj {
ParamName = "@CreatedAt", ParamValue = DateTime.UtcNow, DBType = DbType.DateTime
},
new QueryParamObj {
ParamName = "@CreatedById", ParamValue = model.CreatedById
}
};
DBExecCommandEx(sql, queryParamList, ref err);
return(new ResponseModel {
Success = string.IsNullOrEmpty(err)
});
}
public IHttpActionResult Save([FromBody] InputHelpModel model)
{
return(Ok(_inputHelp.Save(model)));
}
