private void BindgvLabReport(string strFromDt, string strToDate)
{
ApplicationResult objResult = new ApplicationResult();
LabReportBl objLabReportBl = new LabReportBl();
objResult = objLabReportBl.LabReport(strFromDt, strToDate);
if (objResult != null)
{
gvLabReport.DataSource = objResult.ResultDt;
gvLabReport.DataBind();
PanelVisibilityMode(true, false);
}
}
private void BindgvLabReport(string strFromDt, string strToDate)
{
ApplicationResult objResult = new ApplicationResult();
LabReportBl objLabReportBl = new LabReportBl();
objResult = objLabReportBl.LabReport(strFromDt, strToDate);
gvLabReport.DataSource = objResult.ResultDt;
gvLabReport.DataBind();
PanelVisibilityMode(true, false);
if (gvLabReport.Rows.Count > 0)
{
divExport.Visible = true;
divNo.Visible = false;
}
else
{
divExport.Visible = false;
divNo.Visible = true;
}
}
protected void gvLabReport_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
LabReportBl objLabReportBl = new LabReportBl();
if (e.CommandName == "Edit1")
{
ViewState["ID"] = e.CommandArgument.ToString();
objResult = objLabReportBl.LabReport_Select(Convert.ToInt32(ViewState["ID"].ToString()));
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
txtLabDate.Text = objResult.ResultDt.Rows[0]["LabDate"].ToString();
txtVehicleNo.Text = objResult.ResultDt.Rows[0]["VehicleNumber"].ToString();
hfVehicleNo.Value = objResult.ResultDt.Rows[0]["VehicleNumber"].ToString();
hfVehicleId.Value = objResult.ResultDt.Rows[0]["VehicleId"].ToString();
txtVehicleId.Text = objResult.ResultDt.Rows[0]["VehicleCode"].ToString();
txtRouteNo.Text = objResult.ResultDt.Rows[0]["RouteNo"].ToString();
//ddlRouteNo.SelectedValue = objResult.ResultDt.Rows[0]["RouteId"].ToString();
ddlProduct.SelectedValue = objResult.ResultDt.Rows[0]["ProductId"].ToString();
ddlOT.SelectedValue = objResult.ResultDt.Rows[0]["OT"].ToString();
txtTemp.Text = objResult.ResultDt.Rows[0]["Temp"].ToString();
txtFat.Text = objResult.ResultDt.Rows[0]["Fat"].ToString();
txtSNF.Text = objResult.ResultDt.Rows[0]["SNF"].ToString();
txtAcidity.Text = objResult.ResultDt.Rows[0]["Acidity"].ToString();
ddlCOB.SelectedValue = objResult.ResultDt.Rows[0]["COB"].ToString();
txtAlcoholNo.Text = objResult.ResultDt.Rows[0]["AlcoholNo"].ToString();
ddlNeutralizer.SelectedValue = objResult.ResultDt.Rows[0]["Neutralizer"].ToString();
ddlUrea.SelectedValue = objResult.ResultDt.Rows[0]["Urea"].ToString();
ddlSalt.SelectedValue = objResult.ResultDt.Rows[0]["Salt"].ToString();
ddlStartch.SelectedValue = objResult.ResultDt.Rows[0]["Startch"].ToString();
txtFPD.Text = objResult.ResultDt.Rows[0]["FPD"].ToString();
ddlStatus.SelectedValue = objResult.ResultDt.Rows[0]["Status"].ToString();
PanelVisibilityMode(false, true);
ViewState["Mode"] = "Edit";
}
//ViewState["CheckRoleId"] = ViewState["RoleID"];
}
}
else if (e.CommandName == "Delete1")
{
objResult = objLabReportBl.LabReport_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), System.DateTime.UtcNow.AddHours(5.5).ToString());
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
//log.Info("User role has been deleted.");
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>");
PanelVisibilityMode(true, false);
getDatesofMonth();
}
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>");
//throw ex;
}
}
protected void btnSave_OnClick(object sender, EventArgs e)
{
try
{
if (txtVehicleNo.Text == hfVehicleNo.Value)
{
LabReportBo objLabReportBo = new LabReportBo();
ApplicationResult objResult = new ApplicationResult();
LabReportBl objLabReportBl = new LabReportBl();
objLabReportBo.LabDate = txtLabDate.Text.Trim();
objLabReportBo.VehicleId = Convert.ToInt32(hfVehicleId.Value);
objLabReportBo.VehicleCode = txtVehicleId.Text;
// objLabReportBo.RouteId = Convert.ToInt32(ddlRouteNo.SelectedValue);
objLabReportBo.ProductId = Convert.ToInt32(ddlProduct.SelectedValue);
objLabReportBo.OT = (ddlOT.SelectedValue != "-1") ? Convert.ToInt32(ddlOT.SelectedValue) : -1;
objLabReportBo.Temp = (txtTemp.Text != "") ? Convert.ToDouble(txtTemp.Text) : 0.0;
objLabReportBo.Fat = (txtFat.Text != "") ? Convert.ToDouble(txtFat.Text) : 0.0;
objLabReportBo.SNF = (txtSNF.Text != "") ? Convert.ToDouble(txtSNF.Text) : 0.0;
objLabReportBo.Acidity = (txtAcidity.Text != "") ? Convert.ToDouble(txtAcidity.Text) : 0.0;
objLabReportBo.COB = (ddlCOB.SelectedValue != "-1") ? ddlCOB.SelectedValue : "-1";
objLabReportBo.AlcoholNo = txtAlcoholNo.Text;
objLabReportBo.Neutralizer = (ddlNeutralizer.SelectedValue != "-1") ? ddlNeutralizer.SelectedValue : "-1";
objLabReportBo.Urea = (ddlUrea.SelectedValue != "-1") ? ddlUrea.SelectedValue : "-1";
objLabReportBo.Salt = (ddlSalt.SelectedValue != "-1") ? ddlSalt.SelectedValue : "-1";
objLabReportBo.Startch = (ddlStartch.SelectedValue != "-1") ? ddlStartch.SelectedValue : "-1";
objLabReportBo.FPD = txtFPD.Text;
objLabReportBo.Status = Convert.ToInt32(ddlStatus.SelectedValue);
if (ViewState["Mode"].ToString() == "Save")
{
objLabReportBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objLabReportBo.CreatedDate = DateTime.UtcNow.AddHours(5.5);
objResult = objLabReportBl.LabReport_Insert(objLabReportBo);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
getDatesofMonth();
PanelVisibilityMode(true, false);
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objLabReportBo.Id = Convert.ToInt32(ViewState["ID"].ToString());
objLabReportBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objLabReportBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
objResult = objLabReportBl.LabReport_Update(objLabReportBo);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
getDatesofMonth();
PanelVisibilityMode(true, false);
}
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Vehicle No is not exist.');</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>");
}
}
