protected void btnpreviewLabel_Click(object sender, EventArgs e)
{
clsConnection dbCon = new clsConnection();
SqlConnection con = new SqlConnection();
//using (SqlConnection con = new SqlConnection())
//{
con = dbCon.ConnectByXML();
con.Open();
using (SqlCommand cmd = new SqlCommand("SPLabel", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FrmDate", SqlDbType.DateTime).Value = txtfrmDate.Text;
cmd.Parameters.Add("@ToDate", SqlDbType.DateTime).Value = txtTodate.Text;
cmd.Parameters.Add("@Irns", SqlDbType.Int).Value = txtNewsReg.Text;
cmd.Parameters.Add("@Imns", SqlDbType.Int).Value = txtNewsMax.Text;
cmd.Parameters.Add("@Ircs", SqlDbType.Int).Value = txtSuppReg.Text;
cmd.Parameters.Add("@Imcs", SqlDbType.Int).Value = txtSupplementMax.Text;
cmd.Parameters.Add("@Crns", SqlDbType.Int).Value = txtRegSize.Text;
cmd.Parameters.Add("@Cmns", SqlDbType.Int).Value = txtMaxSize.Text;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = ddlCategory.SelectedItem.Text;
cmd.ExecuteNonQuery();
}
// }
LoadReport();
}
protected void Page_Load(object sender, EventArgs e)
{
con = dbCon.ConnectByXML();
con.Open();
con.Close();
if (!IsPostBack)
{
BindddlCategory();
}
clsHelper.CheckLogin();
}
public DataTable DisplayData()
{
XMLConnection = new clsConnection();
con = XMLConnection.ConnectByXML();
SqlCommand cmd = new SqlCommand("spPCompare", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 2);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public void ExecuteCommand(string MyQuery)
{
con = dbCon.ConnectByXML();
con.Open();
SqlCommand sqlComm = new SqlCommand(MyQuery, con);
//sqlComm.CommandType = CommandType.Text;
sqlComm.ExecuteNonQuery();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
con = dbCon.ConnectByXML();
con.Open();
con.Close();
PressWiseAvg();
//countAdv();
DivisionWiseProduction();
DailyProduction();
//topAdvertiserStatus();
//topCustomerStatus();
//topSectorStatus();
//salesComparison();
}
protected void Page_Load(object sender, EventArgs e)
{
con = dbCon.ConnectByXML();
con.Open();
con.Close();
if (!IsPostBack)
{
bindRM();
bindCustomer();
bindStation();
bindRMID();
//bindCusID();
//bindStatID();
// bindfrmDb();
}
clsHelper.CheckLogin();
}
public void Update(int pId, string pName, string PaperType, string PaperPrice, int status, int sortOrder)
{
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 = 3;
cmd.Parameters.Add("@PAPERNAME", SqlDbType.VarChar).Value = pName;
cmd.Parameters.Add("@PAPERTYPE", SqlDbType.VarChar).Value = PaperType;
cmd.Parameters.Add("@PAPERPRICE", SqlDbType.VarChar).Value = PaperPrice;
//cmd.Parameters.Add("@AUDITOR", SqlDbType.VarChar).Value = auditor;
cmd.Parameters.Add("@USTATUS", SqlDbType.Int).Value = status;
cmd.Parameters.Add("@PID", SqlDbType.Int).Value = pId;
cmd.Parameters.Add("@sortOrder", SqlDbType.Int).Value = sortOrder;
cmd.ExecuteNonQuery();
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
con = dbCon.ConnectByXML();
con.Open();
con.Close();
if (!IsPostBack)
{
bindddlStationName();
//loadData();
//DdlHH();
//DdlMM();
//RaedData();
bindReason();
}
clsHelper.CheckLogin();
}
public DALContractDeed()
{
XMLConnection = new clsConnection();
con = XMLConnection.ConnectByXML();
}
protected void btnPreview_Click(object sender, EventArgs e)
{
string strSelect = "";
con = dbCon.ConnectByXML();
con.Open();
strSelect = "Select * from UnsoldReport where returnDate between '" + txtReturnDateFrom.Text + "' and '" + txtReturnDateTo.Text + "'";
if (txtCustomaerName.Text != "All" && txtCustomaerName.Text != "")
{
strSelect = strSelect + "AND hkrNameEng='" + txtCustomaerName.Text + "'";
}
if (ddlRmname.SelectedItem.Text != "--Select--")
{
strSelect = strSelect + "AND rmName='" + ddlRmname.SelectedItem.Text + "'";
}
strSelect = strSelect + "Order By sortingOrder asc";
if (ddlReportName.SelectedItem.Text == "Serial Report")
{
DataSet ds = new DataSet();
ds = dataProvider.getDataSet(strSelect, "UnsoldReport");
report.Load(Server.MapPath("Report\\Unsold.rpt"));
report.SetDataSource(ds);
report.SetDatabaseLogon("abomuser", "erp", "192.168.10.75", "ALOCIR");
if (ddlExportType.SelectedItem.Text == "Pdf")
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath("Report/Unsold.pdf"));
ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var popup=window.open('Report/Unsold.pdf');popup.focus();", true);
}
else if (ddlExportType.SelectedItem.Text == "Excel")
{
report.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.ExcelRecord, Page.Response, false, "UnsoldReport");
}
else
{
report.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.RichText, Page.Response, false, "UnsoldReport");
}
}
else if (ddlReportName.SelectedItem.Text == "Executive Wise")
{
DataSet ds = new DataSet();
ds = dataProvider.getDataSet(strSelect, "UnsoldReport");
report.Load(Server.MapPath("Report\\ExecutiveUnsold.rpt"));
report.SetDataSource(ds);
report.SetDatabaseLogon("abomuser", "erp", "192.168.10.75", "ALOCIR");
if (ddlExportType.SelectedItem.Text == "Pdf")
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath("Report/ExecutiveUnsold.pdf"));
ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var popup=window.open('Report/ExecutiveUnsold.pdf');popup.focus();", true);
}
else if (ddlExportType.SelectedItem.Text == "Excel")
{
report.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.ExcelRecord, Page.Response, false, "ExecutiveUnsold");
}
else
{
report.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.RichText, Page.Response, false, "ExecutiveUnsold");
}
}
else
{
DataSet ds = new DataSet();
ds = dataProvider.getDataSet(strSelect, "UnsoldReport");
report.Load(Server.MapPath("Report\\ExecutiveUnsoldSummary.rpt"));
report.SetDataSource(ds);
report.SetDatabaseLogon("abomuser", "erp", "192.168.10.75", "ALOCIR");
if (ddlExportType.SelectedItem.Text == "Pdf")
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath("Report/ExecutiveUnsoldSummary.pdf"));
ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var popup=window.open('Report/ExecutiveUnsoldSummary.pdf');popup.focus();", true);
}
else if (ddlExportType.SelectedItem.Text == "Excel")
{
report.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.ExcelRecord, Page.Response, false, "ExecutiveUnsoldSummary");
}
else
{
report.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.RichText, Page.Response, false, "ExecutiveUnsoldSummary");
}
}
}
public DALPaperTransaction()
{
XMLConnection = new clsConnection();
con = XMLConnection.ConnectByXML();
}
