public HttpResponseMessage Insert([FromBody] MenuRolesRelation projRates)
{
_MenuRolesRelationRepo.InsertMenuRolesRelationDetailsAsync(projRates);
var message = Request.CreateResponse(HttpStatusCode.Created, projRates);
message.Headers.Location = new Uri(Request.RequestUri + projRates.Id.ToString());
return(message);
}
public void InsertMenuRolesRelationDetailsAsync(MenuRolesRelation relation)
{
if (myconn.State != ConnectionState.Open)
{
myconn.Open();
}
SqlTransaction tran = myconn.BeginTransaction();
relation.createdDate = DateTime.Now;
relation.modifiedDate = DateTime.Now;
relation.userRights = "";
SqlCommand sqlCmd = new SqlCommand();
DeleteMenuRolesRelationDetailsAsync(relation.roleId, tran);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SP_MenuRolesRelationInsertUpdate";
sqlCmd.Parameters.Add(new SqlParameter("@mode", "I"));
sqlCmd.Parameters.Add(new SqlParameter("@Id", relation.Id));
sqlCmd.Parameters.Add(new SqlParameter("@menuId", relation.menuId));
sqlCmd.Parameters.Add(new SqlParameter("@roleId", relation.roleId));
sqlCmd.Parameters.Add(new SqlParameter("@userRights", relation.userRights));
sqlCmd.Parameters.Add(new SqlParameter("@createdDate", relation.createdDate));
sqlCmd.Parameters.Add(new SqlParameter("@modifiedDate", relation.modifiedDate));
sqlCmd.Parameters.Add(new SqlParameter("@userId", relation.userId));
try
{
sqlCmd.Connection = myconn;
sqlCmd.Transaction = tran;
relation.Id = Convert.ToInt32(sqlCmd.ExecuteScalar());
// InsertMenuRolesRelationRateDetailsAsync(MenuRolesRelationRates, MenuRolesRelation.MenuRolesRelationID, tran);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
gs.LogData(ex);
throw ex;
}
finally
{
if (myconn.State != ConnectionState.Closed)
{
myconn.Close();
}
}
}
public async void Update([FromBody] MenuRolesRelation projRates)
{
await Task.Run(() => _MenuRolesRelationRepo.UpdateMenuRolesRelationDetailsAsync(projRates));
}
