public bool UpdateCaseType(CaseTypeEntity caseTypeEntity)
{
bool result = false;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_CaseTypeUpdate");
db.AddInParameter(dbCommand, "@CaseTypeId", DbType.Guid, caseTypeEntity.CaseTypeId);
db.AddInParameter(dbCommand, "@CaseDescription", DbType.String, caseTypeEntity.CaseDescription);
db.AddInParameter(dbCommand, "@CaseCode", DbType.String, caseTypeEntity.CaseCode);
db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, caseTypeEntity.UpdatedBy);
db.ExecuteNonQuery(dbCommand);
result = true;
return(result);
}
public Guid InsertCaseType(CaseTypeEntity caseTypeEntity)
{
Guid result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_CaseTypeInsert");
db.AddInParameter(dbCommand, "@CaseDescription", DbType.String, caseTypeEntity.CaseDescription);
db.AddInParameter(dbCommand, "@CaseCode", DbType.String, caseTypeEntity.CaseCode);
db.AddInParameter(dbCommand, "@CreatedBy", DbType.Guid, caseTypeEntity.CreatedBy);
db.AddOutParameter(dbCommand, "@CaseTypeId", DbType.Guid, 30);
db.ExecuteNonQuery(dbCommand);
result = new Guid(db.GetParameterValue(dbCommand, "@CaseTypeId").ToString());
return(result);
}
public bool UpdateCaseType(CaseTypeEntity caseTypeEntity)
{
return(caseDao.UpdateCaseType(caseTypeEntity));
}
public Guid InsertCaseType(CaseTypeEntity caseTypeEntity)
{
return(caseDao.InsertCaseType(caseTypeEntity));
}
