public BaseApiResponse UpdateCourt(CourtEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("CourtID", (object)model.CourtID ?? (object)DBNull.Value)
, new SqlParameter("CourtType", (object)model.CourtType ?? (object)DBNull.Value)
, new SqlParameter("StateID", (object)model.StateID ?? (object)DBNull.Value)
, new SqlParameter("DistrictID", (object)model.DistrictID ?? (object)DBNull.Value)
, new SqlParameter("CountyID", (object)model.CountyID ?? (object)DBNull.Value)
, new SqlParameter("CourtName", (object)model.CourtName ?? (object)DBNull.Value)
, new SqlParameter("IsActive", (object)model.IsActive ?? (object)DBNull.Value)
, new SqlParameter("UpdatedBy", (object)model.UpdatedBy ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("UpdateCourt", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public void Add(string name)
{
CourtEntity court = new CourtEntity()
{
Name = name
};
_context.Courts.Add(court);
_context.SaveChanges();
}
public bool UpdateCourt(CourtEntity courtEntity)
{
bool result = false;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_CourtUpdate");
db.AddInParameter(dbCommand, "@CourtId", DbType.Guid, courtEntity.CourtId);
db.AddInParameter(dbCommand, "@Court", DbType.String, courtEntity.Court);
db.AddInParameter(dbCommand, "@CourtTypeId", DbType.Guid, courtEntity.CourtTypeId);
db.AddInParameter(dbCommand, "@PoliceStation", DbType.String, courtEntity.PoliceStation);
db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, courtEntity.UpdatedBy);
db.ExecuteNonQuery(dbCommand);
result = true;
return(result);
}
public Guid InsertCourt(CourtEntity courtEntity)
{
Guid result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_CourtInsert");
db.AddInParameter(dbCommand, "@Court", DbType.String, courtEntity.Court);
db.AddInParameter(dbCommand, "@CourtTypeId", DbType.Guid, courtEntity.CourtTypeId);
db.AddInParameter(dbCommand, "@PoliceStation", DbType.String, courtEntity.PoliceStation);
db.AddInParameter(dbCommand, "@CreatedBy", DbType.Guid, courtEntity.CreatedBy);
db.AddOutParameter(dbCommand, "@CourtId", DbType.Guid, 30);
db.ExecuteNonQuery(dbCommand);
result = new Guid(db.GetParameterValue(dbCommand, "@CourtId").ToString());
return(result);
}
public bool UpdateCourt(CourtEntity courtEntity)
{
return(courtDao.UpdateCourt(courtEntity));
}
public Guid InsertCourt(CourtEntity courtEntity)
{
return(courtDao.InsertCourt(courtEntity));
}
