public void insertPliromi(Pliromi myPliromi) { SqlCommand cmd = new SqlCommand("add_pliromi", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@payDate", myPliromi.PayDay); cmd.Parameters.AddWithValue("@payType", myPliromi.pmid); cmd.Parameters.AddWithValue("@poso", myPliromi.Poso); cmd.Parameters.AddWithValue("@paid", myPliromi.Paid); cmd.Parameters.AddWithValue("@opid", myPliromi.Pliromi_opid); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { string exmsg = ex.Message.ToString(); } finally { conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { BLayer myBlayer = new BLayer(); Pliromi myPliromi = new Pliromi(); Oplitis myOplitis = new Oplitis(); myPliromi = myBlayer.get_Last_Pliromi(); aaPliromis.Text = myPliromi.PliromiId.ToString(); priromiDate.Text = myPliromi.PayDay.ToString(); payDate.Text = myPliromi.PayDay.ToString(); asm.Text = myPliromi.p_opasm.ToString(); rank.Text = myPliromi.bathmos.ToString(); fname.Text = myPliromi.onoma.ToString(); lname.Text = myPliromi.eponymo.ToString(); loxos.Text = myPliromi.loxos.ToString(); katigoria.Text = myPliromi.katName.ToString(); katalogisteo.Text = myPliromi.katalogisteo.ToString(); kratiseis.Text = myPliromi.kratiseis.ToString(); pliroteo.Text = myPliromi.pliroteo.ToString(); payType.Text = myPliromi.mPerigrafi.ToString(); opid.Text = myPliromi.Pliromi_opid.ToString(); posoPliromis.Text = myPliromi.Poso.ToString(); myOplitis.id = Convert.ToInt32(opid.Text); SqlDataReader myDtr = myBlayer.get_dikaiologitika_pou_exei_proskomisei_by_id(myOplitis); dikaiologitika.DataSource = myDtr; dikaiologitika.DataBind(); } }
public Pliromi get_Pliromi_By_Id(Pliromi myPliromi) { Dal myDal = new Dal(); Pliromi otherPliromi = new Pliromi(); DataTable dt = new DataTable(); SqlDataReader dr = myDal.getPliromiById(myPliromi); if (dr.HasRows) { dt.Load(dr); } foreach (DataRow row in dt.Rows) { otherPliromi.Pliromi_opid = Convert.ToInt32(row["op_id"].ToString()); otherPliromi.PliromiId = Convert.ToInt32(row["p_id"].ToString()); otherPliromi.PayDay = Convert.ToDateTime(row["p_date"].ToString()); otherPliromi.p_opasm = Convert.ToInt32(row["op_asm"].ToString()); otherPliromi.bathmos = row["r_perigrafi"].ToString(); otherPliromi.onoma = row["op_onoma"].ToString(); otherPliromi.eponymo = row["op_eponymo"].ToString(); otherPliromi.loxos = row["op_loxos"].ToString(); otherPliromi.katName = row["kat_name"].ToString(); otherPliromi.katalogisteo = Convert.ToDecimal(row["kat_katalogisteo"].ToString()); otherPliromi.kratiseis = Convert.ToDecimal(row["kat_kratiseis"].ToString()); otherPliromi.pliroteo = Convert.ToDecimal(row["kat_pliroteo"].ToString()); otherPliromi.mPerigrafi = row["m_perigrafi"].ToString(); float temp = Convert.ToSingle(row["p_posoPliromis"].ToString()); otherPliromi.Poso = Convert.ToDecimal(temp); } return(otherPliromi); }
public decimal anadromikaCalcLogoApousias(Oplitis myOplitis) { BLayer myBlayer = new BLayer(); Katigoria category = new Katigoria(); category = myBlayer.get_Katigoria_By_Id(myOplitis); decimal poso = category.katPliroteo; Pliromi myPliromi = new Pliromi(); myPliromi = myBlayer.get_Last_Pliromi_By_Opid(myOplitis); DateTime lastPayDate = myPliromi.PayDay; DateTime currentDate = DateTime.Now; int diafora = currentDate.Month - lastPayDate.Month; decimal anadromika = diafora * poso; return(anadromika); }
protected void saveButton_Click(object sender, EventArgs e) { try { BLayer myBlayer = new BLayer(); Pliromi myPliromi = new Pliromi(); myPliromi.PayDay = Convert.ToDateTime(priromiDate.Text); myPliromi.pmid = Convert.ToInt32(RadioButtonListMisthodType.SelectedValue);// na val0 an o allos den epilexei bathmo na epilegei automata ton bathmo strti myPliromi.Poso = Convert.ToDecimal(posoPliromis.Text); myPliromi.Paid = Convert.ToBoolean(1); myPliromi.Pliromi_opid = Convert.ToInt32(aa.Text); myBlayer.add_Pliromi(myPliromi); Response.Redirect("anafora_pliromis.aspx"); } catch (Exception ex) { error.Visible = true; error.Text = ex.Message.ToString(); } }
public SqlDataReader getPliromiById(Pliromi myPliromi) { SqlCommand cmd = new SqlCommand("get_last_pliromi_by_id", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pid", myPliromi.PliromiId); SqlDataReader myDtr = null; try { myDtr = cmd.ExecuteReader(); } catch (Exception ex) { ex.ToString(); } return(myDtr); }
protected void logosAnadromikon_SelectedIndexChanged(object sender, EventArgs e) { BLayer myBlayer = new BLayer(); error3.Visible = false; anadromika.Text = string.Empty; posoPliromis.Text = string.Empty; if (logosAnadromikon.SelectedIndex == 0) { panelAllagiKatigorias.Visible = true; panelApousias.Visible = false; anadromikaCalculate.Visible = true; } else if (logosAnadromikon.SelectedIndex == 1) { panelApousias.Visible = true; anadromikaCalculate.Visible = true; panelAllagiKatigorias.Visible = false; DateTime mydatetime = new DateTime(); mydatetime = DateTime.Now; currentDate.Text = mydatetime.Day.ToString() + "/" + mydatetime.Month.ToString() + "/" + mydatetime.Year.ToString(); Pliromi otherPliromi = new Pliromi(); otherOplitis.id = Convert.ToInt32(aa.Text); otherPliromi = myBlayer.get_Last_Pliromi_By_Opid(otherOplitis); lastPliromiDate.Text = otherPliromi.PayDay.ToString(); if (Convert.ToDateTime(currentDate.Text) == Convert.ToDateTime(lastPliromiDate.Text)) { anadromikaCalculate.Visible = false; error3.Visible = true; error3.Text = "Ο επιλεγμένος οπλίτης δεν δικαιούται αναδρομικά λόγω απουσίας!"; } else { anadromikaCalculate.Visible = true; error3.Visible = false; } } }
public Pliromi get_Last_Pliromi_By_Opid(Oplitis myOplitis) { Dal myDal = new Dal(); Pliromi myPliromi = new Pliromi(); DataTable dt = new DataTable(); SqlDataReader dr = myDal.getLastPliromiByOpid(myOplitis); if (dr.HasRows) { dt.Load(dr); } foreach (DataRow row in dt.Rows) { myPliromi.Pliromi_opid = Convert.ToInt32(row["op_id"].ToString()); myPliromi.PliromiId = Convert.ToInt32(row["p_id"].ToString()); myPliromi.PayDay = Convert.ToDateTime(row["p_date"].ToString()); myPliromi.p_opasm = Convert.ToInt32(row["op_asm"].ToString()); myPliromi.bathmos = row["r_perigrafi"].ToString(); myPliromi.onoma = row["op_onoma"].ToString(); myPliromi.eponymo = row["op_eponymo"].ToString(); myPliromi.loxos = row["op_loxos"].ToString(); myPliromi.katName = row["kat_name"].ToString(); myPliromi.katalogisteo = Convert.ToDecimal(row["kat_katalogisteo"].ToString()); myPliromi.kratiseis = Convert.ToDecimal(row["kat_kratiseis"].ToString()); myPliromi.pliroteo = Convert.ToDecimal(row["kat_pliroteo"].ToString()); myPliromi.mPerigrafi = row["m_perigrafi"].ToString(); if (string.IsNullOrEmpty(row["p_posoPliromis"].ToString())) { myPliromi.Poso = Convert.ToDecimal("0,00"); } else { myPliromi.Poso = Convert.ToDecimal(row["p_posoPliromis"].ToString()); } } return(myPliromi); }
public void add_Pliromi(Pliromi myPliromi) { Dal myDal = new Dal(); myDal.insertPliromi(myPliromi); }