protected void gvSerialNo_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
var objSerialBl = new SerialNoBl();
ViewState["Id"] = e.CommandArgument;
if (e.CommandName == "Edit1")
{
var objResult = objSerialBl.SerialNo_Select(Convert.ToInt32(e.CommandArgument));
if (objResult == null)
{
return;
}
var dtresult = objResult.resultDT;
if (dtresult.Rows.Count <= 0)
{
return;
}
BindTrust();
ddlTrust.SelectedValue = dtresult.Rows[0]["TrustMID"].ToString();
ddlTrust_SelectedIndexChanged(sender, e);
if (dtresult.Rows[0]["SchoolMID"].ToString() != "0")
{
ddlSchool.SelectedValue = dtresult.Rows[0]["SchoolMID"].ToString();
}
ddlType.SelectedValue = dtresult.Rows[0]["EntryType"].ToString();
ddlYear.SelectedValue = dtresult.Rows[0]["Year"].ToString();
txtStartNo.Text = dtresult.Rows[0]["StartNo"].ToString();
ViewState["Mode"] = "Edit";
ddlType.Enabled = false;
ddlYear.Enabled = false;
PanelVisibility(2);
}
else if (e.CommandName == "Delete1")
{
var objResult = objSerialBl.SerialNo_Delete(Convert.ToInt32(e.CommandArgument));
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", objResult.status == ApplicationResult.CommonStatusType.SUCCESS
? "<script>alert('Record deleted successfully.');</script>"
: "<script>alert('You can not delete this record. It is already in use.');</script>");
BindGrid();
}
}
catch (Exception ex)
{
Logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
public void BindGrid()
{
try
{
var objSerialNoBl = new SerialNoBl();
var objApplicationResult = objSerialNoBl.SerialNo_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objApplicationResult == null)
{
return;
}
var dtSelectAll = UpdateDt(objApplicationResult.resultDT);
gvSerialNo.DataSource = dtSelectAll;
gvSerialNo.DataBind();
}
catch (Exception ex)
{
Logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
var objSerialNoBo = new SerialNoBo();
var objSerialNoBl = new SerialNoBl();
int intId = 0;
objSerialNoBo.TrustMID = Convert.ToInt32(ddlTrust.SelectedValue);
objSerialNoBo.SchoolMID = ddlSchool.SelectedValue != "" ? Convert.ToInt32(ddlSchool.SelectedValue) : 0;
objSerialNoBo.Year = Convert.ToInt32(ddlYear.SelectedValue);
objSerialNoBo.EntryType = ddlType.SelectedValue;
objSerialNoBo.StartNo = Convert.ToInt32(txtStartNo.Text);
objSerialNoBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objSerialNoBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(CultureInfo.InvariantCulture);
objSerialNoBo.IsDeleted = 0;
objSerialNoBo.LastModifideDate = DateTime.UtcNow.AddHours(5.5).ToString(CultureInfo.InvariantCulture);
objSerialNoBo.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
switch (ViewState["Mode"].ToString())
{
case "Save":
intId = -1;
break;
case "Edit":
intId = Convert.ToInt32(ViewState["Id"].ToString());
break;
}
var objResultValidate = objSerialNoBl.SerialNo_ValidateName(intId, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ddlYear.SelectedValue), ddlType.SelectedValue);
if (objResultValidate != null)
{
var dtResultValidate = objResultValidate.resultDT;
if (dtResultValidate.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('This record already exists.');</script>");
}
else
{
if (ViewState["Mode"].ToString() == "Save")
{
var objResult = objSerialNoBl.SerialNo_Insert(objSerialNoBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
}
}
else
{
objSerialNoBo.Id = Convert.ToInt32(ViewState["Id"]);
var objResult = objSerialNoBl.SerialNo_Update(objSerialNoBo);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", objResult.status == ApplicationResult.CommonStatusType.SUCCESS
? "<script>alert('Record Updated Successfully.');</script>"
: "<script>alert('You can not changed the record. It is already in use.');</script>");
}
Clear();
BindGrid();
PanelVisibility(1);
}
}
}
catch (Exception ex)
{
Logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
