/// <summary>
/// Validate the object.
/// </summary>
/// <exception cref="ValidationException">
/// Thrown if validation fails
/// </exception>
public virtual void Validate()
{
if (TransportHeader == null)
{
throw new ValidationException(ValidationRules.CannotBeNull, "TransportHeader");
}
if (TransportDetails == null)
{
throw new ValidationException(ValidationRules.CannotBeNull, "TransportDetails");
}
if (TransportResult == null)
{
throw new ValidationException(ValidationRules.CannotBeNull, "TransportResult");
}
if (TransportHeader != null)
{
TransportHeader.Validate();
}
if (TransportDetails != null)
{
TransportDetails.Validate();
}
if (TransportResult != null)
{
TransportResult.Validate();
}
}
public JsonResult GetAssignTransport(string TPCostID)
{
TransportDetails Obj = new TransportDetails();
Obj.FinancialYearID = _Financialyearid;
Obj.SchoolID = _OrgnisationID;
Obj.TPCostID = Convert.ToInt32(TPCostID);
Obj.Action = "GET";
Obj = BALObj.GetAssignTransport(Obj);
return(Json(Obj, JsonRequestBehavior.AllowGet));
}
public ActionResult FeeDetails()
{
TransportDetails tt = new TransportDetails();
Business business = new Business();
var fee = business.GetFeeDetails();
tt.RouteCode = fee.RouteCode;
tt.Source = fee.Source;
tt.Destination = fee.Destination;
return(PartialView("FeeDetails", tt));
}
public JsonResult AssignTransport(TransportDetails transportDetail)
{
int res = 0;
try
{
transportDetail.Action = transportDetail.TPCostID != 0 ? "UPD" : "INS";
transportDetail.SchoolID = _OrgnisationID;
transportDetail.FinancialYearID = _Financialyearid;
res = BALObj.AssignTransport(transportDetail);
}
catch
{
res = 1;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public TransportDetails GetAssignTransport(TransportDetails model)
{
TransportDetails obj = new TransportDetails();
try
{
cmd = new SqlCommand("USP_AssignTransport");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SchoolID", model.SchoolID);
cmd.Parameters.AddWithValue("@FinancialYearID", model.FinancialYearID);
cmd.Parameters.AddWithValue("@TPCostID", model.TPCostID);
cmd.Parameters.AddWithValue("@Action", model.Action);
var dr = DBHelper.ExecuteReader(cmd);
while (dr.Read())
{
obj.TPCostID = Convert.ToInt32(dr["TPId"]);
obj.FinancialYearID = Convert.ToInt32(dr["FinancialYearID"]);
obj.RouteID = Convert.ToInt32(dr["RouteID"]);
obj.PickDropPointID = Convert.ToInt32(dr["PickDropPointId"]);
obj.Fee = Convert.ToDecimal(dr["Fee"]);
obj.Apr = Convert.ToDecimal(dr["Apr"]);
obj.May = Convert.ToDecimal(dr["May"]);
obj.Jun = Convert.ToDecimal(dr["Jun"]);
obj.Jul = Convert.ToDecimal(dr["Jul"]);
obj.Aug = Convert.ToDecimal(dr["Aug"]);
obj.Sep = Convert.ToDecimal(dr["Sep"]);
obj.Oct = Convert.ToDecimal(dr["Oct"]);
obj.Nov = Convert.ToDecimal(dr["Nov"]);
obj.Dec = Convert.ToDecimal(dr["Dec"]);
obj.Jan = Convert.ToDecimal(dr["Jan"]);
obj.Feb = Convert.ToDecimal(dr["Feb"]);
obj.Mar = Convert.ToDecimal(dr["Mar"]);
}
}
catch (Exception ex)
{
ExecptionLogger.FileHandling("DALTransport(GetVehicleList)", "Error_014", ex, "DALTransport");
}
finally
{
cmd.Dispose();
}
return(obj);
}
public int AssignTransport(TransportDetails transportDetail)
{
int result = 0;
try
{
cmd = new SqlCommand("USP_AssignTransport");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TPCostID", transportDetail.TPCostID);
cmd.Parameters.AddWithValue("@SchoolID", transportDetail.SchoolID);
cmd.Parameters.AddWithValue("@FinancialYearID", transportDetail.FinancialYearID);
cmd.Parameters.AddWithValue("@StudentID", transportDetail.StudentID);
cmd.Parameters.AddWithValue("@RouteID", transportDetail.RouteID);
cmd.Parameters.AddWithValue("@PickDropPointID", transportDetail.PickDropPointID);
cmd.Parameters.AddWithValue("@Fee", transportDetail.Fee);
cmd.Parameters.AddWithValue("@Apr", transportDetail.Apr);
cmd.Parameters.AddWithValue("@May", transportDetail.May);
cmd.Parameters.AddWithValue("@Jun", transportDetail.Jun);
cmd.Parameters.AddWithValue("@Jul", transportDetail.Jul);
cmd.Parameters.AddWithValue("@Aug", transportDetail.Aug);
cmd.Parameters.AddWithValue("@Sep", transportDetail.Sep);
cmd.Parameters.AddWithValue("@Oct", transportDetail.Oct);
cmd.Parameters.AddWithValue("@Nov", transportDetail.Nov);
cmd.Parameters.AddWithValue("@Dec", transportDetail.Dec);
cmd.Parameters.AddWithValue("@Jan", transportDetail.Jan);
cmd.Parameters.AddWithValue("@Feb", transportDetail.Feb);
cmd.Parameters.AddWithValue("@Mar", transportDetail.Mar);
cmd.Parameters.AddWithValue("@Action", transportDetail.Action);
result = Convert.ToInt32(DBHelper.ExecuteScalar(cmd));
}
catch (Exception ex)
{
ExecptionLogger.FileHandling("DALTransport(AssignTransport)", "Error_014", ex, "DALTransport");
}
finally
{
cmd.Dispose();
}
return(result);
}
public TransportDetails GetAssignTransport(TransportDetails model)
{
DALTransport dal = new DALTransport(ConStr);
return(dal.GetAssignTransport(model));
}
public int AssignTransport(TransportDetails transportDetail)
{
DALTransport dal = new DALTransport(ConStr);
return(dal.AssignTransport(transportDetail));
}
