public void Podaci_o_zadnjem_Obracunu()
{
SqlConnection connection = new SqlConnection();
SqlCommand command = new SqlCommand();
connection.ConnectionString = Mipsed7.Core.ApplicationDatabaseInformation.ConnectionString;
command.Connection = connection;
command.CommandText = "select max(idobracun) from obracun";
connection.Open();
try
{
SqlDataReader reader = command.ExecuteReader();
reader.Read();
if (!reader.IsDBNull(0))
{
OBRACUNDataAdapter adapter = new OBRACUNDataAdapter();
OBRACUNDataSet dataSet = new OBRACUNDataSet();
adapter.FillByIDOBRACUN(dataSet, reader.GetString(0));
this.mjesecobracuna.Value = RuntimeHelpers.GetObjectValue(dataSet.OBRACUN.Rows[0]["mjesecobracuna"]);
this.godinaobracuna.Value = RuntimeHelpers.GetObjectValue(dataSet.OBRACUN.Rows[0]["godinaobracuna"]);
this.mjesecisplate.Value = RuntimeHelpers.GetObjectValue(dataSet.OBRACUN.Rows[0]["mjesecisplate"]);
this.godinaisplate.Value = RuntimeHelpers.GetObjectValue(dataSet.OBRACUN.Rows[0]["godinaisplate"]);
this.mjesecnifond.Value = RuntimeHelpers.GetObjectValue(dataSet.OBRACUN.Rows[0]["mjesecnifondsatiobracun"]);
this.tjednifond.Value = RuntimeHelpers.GetObjectValue(dataSet.OBRACUN.Rows[0]["tjednifondsatiobracun"]);
//22.12.2016. --> ovo se mijenja radi novog izračuna plaća
//this.osnovnioo.Value = RuntimeHelpers.GetObjectValue(dataSet.OBRACUN.Rows[0]["osnovnioo"]);
this.osnovnioo.Value = Convert.ToDecimal(3800); //--> OVO IDE TEK SA 1.1.2017
this.osnovnioo.ReadOnly = true;
this.obrosnovica.Value = RuntimeHelpers.GetObjectValue(dataSet.OBRACUN.Rows[0]["obracunskaosnovica"]);
this.txtOpisObracuna.Value = "";
}
else
{
this.mjesecobracuna.Value = RuntimeHelpers.GetObjectValue(Interaction.IIf(DateAndTime.Today.Month == 1, 12, DateAndTime.Today.Month - 1));
this.godinaobracuna.Value = RuntimeHelpers.GetObjectValue(Interaction.IIf(DateAndTime.Today.Month == 1, DateAndTime.Today.Year - 1, DateAndTime.Today.Year));
this.mjesecisplate.Value = DateTime.Now.Month;
this.godinaisplate.Value = DateTime.Now.Year;
this.mjesecobracuna.Value = DB.BrojVodeceNule(this.mjesecobracuna, 2, 0, false, "");
this.mjesecisplate.Value = DB.BrojVodeceNule(this.mjesecisplate, 2, 0, false, "");
this.godinaobracuna.Value = DB.BrojVodeceNule(this.godinaobracuna, 4, 0, false, "");
this.godinaisplate.Value = DB.BrojVodeceNule(this.godinaisplate, 4, 0, false, "");
this.mjesecnifond.Value = 160;
this.tjednifond.Value = 40;
//this.osnovnioo.Value = 0x708;
this.osnovnioo.Value = Convert.ToDecimal(3800); //--> Ovo je slučaj kad nema prethodnog obračuna
this.osnovnioo.ReadOnly = true;
this.obrosnovica.Value = 5108.84;
this.txtOpisObracuna.Value = " ";
}
}
catch (System.Exception exception1)
{
throw exception1;
}
connection.Close();
}
public virtual void Fill()
{
this.PreFill();
this.dsOBRACUNDataSet1 = new OBRACUNDataSet();
this.m_StartRow = 0;
this.Cursor = Cursors.WaitCursor;
this.m_GridLoading = true;
ThreadPool.QueueUserWorkItem(new WaitCallback(this.FillDataThread), Thread.CurrentPrincipal);
}
private void Obrisi()
{
this.cm = (CurrencyManager)this.BindingContext[this.PregledObracunaDataSet1, "PregledObracuna"];
if (this.cm.Count != 0)
{
if (Operators.ConditionalCompareObjectEqual(this.drv["zaklj"], true, false))
{
Interaction.MsgBox("Obračun je zaključan! Brisanje nije moguće!", MsgBoxStyle.Critical, "Obračun plaća");
}
else
{
this.drv = (DataRowView)this.cm.Current;
if (Conversions.ToString(this.drv["idobracun"]) == this.Sifra_Zadnjeg_Obracuna(Conversions.ToString(this.drv["mjesecisplate"]), Conversions.ToString(this.drv["godinaisplate"])))
{
if (Interaction.MsgBox("Molim da potvrdite brisanje obračuna!", MsgBoxStyle.YesNo, null) == MsgBoxResult.Yes)
{
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection {
ConnectionString = Configuration.ConnectionString
};
command.Connection = connection;
command.CommandType = CommandType.Text;
connection.Open();
command.CommandText = "DELETE FROM RSMA1 WHERE IDENTIFIKATOROBRASCA = '" + DB.N2T(RuntimeHelpers.GetObjectValue(this.drv["IDENTIFIKATOROBRASCA"]), "") + "'";
command.ExecuteNonQuery();
command.CommandText = "DELETE FROM RSMA WHERE IDENTIFIKATOROBRASCA = '" + DB.N2T(RuntimeHelpers.GetObjectValue(this.drv["IDENTIFIKATOROBRASCA"]), "") + "'";
command.ExecuteNonQuery();
connection.Close();
OBRACUNDataSet set = new OBRACUNDataSet();
this.ObrisiObracun(Conversions.ToString(this.drv["idobracun"]));
this.drv.Delete();
this.drv = null;
}
}
else
{
Interaction.MsgBox("Brisanje obračuna nije moguće!", MsgBoxStyle.OkOnly, null);
}
}
}
}
private void Obrisi()
{
this.cm = (CurrencyManager)this.BindingContext[this.V_DD_PREGLED_OBRACUNADataSet1, "V_DD_PREGLED_OBRACUNA"];
if (this.cm.Count != 0)
{
this.drv = (DataRowView)this.cm.Current;
string mjesecisplate = this.drv["ddobracunidobracun"].ToString().Substring(5, 2);
string godinaisplate = this.drv["ddobracunidobracun"].ToString().Substring(0, 4);
if (Operators.ConditionalCompareObjectEqual(this.drv["ddobracunidobracun"], this.zadnji_obracun(mjesecisplate, godinaisplate), false))
{
if (Interaction.MsgBox("Molim da potvrdite brisanje obračuna!", MsgBoxStyle.YesNo, null) == MsgBoxResult.Yes)
{
OBRACUNDataSet set = new OBRACUNDataSet();
this.ObrisiObracun(Conversions.ToString(this.drv["ddobracunidobracun"]));
this.drv.Delete();
this.drv = null;
}
}
else
{
Interaction.MsgBox("Brisanje obračuna nije moguće!", MsgBoxStyle.OkOnly, null);
}
}
}
