private void RegjistroDergese(int derguar, int paderguar) { //regjistrimi i dergeses string strSql = "INSERT INTO DERGESA VALUES('" + DateTime.Now.ToString("yyyy-MM-dd") + "', " + derguar + ", " + paderguar + ",'Shkolla Manager')"; conObject.ExecuteNonQuery(strSql); //modifikimi i llogarise int nr = derguar; int i = 0; strSql = "SELECT *, (SASIA - KONSUMUAR) AS MBETUR FROM BLERJE WHERE (SASIA - KONSUMUAR) > 0"; DataSet dsBlerje = conObject.ExecuteQuery(strSql); while (nr > 0) { int sasiaMod = Convert.ToInt32(dsBlerje.Tables[0].Rows[i]["MBETUR"]); int idBlerja = Convert.ToInt32(dsBlerje.Tables[0].Rows[i]["ID_BLERJE"]); if (nr >= sasiaMod) { strSql = "UPDATE BLERJE SET KONSUMUAR = SASIA WHERE ID_BLERJE = " + idBlerja; conObject.ExecuteNonQuery(strSql); } else { strSql = "UPDATE BLERJE SET KONSUMUAR = KONSUMUAR + " + nr + " WHERE ID_BLERJE = " + idBlerja; conObject.ExecuteNonQuery(strSql); } nr = nr - sasiaMod; i++; } KonvertoSinkronizoNeWebDergesa(); KonvertoSinkronizoNeWebBlerje(); }
private void btnDergo_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; Random rnd = new Random(); int alg = rnd.Next(5); alg = alg + 1; //regjistro kerkese ne bazen e te dhenave DateTime dtTani = DateTime.Now; string strSql = "INSERT INTO KERKESA VALUES('" + dtTani.ToString("yyyy-MM-dd HH:mm") + "'," + numSMS.Value.ToString() + ", " + alg.ToString() + ")"; conObject.ExecuteNonQuery(strSql); KonvertoSinkronizoNeWebKerkesa(); strSql = "SELECT MAX(ID_KERKESA) AS MAX FROM KERKESA"; DataSet dsMax = conObject.ExecuteQuery(strSql); int idKerkesa = Convert.ToInt32(dsMax.Tables[0].Rows[0][0]); //dergo email DergoEmail(idKerkesa, dtTani, Convert.ToInt32(numSMS.Value), alg); MessageBox.Show("Kërkesa juaj u dërgua!" + Environment.NewLine + "Do të njoftoheni me email për mënyrën se si mund ta aktivizoni kërkesën e sapodërguar!", Text, MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { this.Cursor = Cursors.Default; } }