private void BindgvReception()
{
ReceptionBl objReceptionBl = new ReceptionBl();
var objResult = objReceptionBl.Reception_SelectAll();
if (objResult != null)
{
gvReception.DataSource = objResult.ResultDt;
gvReception.DataBind();
PanelVisibilityMode(true, false);
}
}
//#region Bind Tanker Id
//protected void BindTankerId()
//{
// //ddlTankerID.Items.Clear();
// Controls objControls = new Controls();
// DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text + " " + txtFromTime.Text, "dd/MM/yyyy HH:mm:ss",
// CultureInfo.InvariantCulture);
// DateTime dtToDateTime = DateTime.ParseExact(txtToDate.Text + " " + txtToTime.Text, "dd/MM/yyyy HH:mm:ss",
// CultureInfo.InvariantCulture);
// Reception_PLCBl objReceptionPlcBl = new Reception_PLCBl();
// var objResult = objReceptionPlcBl.Reception_PLC_SelectAll(Convert.ToInt32(ddlReceptionLineNo.SelectedValue),dtFromDateTime,dtToDateTime);
// if (objResult != null)
// {
// if (objResult.ResultDt.Rows.Count > 0)
// {
// objControls.BindDropDown_ListBox(objResult.ResultDt, ddlTankerID, "Tanker_ID", "Tanker_ID");
// }
// ddlTankerID.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
// }
//}
//#endregion
#region Bind Reception Line NO
protected void BindReceptionLineNo()
{
Controls objControls = new Controls();
ReceptionBl objReceptionBl = new ReceptionBl();
var objResult = objReceptionBl.Reception_SelectAll();
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.ResultDt, ddlReceptionLineNo, "Name", "PLCValue");
}
ddlReceptionLineNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
protected void gvReception_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ReceptionBl objReceptionBL = new ReceptionBl();
if (e.CommandName == "Edit1")
{
ViewState["Mode"] = "Edit";
ViewState["ReceptionID"] = e.CommandArgument.ToString();
var objResult = objReceptionBL.Reception_Select(Convert.ToInt32(ViewState["ReceptionID"].ToString()));
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
txtRecName.Text = objResult.ResultDt.Rows[0][ReceptionBo.RECEPTION_NAME].ToString();
txtDescription.Text = objResult.ResultDt.Rows[0][ReceptionBo.RECEPTION_DESCRIPTION].ToString();
txtPLCValue.Text = objResult.ResultDt.Rows[0][ReceptionBo.RECEPTION_PLCVALUE].ToString();
PanelVisibilityMode(false, true);
}
}
}
else if (e.CommandName == "Delete1")
{
var objResult = objReceptionBL.Reception_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), DateTime.UtcNow.AddHours(5.5).ToString());
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>");
PanelVisibilityMode(true, false);
BindgvReception();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this Reception because it is in used.');</script>");
}
}
}
catch (Exception ex)
{
log.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>");
}
}
protected void btnSave_OnClick(object sender, EventArgs e)
{
try
{
ReceptionBo objReceptionBo = new ReceptionBo();
ReceptionBl objReceptionBl = new ReceptionBl();
objReceptionBo.Name = txtRecName.Text.Trim();
objReceptionBo.Description = txtDescription.Text.Trim();
objReceptionBo.PLCValue = Convert.ToInt32(txtPLCValue.Text);
if (ViewState["Mode"].ToString() == "Save")
{
objReceptionBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objReceptionBo.CreatedDate = DateTime.UtcNow.AddHours(5.5);
var objResult = objReceptionBl.Reception_Insert(objReceptionBo);
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
int intStatus = Convert.ToInt32(objResult.ResultDt.Rows[0]["Status"].ToString());
if (intStatus == 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('" + txtRecName.Text + " is already exist.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
BindgvReception();
PanelVisibilityMode(true, false);
}
}
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objReceptionBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objReceptionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
objReceptionBo.ReceptionId = Convert.ToInt32(ViewState["ReceptionID"].ToString());
var objResult = objReceptionBl.Reception_Update(objReceptionBo);
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
int intStatus = Convert.ToInt32(objResult.ResultDt.Rows[0]["Status"].ToString());
if (intStatus == 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('" + txtRecName.Text + " is already exist.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
BindgvReception();
PanelVisibilityMode(true, false);
}
}
}
}
}
catch (Exception ex)
{
log.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>");
}
}
