// add student private void btnAddStudent_Click(object sender, EventArgs e) { string _DataFields = "FirstName,LastName,Contact,Email,RegistrationNumber,Status"; string _Values = "'" + txtfname.Text.Trim().Replace("'", "''") + "','" + txtlname.Text.Trim().Replace("'", "''") + "','" + txtcon.Text.Trim().Replace("'", "''") + "','" + txtemail.Text.Trim().Replace("'", "''") + "','" + txtRegNo.Text.Trim().Replace("'", "''") + "','" + cmbStatus.SelectedValue + "'"; string Result = ajdbClass.InsertIntoDatabase("Student", _DataFields, _Values); 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); txtRubricSetDetails.Text = ""; txtRubricSetLevel.Text = ""; MessageBox.Show(Result); txtfname.Text = ""; txtlname.Text = ""; txtRegNo.Text = ""; txtemail.Text = ""; txtcon.Text = ""; }
protected void BtnUpdate_Click(object sender, EventArgs e) { AJ_DataClass ajdbClass = new AJ_DataClass(); string _catgory = cboCatgory.SelectedValue; string _name = txtname.Text; string _price = txtPrice.Text; string _quantity = txtQty.Text; if (fuImageFile.HasFile) { string picture = fuImageFile.FileName.ToString(); fuImageFile.PostedFile.SaveAs(Server.MapPath("upload/") + picture); string _DataFields = "ICategoryID ,ItName ,ItPrice ,ItPicture,ItQuantity"; string _Values = "'" + _catgory + "','" + _name + "','" + _price + "','" + picture + "','" + _quantity + "'"; string Result = ajdbClass.InsertIntoDatabase("Items", _DataFields, _Values); Label1.Visible = true; Label1.Text = "Items inserted successfully"; txtname.Text = ""; } else { Label1.Visible = true; Label1.Text = "Plz upload the image!!!!"; } }
protected void BtnAdd_Click(object sender, EventArgs e) { if (Session["CurrentUser_ID"] != null) { _id = Session["CurrentUser_ID"].ToString(); AJ_DataClass ajdbClass = new AJ_DataClass(); string _name = txtname.Text; string _price = txtPrice.Text; string _quantity = txtQty.Text; string _DataFields = "PrAdminId,PrName,PrPrice ,PrQty"; string _Values = "'" + _id + "','" + _name + "','" + _price + "','" + _quantity + "'"; string Result = ajdbClass.InsertIntoDatabase("Purchase", _DataFields, _Values); lblmsg.Text = Result; if (Result == "Record(s) Added Successfully") { txtname.Text = ""; txtPrice.Text = ""; txtQty.Text = ""; } } }
protected void btnRegister_Click(object sender, EventArgs e) { AJ_DataClass ajdbClass = new AJ_DataClass(); string _name = txtName.Text; string _email = txtEmail.Text; string _contact = txtcontact.Text; string _addr = txtaddr.Text; string _utype = cboUtype.SelectedItem.ToString(); string _pwd = txtPwd.Text; // Check if user already have an account. *email int trec = ajdbClass.TRec("select * from [User] where UEmail='" + txtEmail.Text.Trim() + "'"); if (trec != 0) { lblmsg.Text = " Email already exists !"; txtEmail.Focus(); return; } else { lblmsg.Text = ""; } if (txtPwd.Text.Trim() != txtPwd2.Text.Trim()) { lblmsg.Text = "Password MissMatched !"; txtPwd2.Focus(); return; } else { lblmsg.Text = ""; } string _DataFields = "UName,UAddress,UCellNo,UEmail, Utype,UPwd"; string _Values = "'" + _name + "','" + _addr + "','" + _contact + "','" + _email + "','" + _utype + "','" + _pwd + "'"; string Result = ajdbClass.InsertIntoDatabase("[User]", _DataFields, _Values); lblmsg.Text = Result; if (Result == "Record(s) Added Successfully") { txtName.Text = ""; txtEmail.Text = ""; txtcontact.Text = ""; txtaddr.Text = ""; txtPwd.Text = ""; } }
protected void btnRegister_Click(object sender, EventArgs e) { AJ_DataClass ajdbClass = new AJ_DataClass(); // check if request is already has been sent to donor by this user string qryCheck = "select * from tblRequestForBlood where tAcceptor_id ='" + _UserID + "' and tDonor_id='" + hfdnrid.Value + "' and tRejected ='false'"; int trec = ajdbClass.TRec(qryCheck); if (trec != 0) { lblmsg.Text = "You already have sent a request for this donor."; return; } else { lblmsg.Text = ""; } string _DataFields = "tAcceptor_id,tDonor_id,tBloodGroup_id,tRequestDate "; string _Values = "'" + _UserID + "','" + hfdnrid.Value + "','" + cbodBGroup.SelectedValue + "','" + DateTime.Now.ToShortDateString() + "'"; string Result = ajdbClass.InsertIntoDatabase("tblRequestForBlood", _DataFields, _Values); lblmsg.Text = Result + " Your request has been sent "; }
protected void btnRegister_Click(object sender, EventArgs e) { AJ_DataClass ajdbClass = new AJ_DataClass(); string _name = txtName.Text; string _bgid = cboBGroup.SelectedValue; string _email = txtEmail.Text; string _ctid = cboCities.SelectedValue; string _gender = cboGender.SelectedValue; string _contact = txtcontact.Text; string _addr = txtaddr.Text; string _pwd = txtPwd.Text; string _isAcceptor = "false"; string _isDonor = "false"; if (chkAcceptor.Checked == true) { _isAcceptor = "True"; } if (chkDonor.Checked == true) { _isDonor = "True"; } string _DataFields = "rname,rbl_id,risAcceptor," + "risdonor,remail,rct_id,rgender,rcontact," + "raddress,rpassword,rDate"; string _Values = "'" + _name + "','" + _bgid + "','" + _isAcceptor + "','" + _isDonor + "','" + _ctid + "','" + _gender + "','" + _contact + "','" + _addr + "','" + _pwd + "','" + DateTime.Now.ToShortDateString() + "'"; string Result = ajdbClass.InsertIntoDatabase("tblRegister", _DataFields, _Values); lblmsg.Text = Result; }
protected void btnRegister_Click(object sender, EventArgs e) { AJ_DataClass ajdbClass = new AJ_DataClass(); string _name = txtName.Text; string _bgid = cboBGroup.SelectedValue; string _email = txtEmail.Text; string _ctid = cboCities.SelectedValue; string _gender = cboGender.SelectedValue; string _contact = txtcontact.Text; string _addr = txtaddr.Text; string _pwd = txtPwd.Text; string _isAcceptor = "false"; string _isDonor = "false"; if (chkAcceptor.Checked == true) { _isAcceptor = "True"; } if (chkDonor.Checked == true) { _isDonor = "True"; } // Check if user alread have an account. *email int trec = ajdbClass.TRec("select * from tblRegister where Remail='" + txtEmail.Text.Trim() + "'"); if (trec != 0) { lblmsg.Text = "User's Email already exists !"; txtEmail.Focus(); return; } else { lblmsg.Text = ""; } if (txtPwd.Text.Trim() != txtPwd2.Text.Trim()) { lblmsg.Text = "Password MissMatched !"; txtPwd2.Focus(); return; } else { lblmsg.Text = ""; } string _DataFields = "rname,rbl_id,risAcceptor," + "risdonor,remail,rct_id,rgender,rcontact," + "raddress,rpassword,rDate"; string _Values = "'" + _name + "','" + _bgid + "','" + _isAcceptor + "','" + _isDonor + "','" + _email + "','" + _ctid + "','" + _gender + "','" + _contact + "','" + _addr + "','" + _pwd + "','" + DateTime.Now.ToShortDateString() + "'"; string Result = ajdbClass.InsertIntoDatabase("tblRegister", _DataFields, _Values); lblmsg.Text = Result; if (Result == "Record(s) Added Succfully") { txtName.Text = ""; txtEmail.Text = ""; txtcontact.Text = ""; txtaddr.Text = ""; txtPwd.Text = ""; chkAcceptor.Checked = false; chkDonor.Checked = false; } }
protected void btnSubmit_Click(object sender, EventArgs e) { //AJ_DataClass ajdbClass = new AJ_DataClass(); //bool chef = false; //bool delivr = false; //string delivrtime = DateTime.Now.ToShortDateString() ; //bool payRec = false; //string _DataFields = "OdUserId,OdDate,OdGtotal ,OdFwdFoodCheff,OdDelivered ,OdDeliveredTime ,OdPaymentRecieved"; //string _Values = "'" + _UserID + "','" + DateTime.Now.ToShortDateString() + "','" + lblgtotal.Text + "','" + // chef + "','" + delivr+ "','" + delivrtime + "','" + payRec + "'"; //string Result = ajdbClass.InsertIntoDatabase("[Order]", _DataFields, _Values); ////"OddOdid" = "OdId"; ////string _itid = "Items.ItId"; ////string _price = "itprice"; ////string _quantity = "itqty"; ////string _total = "ittotal"; ////string _DataField1 = "[OddOdid] ,[Odditid] ,[OddPrice] ,[OddQuantity],[OddTotal]"; ////string _Values1 = "'" + _odid + "','" + _itid + "','" + _price + "','" + //// _quantity + "','" + _total + "'"; ////string Result1 = ajdbClass.InsertIntoDatabase("[OrderDetails]", _DataField1, _Values1); //lblmsg.Text = Result + " Your order has been sent "; AJ_DataClass ajdbClass = new AJ_DataClass(); DataTable dtMyTable_Adr; if (Session["sesOrderTable"] != null) { dtMyTable_Adr = (DataTable)Session["sesOrderTable"]; } else { return; } foreach (DataRow dr in dtMyTable_Adr.Rows) { if (dr["itqty"].ToString().Trim() != "0") { string _DataFields = "OAdminId,OdUserId,OdDate ,OdGtotal,OdFwdFoodCheff ,OdDelivered ,OdDeliveredTime,OdPaymentRecieved "; string _Values = "'1','1','" + DateTime.Now.ToShortDateString() + "','" + lblgtotal.Text + "','0','0','" + DateTime.Now.ToShortDateString() + "','0' "; string Result = ajdbClass.InsertIntoDatabase("[Order]", _DataFields, _Values); lblmsg.Text = Result + " Order has been sent "; } break; } string _lastid = "0"; DataSet ds = new DataSet(); ds = ajdbClass.GetRecords("tbl", "select odid from [Order] "); foreach (DataRow dr in ds.Tables[0].Rows) { _lastid = dr["odid"].ToString().Trim(); } foreach (DataRow dr in dtMyTable_Adr.Rows) { if (dr["itqty"].ToString().Trim() != "0") { string st = dr["itid"].ToString().Trim(); string _DataFields = "OddOdid,Odditid,OddPrice ,OddQuantity,OddTotal "; string _Values = "'" + _lastid + "','" + dr["itid"].ToString().Trim() + "','" + dr["itprice"].ToString().Trim() + "','" + dr["itqty"].ToString().Trim() + "','" + lblgtotal.Text.Trim() + "' "; string Result = ajdbClass.InsertIntoDatabase("OrderDetails", _DataFields, _Values); lblmsg.Text = Result + " Order has been sent "; } } Session["sesOrderTable"] = null; Session["sestitmes"] = null; Session["sesgtotal"] = null; // Response.Redirect("FoodMenuMyOrder.aspx"); }