protected void lnkbtnExcel_Click(object sender, EventArgs e)
{
string strMsg = string.Empty;
DateTime? DateOn;
DataTable dt = new DataTable();
WhatsNewDAL obj1 = new WhatsNewDAL();
DateOn = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
var selectdata = obj1.SelectAll(DateOn, Convert.ToInt64(ddlForm.SelectedValue));
obj1 = null;
if (selectdata != null && selectdata.Count > 0)
{
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("FormName", typeof(string));
dt.Columns.Add("Details", typeof(string));
for (int i = 0; i < selectdata.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["Date"] = Convert.ToString(DataBinder.Eval(selectdata[i], "Date"));
dr["FormName"] = Convert.ToString(DataBinder.Eval(selectdata[i], "FormName"));
dr["Details"] = Convert.ToString(DataBinder.Eval(selectdata[i], "Details"));
dt.Rows.Add(dr);
}
}
Export(dt);
}
private void BindFormName()
{
WhatsNewDAL obj = new WhatsNewDAL();
var FrmName = obj.BindFormName();
ddlForm.DataSource = FrmName;
ddlForm.DataTextField = "FormName";
ddlForm.DataValueField = "FormIdno";
ddlForm.DataBind();
obj = null;
ddlForm.Items.Insert(0, new ListItem("--Select--", "0"));
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
string strMsg = string.Empty;
DateTime? DateOn;
WhatsNewDAL obj1 = new WhatsNewDAL();
DateOn = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
Int64 intWhatsIdno = 0;
intWhatsIdno = obj1.Insert(DateOn, Convert.ToInt64(ddlForm.SelectedValue), txtDetails.Text);
if (intWhatsIdno > 0)
{
ShowMessage("Record saved successfully.");
this.ClearControls();
}
}
