protected void btngive_Click(object sender, EventArgs e)
    {
        DateTime d1 = DateTime.Now;



        AJ_DataClass ajdbClass = new AJ_DataClass();
        DataSet      ds        = new DataSet();

        string qryUpdate = "update tblRequestForBlood set tRecieved='true',tReceivedDate='" + DateTime.Now.ToShortDateString() + "' " +
                           " where t_id='" + hftid.Value + "'";

        lblmsg.Text = ajdbClass.UpdateDatabase(qryUpdate);

        string qryUpdate2_rejectOtherRequests = "update tblRequestForBlood set tRecieved='false',tRejected='true',tRejectionReason='Donor is not Eligible Now' " +
                                                " where tDonor_id='" + _UserID + "' and t_id <> '" + hftid.Value + "' and tAcceptedbyDonor='false'";

        lblmsg.Text = ajdbClass.UpdateDatabase(qryUpdate2_rejectOtherRequests);

        string qryUpdateDnrEligibilityDate = "Update tblRegister set RBloodPointDate='" + d1.ToShortDateString() + "' " +
                                             " where r_id='" + _UserID + "'";

        lblmsg.Text = ajdbClass.UpdateDatabase(qryUpdateDnrEligibilityDate);

        btngive.Enabled = false;
    }
    //protected void btnUpdate_Click(object sender, EventArgs e)

    //{

    //    string _isAcceptor = "false";
    //    string _isDonor = "false";
    //    if (chkAcceptor.Checked == true) _isAcceptor = "True";
    //    if (chkDonor.Checked == true) _isDonor = "True";

    //    AJ_DataClass ajdbClass = new AJ_DataClass();
    //    string updateQry = "update tblRegister set rName = '" + txtName.Text.Replace("'", "''").Trim() + "'," +
    //    "rcontact='" + txtcontact.Text.Trim().Replace("'", "''") + "'," +
    //    "raddress='" + txtaddr.Text.Trim().Replace("'", "''") + "'," +
    //    "rbl_id='" + cboBGroup.SelectedValue + "'," +
    //    "rct_id='" + cboCities.SelectedValue + "'," +
    //    "rgender='" + cboGender.SelectedValue + "'," +
    //    "risAcceptor='" + _isAcceptor + "'," +
    //    "risDonor='" + _isDonor + "' " +
    //    "  where r_id='" + _UserID + "'";
    //    lblmsg.Text = ajdbClass.UpdateDatabase(updateQry);



    //}

    protected void btnchngPwd_Click(object sender, EventArgs e)
    {
        if (txtopwd.Text.Trim().Length == 0)
        {
            lblmsg.Text = "Invalid Old Password or User Name ! ";
            txtopwd.Focus();
            return;
        }

        if (txtnpwd.Text.Trim() != txtrpwd.Text.Trim())
        {
            lblmsg.Text = "Password MissMatched !";
            txtrpwd.Focus();
            return;
        }



        AJ_DataClass ajdbClass = new AJ_DataClass();
        string       updateQry = "update tblRegister set rPassword = '******'", "''").Trim() + "' " +
                                 "  where r_id='" + _UserID + "'";

        lblmsg.Text = ajdbClass.UpdateDatabase(updateQry);
        if (lblmsg.Text == "Update Record(s) Succfully")
        {
            lblmsg.Text  = "Password Changed Successfully";
            txtnpwd.Text = "";
            txtopwd.Text = "";
            txtrpwd.Text = "";
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)

    {
        string _isAcceptor = "false";
        string _isDonor    = "false";

        if (chkAcceptor.Checked == true)
        {
            _isAcceptor = "True";
        }
        if (chkDonor.Checked == true)
        {
            _isDonor = "True";
        }

        AJ_DataClass ajdbClass = new AJ_DataClass();
        string       updateQry = "update tblRegister set rName = '" + txtName.Text.Replace("'", "''").Trim() + "'," +
                                 "rcontact='" + txtcontact.Text.Trim().Replace("'", "''") + "'," +
                                 "raddress='" + txtaddr.Text.Trim().Replace("'", "''") + "'," +
                                 "rbl_id='" + cboBGroup.SelectedValue + "'," +
                                 "rct_id='" + cboCities.SelectedValue + "'," +
                                 "rgender='" + cboGender.SelectedValue + "'," +
                                 "risAcceptor='" + _isAcceptor + "'," +
                                 "risDonor='" + _isDonor + "' " +
                                 "  where r_id='" + _UserID + "'";

        lblmsg.Text = ajdbClass.UpdateDatabase(updateQry);
    }
    protected void btnchngPwd_Click(object sender, EventArgs e)
    {
        AJ_DataClass ajdbClass = new AJ_DataClass();
        string       updateQry = "update tblRegister set rPassword = '' " +
                                 "  where r_id='" + _UserID + "'";

        lblmsg.Text = ajdbClass.UpdateDatabase(updateQry);
        if (lblmsg.Text == "Update Record(s) Succfully")
        {
            lblmsg.Text = "Password Changed Successfully";
        }
    }
Пример #5
0
        // update student
        private void btnUpdateStudent_Click(object sender, EventArgs e)
        {
            // if (lblidStud.Text == "0") return;
            string QryUpdate = " FirstName='" + txtfname.Text.Trim().Replace("'", "''") + "', LastName='" + txtlname.Text.Trim().Replace("'", "''")
                               + "', Contact='" + txtcon.Text.Trim().Replace("'", "''") + "', Email='" + txtemail.Text.Trim().Replace("'", "''")
                               + "', RegistrationNumber='" + txtRegNo.Text.Trim().Replace("'", "''") + "', status='" + cmbStatus.SelectedValue + "'";
            string Result = ajdbClass.UpdateDatabase("update Student set " + QryUpdate + " where id='" + lblidStud.Text + "'");
            string qry    = "SELECT        Student.Id, Student.FirstName, Student.LastName, Student.Contact, Student.Email, Student.RegistrationNumber, Lookup.Name, Lookup.LookupId " +
                            " FROM Student INNER JOIN " + " Lookup ON Student.Status = Lookup.LookupId ";

            ajdbClass.popGrid(gvStudents, qry);
            txtfname.Text = "";  txtlname.Text = ""; txtRegNo.Text = ""; txtemail.Text = ""; txtcon.Text = "";
            MessageBox.Show("Record updated successfully");
        }
Пример #6
0
        protected void Page_Load(object sender, EventArgs e)

        {
            AJ_DataClass ajdbClass = new AJ_DataClass();

            if (Request.QueryString["id"].ToString() != null)
            {
                _UserID = Request.QueryString["id"].ToString();
            }

            bool   chef = true;
            string s    = ajdbClass.UpdateDatabase("update [Order] set OdFwdFoodCheff='" + chef + "' where OdId='" + _UserID + "'");


            lblmsg.Text = s + " Order has been sent to chef ";
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            AJ_DataClass ajdbClass = new AJ_DataClass();

            if (Request.QueryString["id"].ToString() != null)
            {
                _UserID = Request.QueryString["id"].ToString();
            }

            bool chef    = true;
            bool deliver = true;
            //   string s = ajdbClass.UpdateDatabase("update clo set name='" + _name + "',dateupdated='" + _dateupdated + "' where id='" + _id + "'");


            string s = ajdbClass.UpdateDatabase("update [Order] set OdFwdFoodCheff='" + chef + "',OdDelivered='" + deliver + "' where OdId='" + _UserID + "'");


            lblmsg.Text = s + " Order has been delivered !!! ";
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            AJ_DataClass ajdbClass = new AJ_DataClass();

            if (Request.QueryString["id"].ToString() != null)
            {
                _UserID = Request.QueryString["id"].ToString();
            }

            bool chef    = true;
            bool deliver = true;
            bool pay     = true;

            string s = ajdbClass.UpdateDatabase("update [Order] set OdFwdFoodCheff='" + chef + "',OdDelivered='" +
                                                deliver + "',OdDeliveredTime='" + DateTime.Now + "',OdPaymentRecieved='" + pay + "' where OdId='" + _UserID + "'");


            lblmsg.Text = s + "  I deliver order and recieve payment !!!";
        }
    protected void btnSetAppointment_Click(object sender, EventArgs e)
    {
        DateTime temp;

        if (DateTime.TryParse(txtdate.Text, out temp))
        {
            lblmsg.Text = "";
        }
        else
        {
            lblmsg.Text = "Invalid Date";
            txtdate.Focus();
            return;
        }

        AJ_DataClass ajdbClass = new AJ_DataClass();
        string       updateQry = "update tblRequestForBlood set tAcceptedbyDonor='true',tMeetingPlace='" + txtPlace.Text.Trim().Replace("'", "''").Trim() + "',tMeetingAddress='" + txtmsg.InnerText + "',tMeetingDate='" + txtdate.Text.Trim().Replace("'", "''").Trim() + "' where t_id='" + hftid.Value + "'";

        lblmsg.Text = ajdbClass.UpdateDatabase(updateQry);
        if (lblmsg.Text.Trim() == "Update Record(s) Succfully")
        {
            btnSetAppointment.Enabled = false;
        }
    }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            int         userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
            GridViewRow row    = (GridViewRow)GridView1.Rows[e.RowIndex];
            Label       lblID  = (Label)row.FindControl("lblID");
            //TextBox txtname=(TextBox)gr.cell[].control[];
            TextBox textName  = (TextBox)row.Cells[1].Controls[0];
            TextBox textprice = (TextBox)row.Cells[2].Controls[0];
            TextBox textqty   = (TextBox)row.Cells[3].Controls[0];

            //TextBox textadd = (TextBox)row.FindControl("txtadd");
            //TextBox textc = (TextBox)row.FindControl("txtc");
            GridView1.EditIndex = -1;
            AJ_DataClass aj = new AJ_DataClass();

            aj.UpdateDatabase("update Purchase set PrName='" + textName.Text + "',PrPrice='" + textprice.Text + "',PrQty='" + textqty.Text + "'where Prid='" + userid + "'");
            //  conn.Open();
            //SqlCommand cmd = new SqlCommand("SELECT * FROM detail", conn);
            //SqlCommand cmd = new SqlCommand("update Purchase set PrName='" + textName.Text + "',PrPrice='" + textprice.Text + "',PrQty='" + textqty.Text + "'where id='" + userid + "'", conn);
            //cmd.ExecuteNonQuery();
            //conn.Close();
            gvbind();
            //GridView1.DataBind();
        }