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;
}
}
