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);
}
