protected void btnSave_Click(object sender, EventArgs e) { DateTime date = DateTime.Today; paperObj = new BllPaperComparison(); string strCount = "Select Count(PID) from PCOMPARE where PAPERNAME='" + txtName.Text + "'"; int RowNumber = Convert.ToInt32(dataProvider.getResultString(strCount)); if (RowNumber == 0) { //paperObj.Id = Convert.ToInt32(txtId.Text); paperObj.Name = txtName.Text; paperObj.PaperType = ddlPaperType.SelectedItem.Text; paperObj.PaperPrice = txtPaperPrc.Text; DateTime Date = date; string user = (string)Session["UserName"]; paperObj.Status = Convert.ToInt32(rdbtnActive.SelectedValue); paperObj.SortOrder = Convert.ToInt32(txtSortingOrder.Text); paperObj.Save(paperObj, user, Date); ClientScript.RegisterStartupScript(GetType(), "Message", "<script language='javascript'>alert('Data inserted Successfully')</script>"); Clear(); } else { ClientScript.RegisterStartupScript(GetType(), "Message", "<script language='javascript'>alert('Data already exists')</script>"); } DisplayData(); }
private void DisplayData() { paperObj = new BllPaperComparison(); DataTable dt = paperObj.DisplayData(); gridView.DataSource = dt; gridView.DataBind(); }
protected void btnUpdate_Click(object sender, EventArgs e) { int pId = Convert.ToInt32(txtId.Text); string pName = txtName.Text; string PaperType = ddlPaperType.SelectedItem.Text; string PaperPrice = txtPaperPrc.Text; //string auditor = (string)Session["UserName"]; int status = Convert.ToInt32(rdbtnActive.SelectedValue); int sortOrder = Convert.ToInt32(txtSortingOrder.Text); paperObj = new BllPaperComparison(); paperObj.Update(pId, pName, PaperType, PaperPrice, status, sortOrder); Clear(); DisplayData(); }
public void Save(BllPaperComparison paperObj, string user, DateTime Date) { XMLConnection = new clsConnection(); con = XMLConnection.ConnectByXML(); SqlCommand cmd = new SqlCommand("spPCompare", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); cmd.Parameters.Add("@Flag", SqlDbType.TinyInt).Value = 1; cmd.Parameters.Add("@PID", SqlDbType.Int).Value = paperObj.Id; cmd.Parameters.Add("@PAPERNAME", SqlDbType.VarChar).Value = paperObj.Name; cmd.Parameters.Add("@PAPERTYPE", SqlDbType.VarChar).Value = paperObj.PaperType; cmd.Parameters.Add("@PAPERPRICE", SqlDbType.VarChar).Value = paperObj.PaperPrice; cmd.Parameters.Add("@DATES", SqlDbType.Date).Value = Date; cmd.Parameters.Add("@AUDITOR", SqlDbType.VarChar).Value = user; cmd.Parameters.Add("@USTATUS", SqlDbType.Int).Value = paperObj.Status; cmd.Parameters.Add("@sortOrder", SqlDbType.Int).Value = paperObj.SortOrder; cmd.ExecuteNonQuery(); }
public void Save(BllPaperComparison paperObj, string user, DateTime Date) { paperComapre = new DalPaperComparison(); paperComapre.Save(paperObj, user, Date); }