public string DeleteStudyMaterial(StudyMaterialViewModel objStudyMaterial) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("StudyMaterialID", objStudyMaterial.StudyMaterialID)); return(DGeneric.RunSP_ExecuteNonQuery("sp_DeleteStudyMaterial", sqlParameterList)); }
public StudyMaterialViewModel GetStudyMaterialByID(int StudyMaterialID) { var studyMaterialViewModelData = new StudyMaterialViewModel(); List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("@StudyMaterialID", StudyMaterialID)); DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetStudyMaterialByID", sqlParameterList, null).Tables[0]; if (dt.Rows.Count > 0) { return(DGeneric.BindDataList <StudyMaterialViewModel>(dt).FirstOrDefault()); } else { return(new List <StudyMaterialViewModel>().FirstOrDefault()); } //if (ds.Tables.Count > 0) //{ // studyMaterialViewModelData = DGeneric.BindDataList<OnlineTestViewModel>(dt).FirstOrDefault(); // studyMaterialViewModelData.StreamID = dt.Rows[0]["StreamID"].ToString().Split(',').Select(int.Parse).ToArray(); // //Vaibhav Changed because of empty data // // onlineTestViewModelData.CourseID = dt.Rows[0]["CourseID"].ToString().Split(',').Select(int.Parse).ToArray(); // // onlineTestViewModelData.BatchID = dt.Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray(); // studyMaterialViewModelData.CourseID = dt.Rows[0]["CourseID"].ToString() != string.Empty ? dt.Rows[0]["CourseID"].ToString().Split(',').Select(int.Parse).ToArray() : null; // studyMaterialViewModelData.BatchID = dt.Rows[0]["BatchID"].ToString() != string.Empty ? dt.Rows[0]["BatchID"].ToString().Split(',').Select(int.Parse).ToArray() : null; //} //return studyMaterialViewModelData; }
public string AddUpdateStudyMaterial(StudyMaterialViewModel objStudyMaterial) { List <SqlParameter> sqlParameterList = new List <SqlParameter>(); sqlParameterList.Add(new SqlParameter("StudyMaterialID", objStudyMaterial.StudyMaterialID)); sqlParameterList.Add(new SqlParameter("Tittle", objStudyMaterial.Tittle)); sqlParameterList.Add(new SqlParameter("SubTittle", objStudyMaterial.SubTittle)); sqlParameterList.Add(new SqlParameter("Description", !string.IsNullOrEmpty(objStudyMaterial.Description) ? objStudyMaterial.Description : string.Empty)); sqlParameterList.Add(new SqlParameter("TopicID", objStudyMaterial.TopicID > 0 ? objStudyMaterial.TopicID : 0)); sqlParameterList.Add(new SqlParameter("SubTopicID", objStudyMaterial.SubTopicID > 0 ? objStudyMaterial.SubTopicID : 0)); sqlParameterList.Add(new SqlParameter("SubjectID", objStudyMaterial.SubjectID > 0 ? objStudyMaterial.SubjectID : 0)); sqlParameterList.Add(new SqlParameter("Thumbnail", !string.IsNullOrEmpty(objStudyMaterial.Thumbnail) ? objStudyMaterial.Thumbnail : string.Empty)); sqlParameterList.Add(new SqlParameter("URL_English", !string.IsNullOrEmpty(objStudyMaterial.URL_English) ? objStudyMaterial.URL_English : string.Empty)); sqlParameterList.Add(new SqlParameter("URL_Hindi", !string.IsNullOrEmpty(objStudyMaterial.URL_Hindi) ? objStudyMaterial.URL_Hindi : string.Empty)); sqlParameterList.Add(new SqlParameter("IsActive", objStudyMaterial.IsActive)); sqlParameterList.Add(new SqlParameter("CreatedByUserID", 1)); sqlParameterList.Add(new SqlParameter("CreatedOnDate", DGeneric.SystemDateTime)); string response = DGeneric.RunSP_ExecuteNonQuery("sp_AddUpdateStudyMaterial", sqlParameterList); return(response); }
public string DeleteStudyMaterial(StudyMaterialViewModel objStudyMaterial) { return(_iDStudyMaterial.DeleteStudyMaterial(objStudyMaterial)); }
public string AddUpdateStudyMaterial(StudyMaterialViewModel objStudyMaterial) { return(_iDStudyMaterial.AddUpdateStudyMaterial(objStudyMaterial)); }
public HttpResponseMessage DeleteStudyMaterial(StudyMaterialViewModel objStudyMaterial) { return(Request.CreateResponse(HttpStatusCode.OK, _iBStudyMaterial.DeleteStudyMaterial(objStudyMaterial))); }