public SigmaResultType AddProgressStep(TypeProgressStep objProgressStep)
{
TypeUserInfo userinfo = AuthMgr.GetUserInfo();
TransactionScope scope = null;
SigmaResultType result = new SigmaResultType();
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
List<SqlParameter> paramList = new List<SqlParameter>();
paramList.Add(new SqlParameter("@ProgressTypeId", Utilities.ToInt32(objProgressStep.ProgressTypeId.ToString().Trim())));
paramList.Add(new SqlParameter("@Name", objProgressStep.Name.Trim()));
paramList.Add(new SqlParameter("@IsMultipliable", objProgressStep.IsMultipliable.Trim()));
paramList.Add(new SqlParameter("@Weight", Utilities.ToInt32(objProgressStep.Weight.ToString().Trim())));
paramList.Add(new SqlParameter("@CreatedBy", userinfo.SigmaUserId.Trim()));
SqlParameter outParam = new SqlParameter("@NewId", SqlDbType.Int);
outParam.Direction = ParameterDirection.Output;
paramList.Add(outParam);
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, "usp_AddProgressStep", paramList.ToArray());
result.IsSuccessful = true;
result.ScalarValue = (int)outParam.Value;
scope.Complete();
}
return result;
}
public SigmaResultType UpdateProgressStep(TypeProgressStep objProgressStep)
{
TypeUserInfo userinfo = AuthMgr.GetUserInfo();
TransactionScope scope = null;
SigmaResultType result = new SigmaResultType();
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
// Compose parameters
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ProgressStepId", Utilities.ToInt32(objProgressStep.ProgressStepId.ToString().Trim())),
new SqlParameter("@ProgressTypeId", Utilities.ToInt32(objProgressStep.ProgressTypeId.ToString().Trim())),
new SqlParameter("@Name", objProgressStep.Name.Trim()),
new SqlParameter("@IsMultipliable", objProgressStep.IsMultipliable.Trim()),
new SqlParameter("@Weight", Utilities.ToInt32(objProgressStep.Weight.ToString().Trim())),
new SqlParameter("@UpdatedBy", userinfo.SigmaUserId.Trim())
};
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_UpdateProgressStep", parameters);
result.IsSuccessful = true;
scope.Complete();
}
return result;
}
public SigmaResultType RemoveProgressStep(TypeProgressStep objProgressStep)
{
SigmaResultType result = new SigmaResultType();
TransactionScope scope = null;
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
// Compose parameters
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ProgressStepId", Utilities.ToInt32(objProgressStep.ProgressStepId.ToString().Trim()))
};
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_RemoveProgressStep", parameters);
result.IsSuccessful = true;
scope.Complete();
}
return result;
}
