private void CheckDeleteErrorsOsnovaosiguranja()
{
ReadWriteCommand command2 = this.connDefault.GetCommand("SELECT TOP 1 [IDOSNOVAOSIGURANJA] AS ZAMOOIDOSNOVAOSIGURANJA FROM [OSNOVAOSIGURANJA] WITH (NOLOCK) WHERE [ZAMOOIDOSNOVAOSIGURANJA] = @IDOSNOVAOSIGURANJA ", false);
if (command2.IDbCommand.Parameters.Count == 0)
{
command2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSNOVAOSIGURANJA", DbType.String, 2));
}
command2.SetParameterString(0, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["IDOSNOVAOSIGURANJA"]));
IDataReader reader2 = command2.FetchData();
if (command2.HasMoreRows)
{
reader2.Close();
throw new OSNOVAOSIGURANJAInvalidDeleteException(string.Format(this.resourceManager.GetString("del"), new object[] { "OSNOVAOSIGURANJA" }));
}
reader2.Close();
ReadWriteCommand command = this.connDefault.GetCommand("SELECT TOP 1 [IDELEMENT] FROM [ELEMENT] WITH (NOLOCK) WHERE [IDOSNOVAOSIGURANJA] = @IDOSNOVAOSIGURANJA ", false);
if (command.IDbCommand.Parameters.Count == 0)
{
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSNOVAOSIGURANJA", DbType.String, 2));
}
command.SetParameterString(0, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["IDOSNOVAOSIGURANJA"]));
IDataReader reader = command.FetchData();
if (command.HasMoreRows)
{
reader.Close();
throw new ELEMENTInvalidDeleteException(string.Format(this.resourceManager.GetString("del"), new object[] { "ELEMENT" }));
}
reader.Close();
}
private void InsertOsnovaosiguranja()
{
this.CheckOptimisticConcurrencyOsnovaosiguranja();
this.CheckExtendedTableOsnovaosiguranja();
this.AfterConfirmOsnovaosiguranja();
ReadWriteCommand command = this.connDefault.GetCommand("INSERT INTO [OSNOVAOSIGURANJA] ([IDOSNOVAOSIGURANJA], [RAZDOBLJESESMIJEPREKLAPATI], [NAZIVOSNOVAOSIGURANJA], [ZAMOOIDOSNOVAOSIGURANJA]) VALUES (@IDOSNOVAOSIGURANJA, @RAZDOBLJESESMIJEPREKLAPATI, @NAZIVOSNOVAOSIGURANJA, @ZAMOOIDOSNOVAOSIGURANJA)", false);
if (command.IDbCommand.Parameters.Count == 0)
{
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSNOVAOSIGURANJA", DbType.String, 2));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@RAZDOBLJESESMIJEPREKLAPATI", DbType.Boolean));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@NAZIVOSNOVAOSIGURANJA", DbType.String, 100));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ZAMOOIDOSNOVAOSIGURANJA", DbType.String, 2));
}
command.ErrorMask |= ErrorMask.DuplicateKeyError;
command.SetParameterString(0, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["IDOSNOVAOSIGURANJA"]));
command.SetParameter(1, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["RAZDOBLJESESMIJEPREKLAPATI"]));
command.SetParameter(2, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["NAZIVOSNOVAOSIGURANJA"]));
command.SetParameter(3, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["ZAMOOIDOSNOVAOSIGURANJA"]));
command.ExecuteStmt();
if (command.DupKey)
{
throw new OSNOVAOSIGURANJADuplicateKeyException(this.resourceManager.GetString("noupdate"));
}
this.OnOSNOVAOSIGURANJAUpdated(new OSNOVAOSIGURANJAEventArgs(this.rowOSNOVAOSIGURANJA, StatementType.Insert));
}
private void GetByPrimaryKey()
{
ReadWriteCommand command = this.connDefault.GetCommand("SELECT [IDOSNOVAOSIGURANJA], [RAZDOBLJESESMIJEPREKLAPATI], [NAZIVOSNOVAOSIGURANJA], [ZAMOOIDOSNOVAOSIGURANJA] AS ZAMOOIDOSNOVAOSIGURANJA FROM [OSNOVAOSIGURANJA] WITH (NOLOCK) WHERE [IDOSNOVAOSIGURANJA] = @IDOSNOVAOSIGURANJA ", false);
if (command.IDbCommand.Parameters.Count == 0)
{
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSNOVAOSIGURANJA", DbType.String, 2));
}
command.SetParameterString(0, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["IDOSNOVAOSIGURANJA"]));
IDataReader reader = command.FetchData();
if (command.HasMoreRows)
{
this.RcdFound18 = 1;
this.rowOSNOVAOSIGURANJA["IDOSNOVAOSIGURANJA"] = RuntimeHelpers.GetObjectValue(this.dsDefault.Db.GetStringNE(reader, 0));
this.rowOSNOVAOSIGURANJA["RAZDOBLJESESMIJEPREKLAPATI"] = RuntimeHelpers.GetObjectValue(this.dsDefault.Db.GetBoolean(reader, 1));
this.rowOSNOVAOSIGURANJA["NAZIVOSNOVAOSIGURANJA"] = RuntimeHelpers.GetObjectValue(this.dsDefault.Db.GetString(reader, 2));
this.rowOSNOVAOSIGURANJA["ZAMOOIDOSNOVAOSIGURANJA"] = RuntimeHelpers.GetObjectValue(this.dsDefault.Db.GetString(reader, 3));
this.sMode18 = this.Gx_mode;
this.Gx_mode = StatementType.Select;
this.LoadOsnovaosiguranja();
this.Gx_mode = this.sMode18;
}
else
{
this.RcdFound18 = 0;
}
reader.Close();
}
private void Delete()
{
this.Gx_mode = StatementType.Delete;
this.CheckOptimisticConcurrencyOsnovaosiguranja();
this.OnDeleteControlsOsnovaosiguranja();
this.AfterConfirmOsnovaosiguranja();
ReadWriteCommand command = this.connDefault.GetCommand("DELETE FROM [OSNOVAOSIGURANJA] WHERE [IDOSNOVAOSIGURANJA] = @IDOSNOVAOSIGURANJA", false);
if (command.IDbCommand.Parameters.Count == 0)
{
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSNOVAOSIGURANJA", DbType.String, 2));
}
command.ErrorMask |= ErrorMask.ForeignKeyError;
command.SetParameterString(0, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["IDOSNOVAOSIGURANJA"]));
command.ExecuteStmt();
if (command.ForeignKeyError)
{
this.CheckDeleteErrorsOsnovaosiguranja();
}
this.OnOSNOVAOSIGURANJAUpdated(new OSNOVAOSIGURANJAEventArgs(this.rowOSNOVAOSIGURANJA, StatementType.Delete));
this.rowOSNOVAOSIGURANJA.Delete();
this.sMode18 = this.Gx_mode;
this.Gx_mode = StatementType.Delete;
this.Gx_mode = this.sMode18;
}
private void UpdateOsobniodbitak()
{
this.CheckOptimisticConcurrencyOsobniodbitak();
this.CheckExtendedTableOsobniodbitak();
this.AfterConfirmOsobniodbitak();
ReadWriteCommand command = this.connDefault.GetCommand("UPDATE [OSOBNIODBITAK] SET [NAZIVOSOBNIODBITAK]=@NAZIVOSOBNIODBITAK, [FAKTOROSOBNOGODBITKA]=@FAKTOROSOBNOGODBITKA WHERE [IDOSOBNIODBITAK] = @IDOSOBNIODBITAK", false);
if (command.IDbCommand.Parameters.Count == 0)
{
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@NAZIVOSOBNIODBITAK", DbType.String, 100));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@FAKTOROSOBNOGODBITKA", DbType.Currency));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSOBNIODBITAK", DbType.Int32));
}
command.SetParameterString(0, RuntimeHelpers.GetObjectValue(this.rowOSOBNIODBITAK["NAZIVOSOBNIODBITAK"]));
command.SetParameter(1, RuntimeHelpers.GetObjectValue(this.rowOSOBNIODBITAK["FAKTOROSOBNOGODBITKA"]));
command.SetParameter(2, RuntimeHelpers.GetObjectValue(this.rowOSOBNIODBITAK["IDOSOBNIODBITAK"]));
command.ExecuteStmt();
this.OnOSOBNIODBITAKUpdated(new OSOBNIODBITAKEventArgs(this.rowOSOBNIODBITAK, StatementType.Update));
}
private void UpdateOsnovaosiguranja()
{
this.CheckOptimisticConcurrencyOsnovaosiguranja();
this.CheckExtendedTableOsnovaosiguranja();
this.AfterConfirmOsnovaosiguranja();
ReadWriteCommand command = this.connDefault.GetCommand("UPDATE [OSNOVAOSIGURANJA] SET [RAZDOBLJESESMIJEPREKLAPATI]=@RAZDOBLJESESMIJEPREKLAPATI, [NAZIVOSNOVAOSIGURANJA]=@NAZIVOSNOVAOSIGURANJA, [ZAMOOIDOSNOVAOSIGURANJA]=@ZAMOOIDOSNOVAOSIGURANJA WHERE [IDOSNOVAOSIGURANJA] = @IDOSNOVAOSIGURANJA", false);
if (command.IDbCommand.Parameters.Count == 0)
{
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@RAZDOBLJESESMIJEPREKLAPATI", DbType.Boolean));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@NAZIVOSNOVAOSIGURANJA", DbType.String, 100));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ZAMOOIDOSNOVAOSIGURANJA", DbType.String, 2));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSNOVAOSIGURANJA", DbType.String, 2));
}
command.SetParameter(0, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["RAZDOBLJESESMIJEPREKLAPATI"]));
command.SetParameter(1, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["NAZIVOSNOVAOSIGURANJA"]));
command.SetParameter(2, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["ZAMOOIDOSNOVAOSIGURANJA"]));
command.SetParameterString(3, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["IDOSNOVAOSIGURANJA"]));
command.ExecuteStmt();
this.OnOSNOVAOSIGURANJAUpdated(new OSNOVAOSIGURANJAEventArgs(this.rowOSNOVAOSIGURANJA, StatementType.Update));
}
private void InsertOsobniodbitak()
{
this.CheckOptimisticConcurrencyOsobniodbitak();
this.CheckExtendedTableOsobniodbitak();
this.AfterConfirmOsobniodbitak();
ReadWriteCommand command = this.connDefault.GetCommand("INSERT INTO [OSOBNIODBITAK] ([IDOSOBNIODBITAK], [NAZIVOSOBNIODBITAK], [FAKTOROSOBNOGODBITKA]) VALUES (@IDOSOBNIODBITAK, @NAZIVOSOBNIODBITAK, @FAKTOROSOBNOGODBITKA)", false);
if (command.IDbCommand.Parameters.Count == 0)
{
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSOBNIODBITAK", DbType.Int32));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@NAZIVOSOBNIODBITAK", DbType.String, 100));
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@FAKTOROSOBNOGODBITKA", DbType.Currency));
}
command.ErrorMask |= ErrorMask.DuplicateKeyError;
command.SetParameter(0, RuntimeHelpers.GetObjectValue(this.rowOSOBNIODBITAK["IDOSOBNIODBITAK"]));
command.SetParameterString(1, RuntimeHelpers.GetObjectValue(this.rowOSOBNIODBITAK["NAZIVOSOBNIODBITAK"]));
command.SetParameter(2, RuntimeHelpers.GetObjectValue(this.rowOSOBNIODBITAK["FAKTOROSOBNOGODBITKA"]));
command.ExecuteStmt();
if (command.DupKey)
{
throw new OSOBNIODBITAKDuplicateKeyException(this.resourceManager.GetString("noupdate"));
}
this.OnOSOBNIODBITAKUpdated(new OSOBNIODBITAKEventArgs(this.rowOSOBNIODBITAK, StatementType.Insert));
}
private void CheckOptimisticConcurrencyOsnovaosiguranja()
{
if (this.Gx_mode != StatementType.Insert)
{
ReadWriteCommand command = this.connDefault.GetCommand("SELECT [IDOSNOVAOSIGURANJA], [RAZDOBLJESESMIJEPREKLAPATI], [NAZIVOSNOVAOSIGURANJA], [ZAMOOIDOSNOVAOSIGURANJA] AS ZAMOOIDOSNOVAOSIGURANJA FROM [OSNOVAOSIGURANJA] WITH (UPDLOCK) WHERE [IDOSNOVAOSIGURANJA] = @IDOSNOVAOSIGURANJA ", false);
if (command.IDbCommand.Parameters.Count == 0)
{
command.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOSNOVAOSIGURANJA", DbType.String, 2));
}
command.SetParameterString(0, RuntimeHelpers.GetObjectValue(this.rowOSNOVAOSIGURANJA["IDOSNOVAOSIGURANJA"]));
IDataReader reader = command.FetchData();
if (command.Locked)
{
reader.Close();
throw new OSNOVAOSIGURANJADataLockedException(string.Format(CultureInfo.InvariantCulture, this.resourceManager.GetString("lock"), new object[] { this.resourceManagerTables.GetString("OSNOVAOSIGURANJA") }));
}
if ((!command.HasMoreRows || !this.m__RAZDOBLJESESMIJEPREKLAPATIOriginal.Equals(RuntimeHelpers.GetObjectValue(this.dsDefault.Db.GetBoolean(reader, 1)))) || (!StringUtil.ObjectStringEquals(RuntimeHelpers.GetObjectValue(this.m__NAZIVOSNOVAOSIGURANJAOriginal), RuntimeHelpers.GetObjectValue(this.dsDefault.Db.GetString(reader, 2))) || !StringUtil.ObjectStringEquals(RuntimeHelpers.GetObjectValue(this.m__ZAMOOIDOSNOVAOSIGURANJAOriginal), RuntimeHelpers.GetObjectValue(this.dsDefault.Db.GetString(reader, 3)))))
{
reader.Close();
throw new OSNOVAOSIGURANJADataChangedException(string.Format(CultureInfo.InvariantCulture, this.resourceManager.GetString("waschg"), new object[] { this.resourceManagerTables.GetString("OSNOVAOSIGURANJA") }));
}
reader.Close();
}
}