public SigmaResultType AddCustomFieldWithEquipmentCustomField(TypeCustomField objCustomField) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); SigmaResultType customField = new SigmaResultType(); SigmaResultType EquipmentCustomField = new SigmaResultType(); TypeEquipmentCustomField typeEquipmentCustomField = new TypeEquipmentCustomField(); typeEquipmentCustomField.EquipmentId = objCustomField.Parentid; typeEquipmentCustomField.Value = objCustomField.Value; typeEquipmentCustomField.CreatedBy = userinfo.SigmaUserId; typeEquipmentCustomField.UpdatedBy = userinfo.SigmaUserId; using (scope = new TransactionScope(TransactionScopeOption.Required)) { CustomFieldMgr custom = new CustomFieldMgr(); customField = custom.AddCustomField(objCustomField); typeEquipmentCustomField.CustomFieldId = customField.ScalarValue; EquipmentCustomField = AddEquipmentCustomField(typeEquipmentCustomField); scope.Complete(); } return result; }
public SigmaResultType UpdateEquipmentCustomField(TypeEquipmentCustomField objEquipmentCustomField) { 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("@EquipmentId", Utilities.ToInt32(objEquipmentCustomField.EquipmentId.ToString().Trim())), new SqlParameter("@CustomFieldId", Utilities.ToInt32(objEquipmentCustomField.CustomFieldId.ToString().Trim())), new SqlParameter("@Value", objEquipmentCustomField.Value.Trim()), new SqlParameter("@UpdatedBy", userinfo.SigmaUserId.Trim()) }; using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_UpdateEquipmentCustomField", parameters); result.IsSuccessful = true; scope.Complete(); } return result; }
//public SigmaResultType GetEquipmentCustomField(string id) //{ // SigmaResultType result = new SigmaResultType(); // // Get connection string // string connStr = ConnStrHelper.getDbConnString(); // // Compose parameters // SqlParameter[] parameters = new SqlParameter[] { // new SqlParameter("@", id) // }; // // Get Data // DataSet ds = SqlHelper.ExecuteDataset(connStr, "usp_GetEquipmentCustomField", parameters); // // Convert to REST/JSON String // result.JsonDataSet = JsonHelper.convertDataTableToJson(ds.Tables[0]); // result.AffectedRow = 1; // result.IsSuccessful = true; // // return // return result; //} //public SigmaResultType ListEquipmentCustomField(string offset, string max, string o_option, string o_desc, string s_option1, string s_option2) //{ // 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 ? 50 : 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_ListCompany", parameters.ToArray()); // // Convert to REST/JSON String // result.JsonDataSet = JsonHelper.convertDataTableToJson(ds.Tables[0]); // result.AffectedRow = (int)ds.Tables[1].Rows[0][0]; // result.IsSuccessful = true; // // return // return result; //} public SigmaResultType AddEquipmentCustomField(TypeEquipmentCustomField objEquipmentCustomField) { 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("@EquipmentId", Utilities.ToInt32(objEquipmentCustomField.EquipmentId.ToString().Trim()))); paramList.Add(new SqlParameter("@CustomFieldId", Utilities.ToInt32(objEquipmentCustomField.CustomFieldId.ToString().Trim()))); paramList.Add(new SqlParameter("@Value", objEquipmentCustomField.Value.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_AddEquipmentCustomField", paramList.ToArray()); result.IsSuccessful = true; //result.ScalarValue = (int)outParam.Value; scope.Complete(); } return result; }
private bool CheckEquipmentCustomField(DataTable Exceldt, string ColName, int EquipmentId, string CustomFieldValue) { CommonCodeMgr common = new CommonCodeMgr(); CustomFieldMgr customFieldMgr = new CustomFieldMgr(); EquipmentMgr equipmentMgr = new EquipmentMgr(); MaterialCustomFieldMgr materialCustomFieldMgr = new MaterialCustomFieldMgr(); TypeCustomField customField = new TypeCustomField(); TypeEquipmentCustomField equipmentCustomField = new TypeEquipmentCustomField(); SigmaResultType mResult = new SigmaResultType(); SigmaResultType cResult = new SigmaResultType(); DataSet CustomFiledSD = materialCustomFieldMgr.ListMaterialCustomFieldByFieldName(ColName); DataRow CustomFiledSR = CustomFiledSD.Tables[0].Rows[0]; if (CustomFiledSD.Tables[0].Rows.Count > 0) { equipmentCustomField.EquipmentId = EquipmentId; equipmentCustomField.CustomFieldId = Convert.ToInt32(CustomFiledSR["CustomFieldId"].ToString()); equipmentCustomField.Value = CustomFieldValue; equipmentCustomField.CreatedBy = userinfo.SigmaUserId; mResult = equipmentMgr.AddEquipmentCustomField(equipmentCustomField); } else { customField.FieldName = ColName; customField.IsDisplayable = "Y"; customField.CreatedBy = userinfo.SigmaUserId; cResult = customFieldMgr.AddCustomField(customField); if (cResult.IsSuccessful) { equipmentCustomField.EquipmentId = EquipmentId; equipmentCustomField.CustomFieldId = cResult.ScalarValue; equipmentCustomField.Value = CustomFieldValue; equipmentCustomField.CreatedBy = userinfo.SigmaUserId; mResult = equipmentMgr.AddEquipmentCustomField(equipmentCustomField); } } return mResult.IsSuccessful; }