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();
}
}
