public Int32 DeleteRouteMaster(RouteMaster ObjRouteMaster)
{
ObjSqlHelper = new SqlHelper.SqlHelper();
SqlParameter[] oPara =
{
new SqlParameter("@DPID", SqlDbType.VarChar),
new SqlParameter("@IsActive", SqlDbType.Int),
new SqlParameter("@ModifiedBy", SqlDbType.VarChar),
new SqlParameter("@Rval", SqlDbType.Int)
};
oPara[0].Value = ObjRouteMaster.RouteIDs;
oPara[0].Size = 255;
oPara[1].Value = ObjRouteMaster.IsActive;
oPara[1].Size = 155;
oPara[2].Value = ObjRouteMaster.ModifiedBy;
oPara[2].Size = 255;
oPara[3].Direction = ParameterDirection.ReturnValue;
ObjSqlHelper.ExecNonQueryProc(ConstantsDLL.USP_DeleteRoute, oPara);
return Convert.ToInt32(oPara[3].Value);
}
public List<RouteMaster> GetAllRoute(Int32? RouteId,Int32? DCID,bool? IsActive)
{
try
{
List<RouteMaster> list = null;
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@RouteID", RouteId);
param[1] = new SqlParameter("@DCID",DCID);
param[2] = new SqlParameter("@IsActive",IsActive);
using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper())
{
using (DataSet ds = db.ExecDataSetProc(ConstantsDLL.USP_GetAllRoutes, param))
{
if (ds != null && ds.Tables != null && ds.Tables[0].Rows.Count > 0)
{
list = new List<RouteMaster>();
for(int i = 0 ;i < ds.Tables[0].Rows.Count; i++)
{
var row = ds.Tables[0].Rows[i];
var rm = new RouteMaster();
rm.DPID = (string)(row["DPID"] == null || row["DPID"] == DBNull.Value ? string.Empty : row["DPID"].ToString());
rm.RouteID = (Int32)(row["RouteID"]);
rm.RouteName = (string)(row["RouteName"] ?? "");
rm.DropPoint = row["DropPoint"] == null || row["DropPoint"] == DBNull.Value ? string.Empty : row["DropPoint"].ToString();
rm.SortOrder = Convert.ToString(row["SortOrder"]);
rm.DCID = (Int32)(row["DCID"]);
rm.DCName = (string)(row["DCName"] ?? "");
rm.IsActive = Convert.ToBoolean(row["IsActive"]);
list.Add(rm);
}
return list;
}
else
{
return list;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public Int32 UpdateRouteMaster(RouteMaster ObjRouteMaster)
{
ObjSqlHelper = new SqlHelper.SqlHelper();
SqlParameter[] oPara =
{
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@RouteName", SqlDbType.VarChar),
new SqlParameter("@DropPoint", SqlDbType.VarChar),
new SqlParameter("@SortOrder", SqlDbType.Int),
new SqlParameter("@DCID",SqlDbType.Int),
new SqlParameter("@CreatedBy", SqlDbType.VarChar),
new SqlParameter("@Rval", SqlDbType.Int)
};
oPara[0].Value = ObjRouteMaster.DPID;
oPara[0].Size = 155;
oPara[1].Value = ObjRouteMaster.RouteName.Trim();
oPara[1].Size = 155;
oPara[2].Value = ObjRouteMaster.DropPoint.Trim();
oPara[2].Size = 255;
oPara[3].Value = ObjRouteMaster.SortOrder;
oPara[4].Value = ObjRouteMaster.DCID;
oPara[4].Size = 255;
oPara[5].Value = ObjRouteMaster.CreatedBy;
oPara[5].Size = 255;
oPara[6].Direction = ParameterDirection.ReturnValue;
ObjSqlHelper.ExecNonQueryProc(ConstantsDLL.USP_UpdateRoute, oPara);
return Convert.ToInt32(oPara[6].Value);
}
public Int32 UpdateRouteMaster(RouteMaster ObjRouteMaster)
{
return (ObjRouteDAL.UpdateRouteMaster(ObjRouteMaster));
}
public List<RouteMaster> GetSelectedrouteAccordingToDC(RouteMaster ObjRouteMaster)
{
try
{
// string qry = "usp_selectRoute";
var list = new List<RouteMaster>();
SqlParameter[] opara =
{
new SqlParameter("@DCID",SqlDbType.Int)
};
opara[0].Value = ObjRouteMaster.DCID;
opara[0].Size = 255;
using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper())
{
using (DataSet ds = db.ExecDataSetProc(ConstantsDLL.USP_GetSelectedrouteAccordingToDC, opara))
{
if (ds != null)
{
list = ds.Tables[0].AsEnumerable().Select(x => new RouteMaster
{
RouteID = (Int32)(x["RouteID"]),
RouteName = (string)(x["RouteName"] ?? ""),
DropPoint = (string)(x["DropPoint"] == null || x["DropPoint"] == DBNull.Value ? string.Empty : x["DropPoint"].ToString()),
SortOrder = Convert.ToString(x["SortOrder"]),
DCID = (Int32)(x["DCID"] ?? ""),
DCName = (string)(x["DCName"] ?? ""),
IsActive = (Boolean)(x["IsActive"] ?? "")
}).ToList();
return list;
}
else
{
return list;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public Int32 InsertRouteMaster(RouteMaster ObjRouteMaster)
{
return (ObjRouteDAL.InsertRouteMaster(ObjRouteMaster));
}
public Int32 InsertDropPoint(RouteMaster ObjRouteMaster)
{
return (ObjRouteDAL.InsertDropPoint(ObjRouteMaster));
}
public List<RouteMaster> GetSelectedrouteAccordingToDC(RouteMaster ObjRouteMaster)
{
return (ObjRouteDAL.GetSelectedrouteAccordingToDC(ObjRouteMaster));
}
public List<RouteMaster> GetSelectedroute(RouteMaster ObjRouteMaster)
{
return (ObjRouteDAL.GetSelectedroute(ObjRouteMaster));
}
public Int32 DeleteRouteMaster(RouteMaster ObjRouteMaster)
{
return (ObjRouteDAL.DeleteRouteMaster(ObjRouteMaster));
}