public HttpResponseMessage Insert([FromBody] SubSORType SubSORType)
{
_SubSORTypeRepo.InsertSubSORTypeDetailsAsync(SubSORType);
var message = Request.CreateResponse(HttpStatusCode.Created, SubSORType);
message.Headers.Location = new Uri(Request.RequestUri + SubSORType.ID.ToString());
return(message);
}
public void InsertSubSORTypeDetailsAsync(SubSORType SubSORType)
{
if (myconn.State != ConnectionState.Open)
{
myconn.Open();
}
SqlTransaction tran = myconn.BeginTransaction();
SubSORType.createdDate = DateTime.Now;
SubSORType.modifiedDate = DateTime.Now;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SP_SubSORTypeInsertUpdate";
sqlCmd.Parameters.Add(new SqlParameter("@mode", "I"));
sqlCmd.Parameters.Add(new SqlParameter("@Id", SubSORType.ID));
sqlCmd.Parameters.Add(new SqlParameter("@name", SubSORType.name));
sqlCmd.Parameters.Add(new SqlParameter("@SORTypeID", SubSORType.SORTypeID));
sqlCmd.Parameters.Add(new SqlParameter("@createdDate", SubSORType.createdDate));
sqlCmd.Parameters.Add(new SqlParameter("@modifiedDate", SubSORType.modifiedDate));
sqlCmd.Parameters.Add(new SqlParameter("@userId", SubSORType.userId));
try
{
sqlCmd.Connection = myconn;
sqlCmd.Transaction = tran;
SubSORType.ID = Convert.ToInt32(sqlCmd.ExecuteScalar());
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
gs.LogData(ex);
throw ex;
}
finally
{
if (myconn.State != ConnectionState.Closed)
{
myconn.Close();
}
}
}
public async Task <List <SubSORType> > Update([FromBody] SubSORType SubSORType)
{
List <SubSORType> lst = await Task.Run(() => _SubSORTypeRepo.UpdateSubSORTypeDetailsAsync(SubSORType));
return(lst);
}
