public SigmaResultType UpdateProgressTypeMap(TypeProgressTypeMap objProgressTypeMap) { 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("@ProgressTypeMapId", Utilities.ToInt32(objProgressTypeMap.ProgressTypeMapId.ToString().Trim())), new SqlParameter("@DisciplineCode", objProgressTypeMap.DisciplineCode.Trim()), new SqlParameter("@TaskCategoryId", Utilities.ToInt32(objProgressTypeMap.TaskCategoryId.ToString().Trim())), new SqlParameter("@TaskTypeId", Utilities.ToInt32(objProgressTypeMap.TaskTypeId.ToString().Trim())), new SqlParameter("@ProgressTypeId", Utilities.ToInt32(objProgressTypeMap.ProgressTypeId.ToString().Trim())), new SqlParameter("@UpdatedBy", userinfo.SigmaUserId.Trim()) }; using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_UpdateProgressTypeMap", parameters); result.IsSuccessful = true; scope.Complete(); } return result; }
public DataSet ListTaskType(TypeProgressTypeMap objProgressTypeMap) { // Get connection string string connStr = ConnStrHelper.getDbConnString(); // Compose parameters SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TaskCategoryId", Utilities.ToInt32(objProgressTypeMap.TaskCategoryId.ToString().Trim())) }; // Get Data DataSet ds = SqlHelper.ExecuteDataset(connStr, "usp_ListTaskTypeNotAssignProgressTypeMap", parameters); // return return ds; }
//public SigmaResultType GetProgressTypeMap(string progressTypeMapId) //{ // SigmaResultType result = new SigmaResultType(); // // Get connection string // string connStr = ConnStrHelper.getDbConnString(); // // Compose parameters // SqlParameter[] parameters = new SqlParameter[] { // new SqlParameter("@ProgressTypeMapId", progressTypeMapId) // }; // // Get Data // DataSet ds = SqlHelper.ExecuteDataset(connStr, "usp_GetProgressTypeMap", parameters); // // Convert to REST/JSON String // result.JsonDataSet = JsonHelper.convertDataTableToJson(ds.Tables[0]); // result.AffectedRow = 1; // result.IsSuccessful = true; // // return // return result; //} //public SigmaResultType ListProgressTypeMap(string offset, string max, string s_option, string s_key, string o_option, string o_desc) //{ // SigmaResultType result = new SigmaResultType(); // // Get connection string // string connStr = ConnStrHelper.getDbConnString(); // // Compose parameters // List<SqlParameter> parameters = new List<SqlParameter>(); // parameters.Add(new SqlParameter("@MaxNumRows", (max == null ? 1000 : int.Parse(max)))); // parameters.Add(new SqlParameter("@RetrieveOffset", (offset == null ? 0 : int.Parse(offset)))); // parameters.Add(new SqlParameter("@SortColumn", o_option)); // parameters.Add(new SqlParameter("@SortOrder", (o_desc != null ? o_desc.ToUpper() : null))); // // Get Data // DataSet ds = SqlHelper.ExecuteDataset(connStr, "usp_ListProgressTypeMap", parameters.ToArray()); // // Convert to REST/JSON String // result.JsonDataSet = JsonHelper.convertDataTableToJson(ds.Tables[0]); // result.AffectedRow = (int)ds.Tables[1].Rows[0][0]; // returning count // result.ScalarValue = (int)ds.Tables[2].Rows[0][0]; // total count by search // result.IsSuccessful = true; // // return // return result; //} public SigmaResultType AddProgressTypeMap(TypeProgressTypeMap objProgressTypeMap) { 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("@DisciplineCode", objProgressTypeMap.DisciplineCode.Trim())); paramList.Add(new SqlParameter("@TaskCategoryId", Utilities.ToInt32(objProgressTypeMap.TaskCategoryId.ToString().Trim()))); if (objProgressTypeMap.TaskTypeId > 0) { paramList.Add(new SqlParameter("@TaskTypeId", Utilities.ToInt32(objProgressTypeMap.TaskTypeId.ToString().Trim()))); } else { paramList.Add(new SqlParameter("@TaskTypeId", DBNull.Value)); } paramList.Add(new SqlParameter("@ProgressTypeId", Utilities.ToInt32(objProgressTypeMap.ProgressTypeId.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_AddProgressTypeMap", paramList.ToArray()); result.IsSuccessful = true; result.ScalarValue = (int)outParam.Value; scope.Complete(); } return result; }
//public SigmaResultType RemoveProgressTypeMap(TypeProgressTypeMap objProgressTypeMap) //{ // SigmaResultType result = new SigmaResultType(); // TransactionScope scope = null; // // Get connection string // string connStr = ConnStrHelper.getDbConnString(); // // Compose parameters // SqlParameter[] parameters = new SqlParameter[] { // new SqlParameter("@ProgressTypeMapId", objProgressTypeMap.ProgressTypeMapId) // }; // using (scope = new TransactionScope(TransactionScopeOption.Required)) // { // result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_RemoveProgressTypeMap", parameters); // result.IsSuccessful = true; // scope.Complete(); // } // return result; //} //public SigmaResultType MultiProgressTypeMap(List<TypeProgressTypeMap> listObj) //{ // TransactionScope scope = null; // SigmaResultType result = new SigmaResultType(); // // Get connection string // string connStr = ConnStrHelper.getDbConnString(); // using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) // { // foreach (TypeProgressTypeMap anObj in listObj) // { // switch (anObj.SigmaOperation) // { // case "C": // AddProgressTypeMap(anObj); // break; // case "U": // UpdateProgressTypeMap(anObj); // break; // case "D": // RemoveProgressTypeMap(anObj); // break; // } // } // scope.Complete(); // } // return result; //} public SigmaResultType AddProgressTypeMapInfo(TypeProgressTypeMap objProgressTypeMap) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); DataSet taskTypeDataSet = null; List<TypeProgressTypeMap> progressTypeMapList = new List<TypeProgressTypeMap>(); ; TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); SigmaResultType resultProgressTypeMap = new SigmaResultType(); using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) { if (objProgressTypeMap.SigmaOperation == SigmaOperation.INSERT) { resultProgressTypeMap = AddProgressTypeMap(objProgressTypeMap); taskTypeDataSet = ListTaskType(objProgressTypeMap); foreach (DataRow item in taskTypeDataSet.Tables[0].Rows) { TypeProgressTypeMap progressTypeMap = new TypeProgressTypeMap(); progressTypeMap.DisciplineCode = objProgressTypeMap.DisciplineCode; progressTypeMap.TaskCategoryId = objProgressTypeMap.TaskCategoryId; progressTypeMap.TaskTypeId = int.Parse(item["TaskTypeId"].ToString()); progressTypeMap.ProgressTypeId = objProgressTypeMap.ProgressTypeId; progressTypeMap.CreatedBy = userinfo.SigmaUserId; progressTypeMap.UpdatedBy = userinfo.SigmaUserId; progressTypeMapList.Add(progressTypeMap); } } else if (objProgressTypeMap.SigmaOperation == SigmaOperation.UPDATE) { resultProgressTypeMap = UpdateProgressTypeMap(objProgressTypeMap); taskTypeDataSet = ListTaskType(objProgressTypeMap); foreach (DataRow item in taskTypeDataSet.Tables[0].Rows) { TypeProgressTypeMap progressTypeMap = new TypeProgressTypeMap(); progressTypeMap.SigmaOperation = SigmaOperation.INSERT; progressTypeMap.DisciplineCode = objProgressTypeMap.DisciplineCode; progressTypeMap.TaskCategoryId = objProgressTypeMap.TaskCategoryId; progressTypeMap.TaskTypeId = int.Parse(item["TaskTypeId"].ToString()); progressTypeMap.ProgressTypeId = objProgressTypeMap.ProgressTypeId; progressTypeMap.CreatedBy = userinfo.SigmaUserId; progressTypeMap.UpdatedBy = userinfo.SigmaUserId; progressTypeMapList.Add(progressTypeMap); } } if (resultProgressTypeMap.IsSuccessful && progressTypeMapList.Count > 0) { foreach (var item in progressTypeMapList) { switch (item.SigmaOperation) { case SigmaOperation.INSERT: AddProgressTypeMap(item); break; case SigmaOperation.UPDATE: UpdateProgressTypeMap(item); break; } } } result.AffectedRow = resultProgressTypeMap.AffectedRow; result.ScalarValue = resultProgressTypeMap.ScalarValue; result.IsSuccessful = true; scope.Complete(); } return result; }
public SigmaResultType UpdateProgressTypeMap(TypeProgressTypeMap objProgressTypeMap) { SigmaResultType result = new SigmaResultType(); try { ProgressTypeMgr progressTypeMgr = new ProgressTypeMgr(); result = progressTypeMgr.AddProgressTypeMapInfo(objProgressTypeMap); return result; } catch (Exception ex) { // Log Exception ExceptionHelper.logException(ex); result.IsSuccessful = false; result.ErrorMessage = ex.Message; return result; } }