public ResultResponse DeleteOperationFromStyle(CommonModel commonModel, int userId) { ResultResponse resultResponse = new ResultResponse(); try { accessManager.SqlConnectionOpen(DataBase.WorkerInsentive); foreach (CommonModel common in commonModel.OperationList) { List <SqlParameter> aParameters = new List <SqlParameter>(); aParameters.Add(new SqlParameter("@StyleId", commonModel.StyleId)); aParameters.Add(new SqlParameter("@OperationId", common.OperationId)); accessManager.DeleteData("sp_DeleteOperationFromStyle", aParameters); } resultResponse.isSuccess = true; return(resultResponse); } catch (Exception exception) { accessManager.SqlConnectionClose(true); throw exception; } finally { accessManager.SqlConnectionClose(); } }
public ResultResponse DeletePositionFromGrid(int DefectPositionId, int MasterSilhouteeId, int FrontOrBack) { try { accessManager.SqlConnectionOpen(DataBase.QMSDatabase); ResultResponse resultResponse = new ResultResponse(); List <SqlParameter> aParameters = new List <SqlParameter>(); aParameters.Add(new SqlParameter("@DefectPositionId", DefectPositionId)); aParameters.Add(new SqlParameter("@MasterSilhoutteId", MasterSilhouteeId)); aParameters.Add(new SqlParameter("@FrontOrBack", FrontOrBack)); resultResponse.isSuccess = accessManager.DeleteData("sp_DeletePositionFormGrid", aParameters); return(resultResponse); } catch (Exception exception) { throw exception; } finally { accessManager.SqlConnectionClose(); } }
public bool DeleteFileFromDatabase(int capexInfo, int userId) { bool result = true; try { accessManager.SqlConnectionOpen(DataBase.SQQeye); List <SqlParameter> aParameters = new List <SqlParameter>(); List <SqlParameter> aList = new List <SqlParameter>(); aList.Add(new SqlParameter("@capinfo", capexInfo)); aList.Add(new SqlParameter("@userId", userId)); result = accessManager.DeleteData("sp_deleteFilesFromTables", aList); return(result); } catch (Exception e) { accessManager.SqlConnectionClose(true); throw; } finally { accessManager.SqlConnectionClose(); } }