private bool UpdRuleInDb(int[] di, StampRule r) { return(Environment.StampChecksData.UpdStampRules(di, r)); }
public bool SetStampRules(int[] delIDs, int stampId, StampRule rule) { bool ret = false; using (var conn = new SqlConnection(connectionString)) using (var cmd = new SqlCommand()) { cmd.Connection = conn; conn.Open(); cmd.Transaction = conn.BeginTransaction(); try { if (delIDs != null && delIDs.Length > 0) { cmd.CommandText = "DELETE ПраваНаУстановкуШтампов WHERE КодПраваНаУстановкуШтампов IN (" + string.Join(", ", delIDs.Select(i => i.ToString()).ToArray()) + ")"; cmd.ExecuteNonQuery(); } if (stampId > 0 && rule != null) { cmd.CommandText = "INSERT ПраваНаУстановкуШтампов(" + idField + ", КодСотрудника, КодТипаДокумента, КодЛица) VALUES(@Id, @UserId, @DocType, @PersId)"; cmd.Parameters.Add("@Id", SqlDbType.Int).Value = stampId; cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = rule.UserId; SqlParameter paramDocType = cmd.Parameters.Add("@DocType", SqlDbType.Int); SqlParameter paramPersId = cmd.Parameters.Add("@PersId", SqlDbType.Int); if (rule.DocTypeID > 0) { paramDocType.Value = rule.DocTypeID; } else { paramDocType.Value = DBNull.Value; } if (rule.OrganizationID > 0) { paramPersId.Value = rule.OrganizationID; } else { paramPersId.Value = DBNull.Value; } cmd.ExecuteNonQuery(); } cmd.Transaction.Commit(); ret = true; } catch (SqlException sqlEx) { if (cmd.Transaction != null) { cmd.Transaction.Rollback(); } ProcessSqlEx(sqlEx, cmd, "StampChecksDALC", false); } catch (InvalidOperationException ioEx) { if (cmd.Transaction != null) { cmd.Transaction.Rollback(); } ErrorMessage(false, ioEx, null, "StampChecksDALC", false); } catch (Exception ex) { if (cmd.Transaction != null) { cmd.Transaction.Rollback(); } ErrorMessage(false, ex, null, "StampChecksDALC"); } finally { cmd.Connection.Close(); } } return(ret); }
private bool AddRuleToDb(int[] di, StampRule r) { return(Environment.StampChecksData.SetStampRules(di, stampID, r)); }