public int SavePrimaryURL(IndiaMartViewModel foRequest)
{
List <SqlParameter> loSqlParameters = new List <SqlParameter>();
loSqlParameters.Add(new SqlParameter("stPrimaryURL", foRequest.stPrimaryURL.handleDBNull()));
loSqlParameters.Add(new SqlParameter("stURLInnerText", foRequest.stURLInnerText.handleDBNull()));
loSqlParameters.Add(new SqlParameter("flgIsCompleted", foRequest.flgIsCompleted.handleDBNull()));
return(new IndiaMartDataContext().Database.SqlQuery <int>("SavePhase1".getSql(loSqlParameters), loSqlParameters.ToArray()).FirstOrDefault());
}
public int saveSiteMapInformation(IndiaMartViewModel foRequest)
{
List <SqlParameter> loSqlParameters = new List <SqlParameter>();
loSqlParameters.Add(new SqlParameter("stHostURL", foRequest.stHostURL.handleDBNull()));
loSqlParameters.Add(new SqlParameter("stLevel1Name", foRequest.stLevel1Name.handleDBNull()));
loSqlParameters.Add(new SqlParameter("stLevel1URL", foRequest.stLevel1URL.handleDBNull()));
loSqlParameters.Add(new SqlParameter("stLevel2Name", foRequest.stLevel2Name.handleDBNull()));
loSqlParameters.Add(new SqlParameter("stLevel2URL", foRequest.stLevel2URL.handleDBNull()));
loSqlParameters.Add(new SqlParameter("stLevel3Name", foRequest.stLevel3Name.handleDBNull()));
loSqlParameters.Add(new SqlParameter("stLevel3URL", foRequest.stLevel3URL.handleDBNull()));
loSqlParameters.Add(new SqlParameter("flgIsSiteMapProcessDone", foRequest.flgIsSiteMapProcessDone.handleDBNull()));
return(new IndiaMartDataContext().Database.SqlQuery <int>("SaveSiteMap".getSql(loSqlParameters), loSqlParameters.ToArray()).FirstOrDefault());
}