예제 #1
0
 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));
 }
예제 #2
0
 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));
 }
예제 #3
0
 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));
 }
예제 #4
0
 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));
 }
예제 #5
0
 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));
 }
예제 #6
0
 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));
 }
예제 #7
0
 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));
 }
예제 #8
0
 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));
 }
예제 #9
0
 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));
 }
예제 #10
0
 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]);
 }
예제 #11
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]);
 }
예제 #12
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]);
 }
예제 #13
0
 public int BL_DeleteCategory(ML_Panels objML_Panels)
 {
     return(objDL_Panels.DL_DeleteCategory(objML_Panels));
 }
예제 #14
0
 public int DL_DeleteCompanyInfo(ML_Panels objML_Panels)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
     return(SqlHelper.ExecuteNonQuery(con, "FBNPC_Company_Delete", par));
 }
예제 #15
0
 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]);
 }
예제 #16
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]);
 }
예제 #17
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]);
 }
예제 #18
0
 public DataTable BL_CategoryBind(ML_Panels objML_Panels)
 {
     return(objDL_Panels.DL_CategoryBind(objML_Panels));
 }
예제 #19
0
 public int DL_DeleteVideoImage(ML_Panels objML_Panels)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
     return(SqlHelper.ExecuteNonQuery(con, "FBNPC_VideoAndPicture_Delete", par));
 }
예제 #20
0
 public int BL_DeleteVideoImage(ML_Panels objML_Panels)
 {
     return(objDL_Panels.DL_DeleteVideoImage(objML_Panels));
 }
예제 #21
0
 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]);
 }
예제 #22
0
 public int BL_DeleteCompanyInfo(ML_Panels objML_Panels)
 {
     return(objDL_Panels.DL_DeleteCompanyInfo(objML_Panels));
 }
예제 #23
0
 public int DL_DeleteAchieverInfo(ML_Panels objML_Panels)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Panels.ID), };
     return(SqlHelper.ExecuteNonQuery(con, "KSCN_Achiever_Delete", par));
 }
예제 #24
0
 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]);
 }
예제 #25
0
 public int BL_InsGalleryImageInfo(ML_Panels objML_Panels)
 {
     return(objDL_Panels.DL_InsGalleryImageInfo(objML_Panels));
 }
예제 #26
0
 public int BL_InsCategoryInfo(ML_Panels objML_Panels)
 {
     return(objDL_Panels.DL_InsCategoryInfo(objML_Panels));
 }
예제 #27
0
 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]);
 }
예제 #28
0
 public DataTable BL_UpdateGalleryInfo(ML_Panels objML_Panels)
 {
     return(objDL_Panels.DL_UpdateGalleryInfo(objML_Panels));
 }
예제 #29
0
 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]);
 }
예제 #30
0
 public DataTable BL_AboutInfo(ML_Panels objML_Panels)
 {
     return(objDL_Panels.DL_AboutInfo(objML_Panels));
 }