public void AddPaperDetail(PaperMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@SubjectID", obj.SubjectId), //new SqlParameter("@TopicID",obj.TopicID), new SqlParameter("@GradeID", obj.GradeID), new SqlParameter("@IsYearwise", obj.IsYearwise), new SqlParameter("@Year", obj.Year), new SqlParameter("@Month", obj.Month), new SqlParameter("@IsSample", obj.IsSample), new SqlParameter("@Name", obj.Name), // new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0), new SqlParameter("@Description", obj.Description), new SqlParameter("@DiscountID", obj.DiscountID), new SqlParameter("@Price", obj.Price), new SqlParameter("@BaseCurrency", obj.BaseCurrency), new SqlParameter("@ValidFrom", obj.ValidFrom), new SqlParameter("@ValidUpto", obj.ValidUpto), new SqlParameter("@CreatedBy", obj.CreatedBy), new SqlParameter("@UpdatedBy", obj.UpdatedBy) }; DBOperate.ExecuteProcedureWithOutReturn("usp_AddPaper", parameter); } catch { throw; } }
public void AddMcqDetail(McqMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@TopicwisePaperID", obj.TopicwisePaperID), new SqlParameter("@YearwisePaperID", obj.YearwisePaperID), new SqlParameter("@QuestionText1", obj.QuestionText1), new SqlParameter("@QuestionImageLink", obj.QuestionImageLink), new SqlParameter("@QuestionImage2", obj.QuestionImage2), new SqlParameter("@QuestionAudioLink", obj.QuestionAudioLink), new SqlParameter("@CommonAnswerImage", obj.CommonAnswerImage), new SqlParameter("@QuestionText2", obj.QuestionText2), new SqlParameter("@HintText", obj.HintText), new SqlParameter("@HintImageLink", obj.SolutionImageLink), new SqlParameter("@HintAudioLink", obj.SolutionAudioLink), new SqlParameter("@VideoLink", obj.VideoLink), new SqlParameter("@VideoUrl", obj.VideoUrl), new SqlParameter("@SupportedDocumentLink", obj.SupportedDocumentLink), new SqlParameter("@SupportedDocumentLink2", obj.SupportedDocumentLink2), new SqlParameter("@SupportedDocumentLink3", obj.SupportedDocumentLink3), new SqlParameter("@Marks", obj.Marks), new SqlParameter("@TimeToSolve", obj.TimeToSolve), // new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0), new SqlParameter("@CreatedBy", obj.CreatedBy), new SqlParameter("@UpdatedBy", obj.UpdatedBy) }; DBOperate.ExecuteProcedureWithOutReturn("usp_AddMcq", parameter); } catch { throw; } }
public void DeletePaperDetail(int id) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@PaperID", id) }; DBOperate.ExecuteProcedureWithOutReturn("usp_DeletePaper", parameter); } catch { throw; } }
public void DisablePaperDetail(int id, string flag) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@PaperID", id), new SqlParameter("@DisableFlag", flag) }; DBOperate.ExecuteProcedureWithOutReturn("usp_DisablePaper", parameter); } catch { throw; } }
public void UpdateProductType(int id, int type) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@ProductID", id), new SqlParameter("@IsSample", type) }; DBOperate.ExecuteProcedureWithOutReturn("usp_UpdateProductType", parameter); } catch { throw; } }
public void AddGradeDetail(GradeMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@Grade", obj.Grade), // new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0), new SqlParameter("@Description", obj.Description), new SqlParameter("@CreatedBy", obj.CreatedBy), new SqlParameter("@UpdatedBy", obj.UpdatedBy) }; DBOperate.ExecuteProcedureWithOutReturn("usp_AddGrade", parameter); } catch { throw; } }
public void UpdateSubCourseDetail(SubCourseMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@SubCourseID", obj.SubCourseID), new SqlParameter("@Name", obj.Name), new SqlParameter("@CourseID", obj.CourseID), //new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0), new SqlParameter("@CreatedBy", obj.CreatedBy), new SqlParameter("@UpdatedBy", obj.UpdatedBy) }; DBOperate.ExecuteProcedureWithOutReturn("usp_UpdateSubCourse", parameter); } catch { throw; } }
public void AddTestimonialDetail(TestimonialMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@AuthorName", obj.AuthorName), new SqlParameter("@Photo", obj.Photo), // new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0), new SqlParameter("@Contents", obj.Contents), new SqlParameter("@CreatedBy", obj.CreatedBy), new SqlParameter("@UpdatedBy", obj.UpdatedBy) }; DBOperate.ExecuteProcedureWithOutReturn("usp_AddTestimonial", parameter); } catch { throw; } }
public void AddTopicDetail(TopicMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@SubjectID", obj.SubjectID), new SqlParameter("@Name", obj.Name), // new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0), new SqlParameter("@Description", obj.Description), new SqlParameter("@CreatedBy", obj.CreatedBy), new SqlParameter("@UpdatedBy", obj.UpdatedBy) }; DBOperate.ExecuteProcedureWithOutReturn("usp_AddTopic", parameter); } catch { throw; } }
public void UpdateUserDetail(UserMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@UserId", obj.UserId), new SqlParameter("@UserName", obj.UserName), new SqlParameter("@EmailID", obj.Email), new SqlParameter("@AccountStatus", obj.AccountStatus), new SqlParameter("@ValidFrom", obj.ValidFrom), new SqlParameter("@ValidUpto", obj.ValidTo) }; DBOperate.ExecuteProcedureWithOutReturn("usp_UpdateUserStatus", parameter); } catch { throw; } }
public void AddAnswerDetail(AnswerMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@McqID", obj.McqID), new SqlParameter("@SN", obj.SN), new SqlParameter("@AnswerType", obj.AnswerType), new SqlParameter("@Answer", obj.Answer), new SqlParameter("@AnswerImage", obj.AnswerImage), new SqlParameter("@IsVisible", obj.IsVisible), new SqlParameter("@Correct", obj.Correct) }; DBOperate.ExecuteProcedureWithOutReturn("usp_AddMcqAnswer", parameter); } catch { throw; } }
public void AddDiscountDetail(DiscountMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@Name", obj.Name), new SqlParameter("@Description", obj.Description), new SqlParameter("@Percentage", obj.Percentage), new SqlParameter("@ValidFrom", obj.ValidFrom), new SqlParameter("@ValidUpto", obj.ValidTo), // new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0), new SqlParameter("@CreatedBy", obj.CreatedBy), new SqlParameter("@UpdatedBy", obj.UpdatedBy) }; DBOperate.ExecuteProcedureWithOutReturn("usp_AddDiscount", parameter); } catch { throw; } }