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))); }