protected void gvRoadTax_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "roadTaxEdit":
ViewState["RoadTaxID"] = e.CommandArgument.ToString();
_roadtax.UserDistId = Convert.ToInt32(Session["UserdistrictId"].ToString());
var dsroadtaxedit = _roadtax.GetRoadTax();
var drroadtax = dsroadtaxedit.Tables[0].Select("RoadTaxID=" + e.CommandArgument);
ClearControls();
ddlVehicleNumber.Visible = false;
txtVehicleNumber.Visible = true;
txtVehicleNumber.Text = drroadtax[0][0].ToString();
ViewState["VehNum"] = Convert.ToInt16(drroadtax[0][1].ToString());
var dates = _fmsGeneral.GetRegistrationDate(int.Parse(drroadtax[0][1].ToString()));
var dt = DateTime.ParseExact(dates.Tables[0].Rows[0]["RegDate"].ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture);
vehicleRegistrationDate.Value = dt.ToString();
txtRoadTaxValidityStartDate.Text = drroadtax[0][3].ToString();
ddlRoadTaxValidityPeriod.Items.FindByValue(drroadtax[0][4].ToString()).Selected = true;
txtRoadTaxValidityEndDate.Text = drroadtax[0][5].ToString();
txtVehicleRTACircle.Text = drroadtax[0][6].ToString();
txtRoadTaxReceiptNo.Text = drroadtax[0][7].ToString();
txtRoadTaxFee.Text = drroadtax[0][8].ToString();
var datesUpdate = _fmsGeneral.GetRegistrationDate(int.Parse(ViewState["VehNum"].ToString()));
var dtUpdate = DateTime.ParseExact(datesUpdate.Tables[0].Rows[0]["RegDate"].ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture);
vehicleRegistrationDate.Value = dtUpdate.ToString(CultureInfo.InvariantCulture);
pnlRoadtax.Visible = true;
btSave.Text = "Update";
break;
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
foreach (GridViewRow item in grvBatteryIssueDetailsPopup.Rows)
{
var ddl = (DropDownList)item.FindControl("ddlNewBatteryNumber");
if (ddl == null)
{
throw new ArgumentNullException(nameof(ddl));
}
if (ddl.SelectedIndex != 0)
{
var newBatteryNumber = Convert.ToString(((DropDownList)item.FindControl("ddlNewBatteryNumber")).SelectedItem);
var batteryPosition = Convert.ToString(grvBatteryIssueDetailsPopup.Rows[0].Cells[0].Text);
var issuedQuantity = Convert.ToInt32(((TextBox)item.FindControl("txtBatteryIssuedQty")).Text);
var ds = _fmsg.GetRegistrationDate(Convert.ToInt32(ddlInventoryBatteryIssueVehicles.SelectedValue));
if (ds == null)
{
throw new ArgumentNullException(nameof(ds));
}
if (DateTime.Parse(ds.Tables[0].Rows[0]["RegDate"].ToString()) < DateTime.Parse(txtDcDate.Text))
{
InsertBatteryIssueDetails(Convert.ToInt32(txtInvReqIdPopUp.Text), Convert.ToInt32(txtDcNumberPopup.Text), Convert.ToDateTime(txtDcDate.Text), Convert.ToString(txtCourierName.Text), Convert.ToString(txtRemarks.Text), issuedQuantity, Convert.ToInt32(txtBatIssVehicleID.Text), newBatteryNumber, batteryPosition);
}
else
{
Show("Dc Date should be greater than Registration Date " + ds.Tables[0].Rows[0]["RegDate"]);
gv_ModalPopupExtenderBatteryIssue.Show();
break;
}
}
else
{
Show("Please Select Battery Number");
gv_ModalPopupExtenderBatteryIssue.Show();
break;
}
}
ClearControls();
FillGrid_BatteryForIssue(3, Convert.ToInt32(ddlInventoryBatteryIssueVehicles.SelectedValue));
Show("Battery Issued Successfully");
}
protected void btnOk_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in grvTyreIssueDetailsPopup.Rows)
{
UpdateSessionTable();
var tyreIssue = (DataSet)Session["TyreIssue"];
var fleetReqId = Convert.ToInt32(tyreIssue.Tables[1].Rows[0]["FleetInventoryReqID"].ToString());
var make = tyreIssue.Tables[1].Rows[0]["Make"].ToString();
var model = tyreIssue.Tables[1].Rows[0]["Model"].ToString();
var vehId = Convert.ToInt32(Session["vehId"]);
var ddl = (DropDownList)row.FindControl("ddlTyreNumber");
if (ddl.SelectedIndex != 0)
{
var tyreNumber = Session["tyreNumber"].ToString();
var tyrePosition = Convert.ToString(grvTyreIssueDetailsPopup.Rows[0].Cells[0].Text);
var ds = _fmsg.GetRegistrationDate(vehId);
if (DateTime.ParseExact(ds.Tables[0].Rows[0]["RegDate"].ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture) >= DateTime.ParseExact(txtDcDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture))
{
Show("DC date should be greater than Registration Date " + ds.Tables[0].Rows[0]["RegDate"]);
gv_ModalPopupExtenderTyreIssue.Show();
}
else
{
InsertTyreIssueDetails(fleetReqId, Convert.ToInt32(txtDcNumberPopup.Text), DateTime.ParseExact(txtDcDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture), txtCourierName.Text, txtRemarks.Text, Convert.ToInt32(txtTyreCost.Text), make, model, vehId, tyreNumber, tyrePosition);
FillGrid_TyreForIssue(1, Convert.ToInt32(ddlInventoryTyreIssueVehicles.SelectedValue));
ClearControls();
gv_ModalPopupExtenderTyreIssue.Hide();
Show("Tyre Issued SuccessFully");
}
}
else
{
Show("Please Select Tyre");
gv_ModalPopupExtenderTyreIssue.Show();
break;
}
}
}
protected void btIssue_Click(object sender, EventArgs e)
{
foreach (GridViewRow item in gvIssueDetails.Rows)
{
var issuedQuantity = Convert.ToInt32(((TextBox)item.FindControl("txtIssuedQty")).Text);
var ds = _fmsg.GetRegistrationDate(Convert.ToInt32(ddlVehicles.SelectedValue));
if (ds == null)
{
throw new ArgumentNullException(nameof(ds));
}
if (DateTime.ParseExact(ds.Tables[0].Rows[0]["RegDate"].ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture) < DateTime.ParseExact(txtDCDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture))
{
InsertIssueDetails(Convert.ToInt32(txtInvReqID.Text), Convert.ToInt32(txtDCNumber.Text), DateTime.ParseExact(txtDCDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture), Convert.ToString(txtCourierName.Text), Convert.ToString(txtRemarks.Text), issuedQuantity, Convert.ToInt32(txtVehicleID.Text));
FillGridApprovedRequisitions(Convert.ToInt32(ddlVehicles.SelectedValue));
Reset();
}
else
{
Show("DC Date should be greater than Registration Date" + ds.Tables[0].Rows[0]["RegDate"]);
gv_ModalPopupExtender1.Show();
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
int vehicleId;
int scheduledCat;
string scheduledCatName;
var status = string.Empty;
int res;
switch (btnSubmit.Text)
{
case "Submit":
vehicleId = Convert.ToInt32(ddlVehicleNo.SelectedValue);
scheduledCat = Convert.ToInt32(ddlScheduleCat.SelectedValue);
scheduledCatName = ddlScheduleCat.SelectedItem.Text;
var scheduledPlanDate = Convert.ToDateTime(txtSchedulePlanDate.Text);
var ds = _fmsg.GetRegistrationDate(vehicleId);
if (scheduledPlanDate > Convert.ToDateTime(ds.Tables[0].Rows[0][0].ToString()) && scheduledPlanDate >= DateTime.Now)
{
status = "Pending";
var createdBy = "user";
var creationdate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
res = _vehMain.InsServiceRequestDetails(vehicleId, scheduledCat, scheduledCatName, scheduledPlanDate, status, creationdate, createdBy);
switch (res)
{
case 1:
ResetScheduleDetails();
Show("Service Request Details Submitted successfully");
break;
default:
ResetScheduleDetails();
Show("Service Request Details already exists");
break;
}
FillScheduleServiceRequestGrid(vehicleId);
}
else
{
Show("Please select scheduled plan date greater than vehicle registration date ");
}
break;
case "Update":
vehicleId = Convert.ToInt32(ddlVehicleNo.SelectedValue);
scheduledCat = Convert.ToInt32(ddlScheduleCat.SelectedValue);
scheduledCatName = ddlScheduleCat.SelectedItem.Text;
var scheduledPlanDate1 = Convert.ToDateTime(txtSchedulePlanDate.Text);
var updatedBy = "user";
var updateddate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
var slno = Convert.ToInt32(Session["SlNo"].ToString());
res = _vehMain.UpdateServiceRequestDetails(vehicleId, slno, scheduledCat, scheduledCatName, scheduledPlanDate1, status, updateddate, updatedBy);
switch (res)
{
case 1:
ResetScheduleDetails();
Show("Service Request Details Updated successfully");
break;
default:
ResetScheduleDetails();
Show("Service Request Details already exists");
break;
}
FillScheduleServiceRequestGrid(vehicleId);
btnSubmit.Text = "Submit";
break;
}
}
protected void Save_Click(object sender, EventArgs e)
{
var dsOdo = ObjFuelEntry.ICheckFuelEntryOdo(Convert.ToInt32(ddlVehicleNumber.SelectedValue));
if (dsOdo == null)
{
throw new ArgumentNullException(nameof(dsOdo));
}
try
{
switch (dsOdo.Tables[0].Rows.Count)
{
case 0:
maxOdo.Value = "0";
break;
default:
if (dsOdo.Tables[0].Rows[0]["ODO"].ToString() == string.Empty)
{
maxOdo.Value = "0";
}
else
{
maxOdo.Value = dsOdo.Tables[0].Rows[0]["ODO"].ToString();
ViewState["maxodometer"] = dsOdo.Tables[0].Rows[0]["ODO"].ToString();
}
break;
}
var entrydate = DateTime.ParseExact(txtFuelEntryDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture);
if (entrydate > DateTime.Now)
{
Show("Fuel entry date should not be greater than current date ");
return;
}
Save.Enabled = false;
var fmsGeneral = new FMSGeneral();
var ds = fmsGeneral.GetRegistrationDate(int.Parse(ddlVehicleNumber.SelectedItem.Value));
if (ds == null)
{
throw new ArgumentNullException(nameof(ds));
}
Save.Enabled = true;
switch (ds.Tables[0].Rows.Count)
{
case 0:
Show("Fuel Entry cannot be done as vehicle is not yet Registered");
break;
default:
if (txtOdometer.Text.Trim() == string.Empty)
{
Show("Enter Odo value");
return;
}
else
{
if (Convert.ToInt32(ViewState["maxodometer"].ToString()) != 0)
{
var maxno = Convert.ToInt32(ViewState["maxodometer"].ToString()) + 1000;
if (maxno <= Convert.ToInt32(txtOdometer.Text) || Convert.ToInt32(txtOdometer.Text) <= Convert.ToInt32(ViewState["maxodometer"].ToString()))
{
Show("Odo value between " + ViewState["maxodometer"] + " And " + maxno);
txtOdometer.Text = "";
txtOdometer.Focus();
return;
}
}
}
var dtofRegistration = DateTime.ParseExact(ds.Tables[0].Rows[0]["RegDate"].ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture);
var fuelEntry = DateTime.ParseExact(txtFuelEntryDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture);
if (dtofRegistration > fuelEntry)
{
Show("Fuel entry date should be greater than date of registration ");
return;
}
var dtpreviousentryDate = GetpreviousOdo(int.Parse(ddlVehicleNumber.SelectedItem.Value));
if (dtpreviousentryDate.Rows.Count > 0 && dtpreviousentryDate.Rows[0]["maxentry"].ToString() != "")
{
var dtprvrefill = Convert.ToDateTime(dtpreviousentryDate.Rows[0]["maxentry"].ToString());
if (dtprvrefill > DateTime.ParseExact(txtFuelEntryDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture))
{
Show("Fuel entry date must be greater than previous fuel entry date");
return;
}
}
Save.Enabled = false;
if (Save.Text == "Save" && ddlPetroCardNumber.Enabled)
{
_bunkname = ddlBunkName.Visible ? ddlBunkName.SelectedItem.Text : txtBunkName.Text;
InsFuelEntry(Convert.ToInt32(Session["UserdistrictId"].ToString()), Convert.ToInt32(ddlVehicleNumber.SelectedValue), Convert.ToInt32(ddlDistrict.SelectedValue), fuelEntry, Convert.ToInt64(txtBillNumber.Text), Convert.ToInt64(txtOdometer.Text), _bunkname, Convert.ToInt32(ddlPaymode.SelectedValue), Convert.ToDecimal(txtQuantity.Text), Convert.ToInt64(ddlPetroCardNumber.SelectedValue), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToInt32(ddlAgency.SelectedValue), Convert.ToString(txtLocation.Text), Convert.ToInt32(Session["User_Id"].ToString()), DateTime.Now, 1, Convert.ToDecimal(txtAmount.Text), Convert.ToInt32(txtPilotID.Text), Convert.ToString(txtPilotName.Text), Convert.ToInt32(ddlCardSwiped.SelectedValue), Convert.ToString(txtRemarks.Text));
FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"]));
}
else if (Save.Text == "Save" && ddlPetroCardNumber.Enabled == false)
{
_bunkname = ddlBunkName.Visible ? ddlBunkName.SelectedItem.Text : txtBunkName.Text;
InsFuelEntry1(Convert.ToInt32(Session["UserdistrictId"].ToString()), Convert.ToInt32(ddlVehicleNumber.SelectedValue), fuelEntry, Convert.ToInt64(txtBillNumber.Text), Convert.ToInt64(txtOdometer.Text), _bunkname, Convert.ToInt32(ddlPaymode.SelectedValue), Convert.ToDecimal(txtQuantity.Text), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToString(txtLocation.Text), Convert.ToInt32(Session["User_Id"].ToString()), DateTime.Now, 1, Convert.ToDecimal(txtAmount.Text), Convert.ToInt32(txtPilotID.Text), Convert.ToString(txtPilotName.Text), Convert.ToInt32(ddlCardSwiped.SelectedValue), Convert.ToString(txtRemarks.Text));
FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"]));
}
else if (Save.Text == "Update" && ddlPetroCardNumber.Enabled)
{
_bunkname = ddlBunkName.Visible ? ddlBunkName.SelectedItem.Text : txtBunkName.Text;
UpdFuelEntry(Convert.ToInt32(txtEdit.Text), Convert.ToInt32(Session["UserdistrictId"].ToString()), Convert.ToInt32(ddlVehicleNumber.SelectedValue), Convert.ToInt32(ddlDistrict.SelectedValue), fuelEntry, Convert.ToInt64(txtBillNumber.Text), Convert.ToInt64(txtOdometer.Text), _bunkname, Convert.ToInt32(ddlPaymode.SelectedValue), Convert.ToDecimal(txtQuantity.Text), Convert.ToInt64(ddlPetroCardNumber.SelectedValue), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToInt32(ddlAgency.SelectedValue), Convert.ToString(txtLocation.Text), Convert.ToDecimal(txtAmount.Text), Convert.ToInt32(txtPilotID.Text), Convert.ToString(txtPilotName.Text), Convert.ToInt32(ddlCardSwiped.SelectedValue), Convert.ToString(txtRemarks.Text));
FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"]));
}
else
{
_bunkname = ddlBunkName.Visible ? ddlBunkName.SelectedItem.Text : txtBunkName.Text;
UpdFuelEntry1(Convert.ToInt32(txtEdit.Text), Convert.ToInt32(Session["UserdistrictId"].ToString()), Convert.ToInt32(ddlVehicleNumber.SelectedValue), fuelEntry, Convert.ToInt64(txtBillNumber.Text), Convert.ToInt64(txtOdometer.Text), _bunkname, Convert.ToInt32(ddlPaymode.SelectedValue), Convert.ToDecimal(txtQuantity.Text), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToString(txtLocation.Text), Convert.ToDecimal(txtAmount.Text), Convert.ToInt32(txtPilotID.Text), Convert.ToString(txtPilotName.Text), Convert.ToInt32(ddlCardSwiped.SelectedValue), Convert.ToString(txtRemarks.Text));
FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"]));
}
break;
}
}
catch (Exception ex)
{
_helper.ErrorsEntry(ex);
}
}
