public Guid InsertTaskType(TaskTypeEntity taskTypeEntity)
{
Guid result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_TaskTypeInsert");
db.AddInParameter(dbCommand, "@TaskDescription", DbType.String, taskTypeEntity.TaskDescription);
db.AddInParameter(dbCommand, "@TaskCode", DbType.String, taskTypeEntity.TaskCode);
db.AddInParameter(dbCommand, "@CreatedBy", DbType.Guid, taskTypeEntity.CreatedBy);
db.AddOutParameter(dbCommand, "@TaskTypeId", DbType.Guid, 30);
db.ExecuteNonQuery(dbCommand);
result = new Guid(db.GetParameterValue(dbCommand, "@TaskTypeId").ToString());
return result;
}
public bool UpdateTaskType(TaskTypeEntity taskTypeEntity)
{
return taskDao.UpdateTaskType(taskTypeEntity);
}
public bool UpdateTaskType(TaskTypeEntity taskTypeEntity)
{
bool result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_TaskTypeUpdate");
db.AddInParameter(dbCommand, "@TaskTypeId", DbType.Guid, taskTypeEntity.TaskTypeId);
db.AddInParameter(dbCommand, "@TaskDescription", DbType.String, taskTypeEntity.TaskDescription);
db.AddInParameter(dbCommand, "@TaskCode", DbType.String, taskTypeEntity.TaskCode);
db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, taskTypeEntity.UpdatedBy);
db.ExecuteNonQuery(dbCommand);
result = true;
return result;
}
public Guid InsertTaskType(TaskTypeEntity taskTypeEntity)
{
return taskDao.InsertTaskType(taskTypeEntity);
}
