public int DL_InsStateInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@CountryID", objML_Panels.CountryID),
new SqlParameter("@Name", objML_Panels.Desc),
new SqlParameter("@StateID", objML_Panels.ID), };
return(SqlHelper.ExecuteNonQuery(con, "KSCN_State_Insert", par));
}
public int DL_InsUpdUserDetial(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@SliderCode", objML_Panels.SliderCode),
new SqlParameter("@SliderTitle", objML_Panels.SliderTitle),
new SqlParameter("@Sliderdesc", objML_Panels.Sliderdesc),
new SqlParameter("@CreatedBy", objML_Panels.CreatedBy),
new SqlParameter("@ModifyBy", objML_Panels.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Sliders_Insert", par));
}
public int DL_InsUpdComprehension(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ReadingID", objML_Panels.ReadingID),
new SqlParameter("@ComprehensionName", objML_Panels.ComprehensionName),
new SqlParameter("@ComprehensionDesc", objML_Panels.ComprehensionDesc),
new SqlParameter("@CreatedBy", objML_Panels.CreatedBy),
new SqlParameter("@ModifyBy", objML_Panels.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Comprehension_Insert", par));
}
public int DL_InsUpdCompanyAbout(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@CompanyName", objML_Panels.CompanyName),
new SqlParameter("@Desc", objML_Panels.CompanyDesc),
new SqlParameter("@ID", objML_Panels.ID),
new SqlParameter("@Category", objML_Panels.Category),
new SqlParameter("@ModifyBy", objML_Panels.ModifyBy),
new SqlParameter("@CreatedBy", objML_Panels.CreatedBy) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Company_Insert", par));
}
public int DL_InsCategoryInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@CategoryID", objML_Panels.ID),
new SqlParameter("@CategoryName", objML_Panels.Category),
new SqlParameter("@ISActive", objML_Panels.ISActive),
new SqlParameter("@Desc", objML_Panels.Desc),
new SqlParameter("@CreatedBy", objML_Panels.CreatedBy),
new SqlParameter("@ModifyBy", objML_Panels.ModifyBy),
new SqlParameter("@DocTypes", objML_Panels.DocTypes) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Category_Insert", par));
}
public int DL_InsGalleryInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@GalleryID", objML_Panels.ID),
new SqlParameter("@CompanyName", objML_Panels.CompanyName),
new SqlParameter("@category", objML_Panels.Category),
new SqlParameter("@GalleryType", objML_Panels.GalleryType),
new SqlParameter("@Name", objML_Panels.CompanyDesc),
new SqlParameter("@VideoLink", objML_Panels.Link),
new SqlParameter("@Desc", objML_Panels.Desc),
new SqlParameter("@CreatedBy", objML_Panels.CreatedBy),
new SqlParameter("@ModifyBy", objML_Panels.ModifyBy),
new SqlParameter("@ISActive", objML_Panels.ISActive) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Gallery_Insert", par));
}
public int DL_InsGalleryImageInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@GalleryID", objML_Panels.ID),
new SqlParameter("@CompanyName", objML_Panels.CompanyName),
new SqlParameter("@category", objML_Panels.Category),
new SqlParameter("@GalleryType", objML_Panels.GalleryType),
new SqlParameter("@Name", objML_Panels.CompanyDesc),
new SqlParameter("@Desc", objML_Panels.Desc),
new SqlParameter("@FileName", objML_Panels.PicName),
new SqlParameter("@FileType", objML_Panels.PicType),
new SqlParameter("@FileData", objML_Panels.PicData),
new SqlParameter("@CreatedBy", objML_Panels.CreatedBy),
new SqlParameter("@ModifyBy", objML_Panels.ModifyBy),
new SqlParameter("@ISActive", objML_Panels.ISActive),
new SqlParameter("@ImageID", objML_Panels.ImageID) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_GalleryImage_Insert", par));
}
public int DL_InsProgramsInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@Title", objML_Panels.Title),
new SqlParameter("@Desc", objML_Panels.Desc),
new SqlParameter("@ISActive", objML_Panels.ISActive),
new SqlParameter("@PicType", objML_Panels.PicType),
new SqlParameter("@PicData", objML_Panels.PicData),
new SqlParameter("@PicName", objML_Panels.PicName),
new SqlParameter("@CreatedBy", objML_Panels.CreatedBy),
new SqlParameter("@ModifyBy", objML_Panels.ModifyBy),
new SqlParameter("@DocType", objML_Panels.DocType),
new SqlParameter("@ID", objML_Panels.ID),
new SqlParameter("@ImageID", objML_Panels.ImageID),
new SqlParameter("@Country", objML_Panels.CountryID),
new SqlParameter("@State", objML_Panels.StateID),
new SqlParameter("@City", objML_Panels.CityID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Our_Programs_Insert", par));
}
public int DL_InsAchieverInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@AchieverID", objML_Panels.ID),
new SqlParameter("@FirstName", objML_Panels.FirstName),
new SqlParameter("@LastName", objML_Panels.LastName),
new SqlParameter("@City", objML_Panels.CityID),
new SqlParameter("@Country", objML_Panels.CountryID),
new SqlParameter("@OnLandingPage", objML_Panels.OnLandingPage),
new SqlParameter("@Desc", objML_Panels.Desc),
new SqlParameter("@ISActive", objML_Panels.ISActive),
new SqlParameter("@FileName", objML_Panels.PicName),
new SqlParameter("@FileType", objML_Panels.PicType),
new SqlParameter("@FileData", objML_Panels.PicData),
new SqlParameter("@ModifyBy", objML_Panels.ModifyBy),
new SqlParameter("@CreatedBy", objML_Panels.CreatedBy),
new SqlParameter("@ImageID", objML_Panels.ImageID),
new SqlParameter("@State", objML_Panels.StateID),
new SqlParameter("@DocType", objML_Panels.DocType) };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_AchieverImage_Insert", par));
}
public DataTable DL_CityBind(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "KSCN_City_Bind", par).Tables[0]);
}
public DataTable DL_StateCountryBind(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "KSCN_State_Country_Wise", par).Tables[0]);
}
public DataTable DL_StateEdit(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "KSCN_State_Select", par).Tables[0]);
}
public int BL_DeleteCategory(ML_Panels objML_Panels)
{
return(objDL_Panels.DL_DeleteCategory(objML_Panels));
}
public int DL_DeleteCompanyInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Company_Delete", par));
}
public DataTable DL_AboutInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Company_Bind", par).Tables[0]);
}
public DataTable DL_CategoryEdit(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Category_Edit", par).Tables[0]);
}
public DataTable DL_UpdateGalleryInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_GalleryUpdate_Bind", par).Tables[0]);
}
public DataTable BL_CategoryBind(ML_Panels objML_Panels)
{
return(objDL_Panels.DL_CategoryBind(objML_Panels));
}
public int DL_DeleteVideoImage(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteNonQuery(con, "FBNPC_VideoAndPicture_Delete", par));
}
public int BL_DeleteVideoImage(ML_Panels objML_Panels)
{
return(objDL_Panels.DL_DeleteVideoImage(objML_Panels));
}
public DataTable DL_UpdateAchieverInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "KSCN_Achiever_Select", par).Tables[0]);
}
public int BL_DeleteCompanyInfo(ML_Panels objML_Panels)
{
return(objDL_Panels.DL_DeleteCompanyInfo(objML_Panels));
}
public int DL_DeleteAchieverInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteNonQuery(con, "KSCN_Achiever_Delete", par));
}
public DataTable DL_BindAchieverList(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID) };
return(SqlHelper.ExecuteDataset(con, "KSCN_Achiever_Bind", par).Tables[0]);
}
public int BL_InsGalleryImageInfo(ML_Panels objML_Panels)
{
return(objDL_Panels.DL_InsGalleryImageInfo(objML_Panels));
}
public int BL_InsCategoryInfo(ML_Panels objML_Panels)
{
return(objDL_Panels.DL_InsCategoryInfo(objML_Panels));
}
public DataTable DL_ProgramsInfo(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_OurPrograms_All", par).Tables[0]);
}
public DataTable BL_UpdateGalleryInfo(ML_Panels objML_Panels)
{
return(objDL_Panels.DL_UpdateGalleryInfo(objML_Panels));
}
public DataTable DL_BindComprehension(ML_Panels objML_Panels)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Comprehension_Select", par).Tables[0]);
}
public DataTable BL_AboutInfo(ML_Panels objML_Panels)
{
return(objDL_Panels.DL_AboutInfo(objML_Panels));
}
