public HttpResponseMessage Insert(CompanyAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _company.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
/// <summary>
/// It Stores Data in the Database
/// </summary>
/// <param name="companyAdd">Caompany Data</param>
/// <returns>If Data Found return ResponseData else nul or Exception</returns>
public CompanyAddResponse AddCompany(CompanyAddRequest companyAddRequest)
{
try
{
CompanyAddResponse responseData = null;
try
{
using (SqlConnection conn = new SqlConnection(sqlConnectionString))
{
SqlCommand cmd = new SqlCommand("spAddCompany", conn)
{
CommandType = System.Data.CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@Name", companyAddRequest.Name);
cmd.Parameters.AddWithValue("@Address", companyAddRequest.Address);
cmd.Parameters.AddWithValue("@Location", companyAddRequest.Location);
cmd.Parameters.AddWithValue("@Status", companyAddRequest.Status);
cmd.Parameters.AddWithValue("@CreatorStamp", companyAddRequest.CreatorStamp);
cmd.Parameters.AddWithValue("@CreatorUser", companyAddRequest.CreatorUser);
cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now);
conn.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
responseData = new CompanyAddResponse()
{
CompanyID = Convert.ToInt32(dataReader["CompanyID"]),
Name = dataReader["Name"].ToString(),
Address = dataReader["Address"].ToString(),
Location = dataReader["Location"].ToString(),
Status = dataReader["Status"].ToString(),
CreatorStamp = dataReader["CreatorStamp"].ToString(),
CreatorUser = dataReader["CreatorUser"].ToString(),
CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]),
ModifiedDate = Convert.ToDateTime(dataReader["ModifiedDate"])
};
}
conn.Close();
}
return(responseData);
}
catch
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public HttpResponseMessage Add(CompanyAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Modal is not Valid"));
}
ItemResponse <int> responseBody = new ItemResponse <int>();
UserBase user = _authService.GetCurrentUser();
int userId = user.Id;
responseBody.Item = _service.Insert(model, userId);
return(Request.CreateResponse(HttpStatusCode.Created, responseBody));
}
private void MapCommonParameters(CompanyAddRequest model, SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@CompanyName", model.Name);
paramCollection.AddWithValue("@CompanyPhoneNumber", model.PhoneNumber);
paramCollection.AddWithValue("@CompanyEmail", model.Email);
paramCollection.AddWithValue("@Address1", model.Address1);
paramCollection.AddWithValue("@Address2", model.Address2);
paramCollection.AddWithValue("@City", model.City);
paramCollection.AddWithValue("@StateProvinceId", model.StateProvinceId);
paramCollection.AddWithValue("@CountryId", model.CountryId);
paramCollection.AddWithValue("@CompanyIdCreated", UserService.GetCurrentUserId());
paramCollection.AddWithValue("@PostalCode", model.PostalCode);
paramCollection.AddWithValue("@Inactive", model.Inactive);
paramCollection.AddWithValue("@IsDeploy", model.IsDeploy);
paramCollection.AddWithValue("@UserIdCreated", UserService.GetCurrentUserId());
}
public HttpResponseMessage PostCompany(CompanyAddRequest model)
{
try
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _companyService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public virtual IHttpActionResult Add(CompanyAddRequest request)
{
var entity = new Company
{
};
var result = _companyService.Add(entity);
if (result > 0)
{
return(Succeed(new CompanyAddResponse
{
Id = entity.Id
}, "新增成功"));
}
else
{
return(Fail("新增失败"));
}
}
public int Insert(CompanyAddRequest data, int userId)
{
using (var con = GetConnection())
{
var cmd = con.CreateCommand();
cmd.CommandText = "[dbo].[Company_Insert]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CompanyName", data.CompanyName);
cmd.Parameters.AddWithValue("@Url", data.Url);
cmd.Parameters.AddWithValue("@Description", data.Description);
cmd.Parameters.AddWithValue("@PhotoUrl", data.PhotoUrl);
cmd.Parameters.AddWithValue("@PhoneNumber", data.PhoneNumber);
cmd.Parameters.AddWithValue("@UserId", userId);
cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Id"].Value);
}
}
public int Insert(CompanyAddRequest model)
{
int id = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Company_Insert",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
MapCommonParameters(model, paramCollection);
SqlParameter p = new SqlParameter("@Id", SqlDbType.Int);
p.Direction = ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
Int32.TryParse(param["@Id"].Value.ToString(), out id);
}
);
return(id);
}
public int Insert(CompanyAddRequest model)
{
int id = 0;
DataProvider.ExecuteNonQuery("dbo.Company_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@CompanyName", model.CompanyName);
paramCollection.AddWithValue("@CompanyUrl", model.CompanyUrl);
paramCollection.AddWithValue("@CompanyLogoUrl", model.CompanyLogoUrl);
paramCollection.AddWithValue("@ModifiedBy", model.ModifiedBy);
SqlParameter idParameter = new SqlParameter("@UserId", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(idParameter);
}
, returnParameters : delegate(SqlParameterCollection param)
{
Int32.TryParse(param["@UserId"].Value.ToString(), out id);
});
return(id);
}
public IActionResult AddCompany(CompanyAddRequest company)
{
try
{
bool success = false;
string message;
var data = _companyBusiness.AddCompany(company);
if (data != null)
{
success = true;
message = "Company Data Added Successfully";
return(Ok(new { success, message, data }));
}
else
{
message = "Try Again!";
return(NotFound(new { success, message }));
}
}
catch (Exception ex)
{
return(BadRequest(new { ex.Message }));
}
}
public CompanyAddResponse AddCompany(CompanyAddRequest companyAddRequest)
{
var responseData = _companyRepository.AddCompany(companyAddRequest);
return(responseData);
}
