protected void lblzone_Click(object sender, EventArgs e)
{
LinkButton lnk = (LinkButton)sender;
int zoneid = Convert.ToInt32(((Label)lnk.Parent.FindControl("lblzoneid")).Text);
ViewState["zoneid"] = zoneid;
divall.Visible = false;
pnlgrdDeatils.Visible = true;
divbutton.Visible = true;
Pnlgrdview.Visible = false;
MarketReview.ReportSource = null;
DataSet ds = new DataSet();
ds = Market_Review.Get_Mark_ReviewDetails("all", zoneid.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
lblMSDZ.Text = ds.Tables[0].Rows[0][3].ToString() + ", ";
lblMSZ.Text = ds.Tables[0].Rows[0][5].ToString() + ", ";
lblMZ.Text = ds.Tables[0].Rows[0][6].ToString();
grdDeatils.DataSource = ds.Tables[0];
grdDeatils.DataBind();
}
else
{
}
}
public void fillDataDocNo(int isNew)
{
int zone = Convert.ToInt32(ViewState["zoneid"]);
ReportDocument rd = new ReportDocument();
if (isNew == 1)
{
string value = getString();
DataSet ds = new DataSet();
if (value == "")
{
ds = Market_Review.Get_Mark_ReviewDetails("all", zone.ToString());
ViewState["DocNoRep"] = ds.Tables[0];
}
else
{
ds = Market_Review.Get_Mark_ReviewDetails("", value);
ViewState["DocNoRep"] = ds.Tables[0];
}
}
if (ViewState["DocNoRep"] != null)
{
try
{
rd.Load(Server.MapPath("Report/MarketReviewReport.rpt"));
rd.Database.Tables[0].SetDataSource((DataTable)ViewState["DocNoRep"]);
MarketReview.ReportSource = rd;
}
catch
{
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if ((txtmarketreview.Text != "" && txtmarketreview.Text != null) || (txtcompreview.Text != "" && txtcompreview.Text != null))
{
Market_Review _objMarView = new Market_Review();
_objMarView.Super_Duper_Zone = ddlSDZone.SelectedValue.ToString();
_objMarView.Super_Zone = DDLSuperZone.SelectedValue.ToString();
_objMarView.Zone = DDLZone.SelectedValue.ToString();
_objMarView.Market_View = txtmarketreview.Text.Trim();
_objMarView.Competitor_View = txtcompreview.Text.Trim();
_objMarView.Fyfrom = Convert.ToInt32(strFY);
_objMarView.Save();
MessageBox("Data Saved Successfully.");
Clear();
}
else
{
MessageBox("Either Market Review or Competitor Review is Required!!!");
}
}
catch
{
}
}
protected void lblView_Click(object sender, EventArgs e)
{
LinkButton lnk = (LinkButton)sender;
int mid = Convert.ToInt32(((Label)lnk.FindControl("lblmarkid")).Text);
GridView1.DataSource = Market_Review.Get_Mark_ReviewDetails("", mid.ToString());
GridView1.DataBind();
mdpextender.Show();
}
public void fillData(int isNew)
{
string Details = string.Empty;
ReportDocument rd = new ReportDocument();
if (isNew == 1)
{
DataSet ds = new DataSet();
if (ddlSummery.SelectedIndex == 0)
{
Details = "Summery";
if (DDLSuperZone.SelectedIndex != 0 && DDLZone.SelectedIndex != 0)
{
ds = Market_Review.Get_Mark_Review_DetailsBy_Zone(Details, "z", ddlSDZone.SelectedValue.ToString(), DDLSuperZone.SelectedValue.ToString(), DDLZone.SelectedValue.ToString(), Convert.ToInt32(strFY));
}
else if (DDLSuperZone.SelectedIndex != 0 && DDLZone.SelectedIndex == 0)
{
ds = Market_Review.Get_Mark_Review_DetailsBy_Zone(Details, "sz", ddlSDZone.SelectedValue.ToString(), DDLSuperZone.SelectedValue.ToString(), "", Convert.ToInt32(strFY));
}
else
{
ds = Market_Review.Get_Mark_Review_DetailsBy_Zone(Details, "sdz", ddlSDZone.SelectedValue.ToString(), "", "", Convert.ToInt32(strFY));
}
}
else
{
Details = "Details";
if (DDLSuperZone.SelectedIndex != 0 && DDLZone.SelectedIndex != 0)
{
ds = Market_Review.Get_Mark_Review_DetailsBy_Zone(Details, "z", ddlSDZone.SelectedValue.ToString(), DDLSuperZone.SelectedValue.ToString(), DDLZone.SelectedValue.ToString(), Convert.ToInt32(strFY));
}
else if (DDLSuperZone.SelectedIndex != 0 && DDLZone.SelectedIndex == 0)
{
ds = Market_Review.Get_Mark_Review_DetailsBy_Zone(Details, "sz", ddlSDZone.SelectedValue.ToString(), DDLSuperZone.SelectedValue.ToString(), "", Convert.ToInt32(strFY));
}
else
{
ds = Market_Review.Get_Mark_Review_DetailsBy_Zone(Details, "sdz", ddlSDZone.SelectedValue.ToString(), "", "", Convert.ToInt32(strFY));
}
}
ViewState["Rep"] = ds.Tables[0];
}
if (ViewState["Rep"] != null)
{
try
{
DataTable check = (DataTable)ViewState["Rep"];
if (ddlSummery.SelectedIndex == 0)
{
if (check.Rows.Count > 0)
{
rd.Load(Server.MapPath("Report/MarketReviewSummeryReport.rpt"));
rd.Database.Tables[0].SetDataSource((DataTable)ViewState["Rep"]);
MarketReview.ReportSource = rd;
}
}
else if (ddlSummery.SelectedIndex == 1)
{
if (check.Rows.Count > 0)
{
rd.Load(Server.MapPath("Report/MarketReviewDetailsReport.rpt"));
rd.Database.Tables[0].SetDataSource((DataTable)ViewState["Rep"]);
MarketReview.ReportSource = rd;
}
}
}
catch
{
}
}
}
