//Check Duplicate Board
public int CheckDuplicateBoard_DL(EWA_Transport objEWA)
{
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@BoardTitle";
prmList[3] = objEWA.BoardTitle;
DataSet dsData = ObjHelper.FillControl(prmList, "SP_Board");
if (dsData.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception)
{
//GeneralErr(exp.Message.ToString());
throw;
//return 1;
}
}
//Driver Grid Bind
#region [Driver Grid Bind]
public DataSet AllotDriverGridBind_DL(EWA_Transport objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_AllotDriver");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("DriverId");
dt.Columns.Add("Name");
dt.Columns.Add("VehicleNo");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
return(ds);
}
}
catch (Exception exp)
{
throw exp;
}
}
//Insert Delete operaeion on Assign Route For Student
#region [Insert Delete operaeion on Assign Route For Student ]
public void AssignRouteAction_DL(EWA_Transport objEWA, string[] UserCode)
{
try
{
cmd = new SqlCommand("SP_Route", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
foreach (string studentIdstr in UserCode)
{
DataSet ds = new DataSet();
if (studentIdstr != "")
{
cmd.Parameters.AddWithValue("@Action", objEWA.ActionV);
cmd.Parameters.AddWithValue("@RouteId", objEWA.RouteId);
cmd.Parameters.AddWithValue("@UserCode", studentIdstr);
// Added by Ashwini 30-sep-2020
cmd.Parameters.AddWithValue("@CourseId", objEWA.CourseId);
cmd.Parameters.AddWithValue("@ClassId", objEWA.ClassId);
cmd.Parameters.AddWithValue("@BranchID", objEWA.BranchId);
cmd.Parameters.AddWithValue("@AcademicYear", objEWA.AcademicYear);
//
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
cmd.Parameters.Clear();
}
}
con.Close();
}
catch (Exception ex)
{
throw;
}
}
//Check Duplicates
#region [Check Duplicate Record]
public int CheckDuplicateVehicle_DL(EWA_Transport objEWA)
{
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@VehicleNumber";
prmList[3] = objEWA.@VehicleNumber;
DataSet dsData = ObjHelper.FillControl(prmList, "SP_Vehicle");
if (dsData.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception exp)
{
throw exp;
}
}
//Perform Action On Driver Info
#region [Perform Actions On Allot Driver Info]
public int AllotDriverAction_DL(EWA_Transport objEWA)
{
try
{
cmd = new SqlCommand("SP_AllotDriver", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@DriverId", objEWA.DriverId);
cmd.Parameters.AddWithValue("@VehicleId", objEWA.VehicleId);
cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
con.Open();
int flag = cmd.ExecuteNonQuery();
con.Close();
return(flag);
}
catch (Exception ex)
{
int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
if (err == 547 && objEWA.Action == "Delete")
{
throw new SystemException("Record is in use !!!");
}
else
{
throw ex;
}
}
}
//To Check Duplicate Driver Info
#region [Check Duplicate Driver Info]
public int CheckDuplicateDriverInfo_DL(EWA_Transport objEWA)
{
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@LicenseId";
prmList[3] = objEWA.@LicenseId;
DataSet dsData = ObjHelper.FillControl(prmList, "SP_DriverInfo");
if (dsData.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception exp)
{
throw exp;
}
}
//Check Duplicate Route
#region [Check Duplicate Route]
public int CheckDuplicateRoute_DL(EWA_Transport objEWA)
{
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@Route";
prmList[3] = objEWA.@Route;
prmList[4] = "@orgId";
prmList[5] = Convert.ToString(objEWA.OrgId);
DataSet dsData = ObjHelper.FillControl(prmList, "SP_Route");
if (dsData.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception exp)
{
throw exp;
}
}
//Insert Delete operaeion on Assign Route For Student
public void AssignRouteAction_BL(EWA_Transport objEWA, string[] UserCode)
{
try
{
DL_Transport objDL = new DL_Transport();
objDL.AssignRouteAction_DL(objEWA, UserCode);
}
catch (Exception)
{
throw;
}
}
//To Call RouteGridBind
#region [Route Grid Bind]
public DataSet RouteGridBind_BL(EWA_Transport objEWA)
{
try
{
DL_Transport objDL = new DL_Transport();
DataSet ds = objDL.BindRouteGrid_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//To Check Duplicate Data Of Route
#region [Check Duplicate Route]
public int CheckDuplicateRoute_BL(EWA_Transport objEWA)
{
try
{
DL_Transport objDL = new DL_Transport();
int i = objDL.CheckDuplicateRoute_DL(objEWA);
return(i);
}
catch (Exception)
{
throw;
}
}
//Vehicle Bind Data
#region [Vehicle Bind Data]
public DataSet ddlVehicleBind_BL(EWA_Transport objEWA)
{
try
{
DL_Transport objDL = new DL_Transport();
DataSet ds = objDL.ddlVehicleBind_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//Insert Update Delete operaeion on DriverInfo Table
public int AllotDriverAction_BL(EWA_Transport objEWA)
{
int flag;
try
{
DL_Transport objDL = new DL_Transport();
flag = objDL.AllotDriverAction_DL(objEWA);
return(flag);
}
catch (Exception)
{
throw;
}
}
//To Check Duplicate Data Of Board
#region [Check Duplicate Board]
public int CheckDuplicateBoard_BL(EWA_Transport objEWA)
{
try
{
DL_Transport objDL = new DL_Transport();
int i = objDL.CheckDuplicateBoard_DL(objEWA);
return(i);
}
catch (Exception)
{
throw;
}
finally
{
objDL = null;
}
}
//To Call Board Grid Bind
#region [Board Grid Bind]
public DataSet BoardGridBind_BL(EWA_Transport objEWA)
{
try
{
DL_Transport objDL = new DL_Transport();
DataSet ds = objDL.BindBoardGrid_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
objDL = null;
}
}
//Insert Update Delete operaeion on Vehicle Table
#region [Action Performed For Vehicle]
public int VehicleAction_BL(EWA_Transport objEWA)
{
int flag;
try
{
DL_Transport objDL = new DL_Transport();
flag = objDL.VehicleAction_DL(objEWA);
return(flag);
}
catch (Exception)
{
throw;
}
finally
{
objDL = null;
}
}
//To Bind DriverInfoGrid
#region [Bind Driver Info Grid]
public DataSet BindDriverInfoGrid_DL(EWA_Transport objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_DriverInfo");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("DriverId");
dt.Columns.Add("Name");
dt.Columns.Add("Address");
dt.Columns.Add("PhoneNo");
dt.Columns.Add("LicenseId");
dt.Columns.Add("LicenseType");
dt.Columns.Add("UploadImage");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
return(ds);
}
}
catch (Exception exp)
{
throw exp;
}
}
//To Perform Insert,Update,Delete and Search Actions On DriverInfo Table
#region [Perform Actions On Driver Info]
public int DriverInfoAction_DL(EWA_Transport objEWA)
{
try
{
cmd = new SqlCommand("SP_DriverInfo", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@DriverId", objEWA.DriverId);
cmd.Parameters.AddWithValue("@Name", objEWA.Name);
cmd.Parameters.AddWithValue("@Address", objEWA.Address);
cmd.Parameters.AddWithValue("@PhoneNo", objEWA.PhoneNo);
cmd.Parameters.AddWithValue("@LicenseId", objEWA.LicenseId);
cmd.Parameters.AddWithValue("@LicenseType", objEWA.LicenseType);
cmd.Parameters.AddWithValue("@UploadImage", objEWA.UploadImage);
cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
con.Open();
int flag = cmd.ExecuteNonQuery();
con.Close();
return(flag);
}
catch (Exception ex)
{
int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
if (err == 547 && objEWA.Action == "Delete")
{
throw new SystemException("Record is in use !!!");
}
else
{
throw ex;
}
}
finally
{
con.Close();
cmd.Dispose();
}
}
//To Bind RouteGrid
#region [Bind Route Grid]
public DataSet BindRouteGrid_DL(EWA_Transport objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@orgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
ds = ObjHelper.FillControl(prmList, "SP_Route");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("RouteId");
dt.Columns.Add("Route");
dt.Columns.Add("RouteTitle");
dt.Columns.Add("Amount");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//To Bind VehicleGrid
#region [Bind Vehicle Grid]
public DataSet BindVehicleGrid_DL(EWA_Transport objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_Vehicle");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("VehicleId");
dt.Columns.Add("VehicleType");
dt.Columns.Add("VehicleNumber");
dt.Columns.Add("VehicleModel");
dt.Columns.Add("VehicleCapacity");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Vehicle Data Bind Region
#region [ddl Vehicle Data Bind Region]
public DataSet ddlVehicleBind_DL(EWA_Transport objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "FetchVehicle";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
ds = ObjHelper.FillControl(prmList, "SP_Vehicle");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//No Implementation
#region [No Implementation]
public int Action_BL(EWA_Transport objEWA)
{
throw new NotImplementedException();
}
public int CheckDuplicateVehical_BL(EWA_Transport objEWA)
{
throw new NotImplementedException();
}
