public ManagementPanelDTO InsertData() { ManagementPanelDTO MpClass = new ManagementPanelDTO(); //public int IdUniversity { set; get; } //public int IdCourseTimeClass { set; get; } //public int IdCourseType { set; get; } MpClass.Id = 0; MpClass.Class = txt_ClassName.Text; MpClass.Course = txt_CourseName.Text; MpClass.MeetingCount = int.Parse(ddl_MeetingCount.SelectedValue); MpClass.UserCount = int.Parse(ddl_CountOfUser.SelectedValue); MpClass.Tterm = ddl_Nimsal.SelectedValue; MpClass.IdUniversity = 1; MpClass.IdCourseTimeClass = int.Parse(ddl_TimeClass.SelectedValue); MpClass.IdCourseType = int.Parse(ddl_ClassType.SelectedValue); List <long> AdobeAbility = new List <long>(); for (int i = 0; i < CheckBoxList1.Items.Count; i++) { if (CheckBoxList1.Items[i].Selected == true) { AdobeAbility.Add(int.Parse(CheckBoxList1.Items[i].Value)); } } MpClass.List_Id_AdobeAbility = AdobeAbility; long x = MpClass.List_Id_AdobeAbility.ElementAt(1); return(MpClass); }
public bool Insert_CourseClass(ManagementPanelDTO MpClass) { SqlCommand cmdCourseClassSave = new SqlCommand(); cmdCourseClassSave.Connection = conn; cmdCourseClassSave.CommandText = "Adobe.SP_Insert_Course_Class"; cmdCourseClassSave.CommandType = CommandType.StoredProcedure; cmdCourseClassSave.Parameters.AddWithValue("@Class", MpClass.Class); cmdCourseClassSave.Parameters.AddWithValue("@Course", MpClass.Course); cmdCourseClassSave.Parameters.AddWithValue("@MeetingCount", MpClass.MeetingCount); cmdCourseClassSave.Parameters.AddWithValue("@UserCount", MpClass.UserCount); cmdCourseClassSave.Parameters.AddWithValue("@tterm", MpClass.Tterm); cmdCourseClassSave.Parameters.AddWithValue("@IdUniversity", MpClass.IdUniversity); cmdCourseClassSave.Parameters.AddWithValue("@id_Course_TimeClass", MpClass.IdCourseTimeClass); cmdCourseClassSave.Parameters.AddWithValue("@id_Course_Type", MpClass.IdCourseType); SqlParameter outputIdParam = new SqlParameter("@Id", SqlDbType.BigInt) { Direction = ParameterDirection.Output }; try { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } cmdCourseClassSave.ExecuteNonQuery(); long Id = long.Parse(outputIdParam.Value.ToString()); if (Id == 0) { conn.Close(); return(false); } else { conn.Close(); for (int i = 0; i < MpClass.List_Id_AdobeAbility.Count; i++) { Insert_Course_AdobeAbility(Id, MpClass.List_Id_AdobeAbility.ElementAt(i)); } return(true); } } catch (Exception) { return(false); } }
public ManagementPanelDTO InsertData() { ManagementPanelDTO MpClass = new ManagementPanelDTO(); MpClass.Id = 0; MpClass.Name = txt_NameFa.Text; MpClass.Family = txt_FamilyFa.Text; MpClass.LatinName = txt_NameEn.Text; MpClass.LatinFamily = txt_FamilyEn.Text; MpClass.NationalID = txt_NationalID.Text; MpClass.Mobile = txt_Mobile.Text; MpClass.EmailAddress = txt_EmailAddress.Text; MpClass.UserName = txt_UserName.Text; MpClass.Password = CommonBusiness.EncryptPass(txt_Password.Text); MpClass.TypeAccount = int.Parse(ddl_TypeAccount.SelectedIndex.ToString()); return(MpClass); }
public ManagementPanelDTO InsertData() { ManagementPanelDTO MpClass = new ManagementPanelDTO(); //MpClass.Id=0; //MpClass.Class=txt_ClassName.Text; //MpClass.Course = txt_CourseName.Text; //MpClass.MeetingCount = int.Parse(ddl_MeetingCount.SelectedValue); //MpClass.UserCount = int.Parse(txt_CountOfUser.Text); //MpClass.Tterm = ddl_Nimsal.SelectedValue; //MpClass.SaatStart = txt_TimeStart.Text; //MpClass.SaatEnd = txt_TimeEnd.Text; //MpClass.IdRoz = ddl_Day.SelectedIndex; //MpClass.idUniversity = 1; //MpClass.idType = ddl_ClassType.SelectedIndex; return(MpClass); }
public bool Insert_CourseUser(ManagementPanelDTO MpDTO) { SqlCommand cmdexamclassSave = new SqlCommand(); cmdexamclassSave.Connection = conn; cmdexamclassSave.CommandText = "Adobe.SP_Insert_Course_User"; cmdexamclassSave.CommandType = CommandType.StoredProcedure; cmdexamclassSave.Parameters.AddWithValue("@Name", MpDTO.Name); cmdexamclassSave.Parameters.AddWithValue("@Family", MpDTO.Family); cmdexamclassSave.Parameters.AddWithValue("@LatinName", MpDTO.LatinName); cmdexamclassSave.Parameters.AddWithValue("@LatinFamily", MpDTO.LatinFamily); cmdexamclassSave.Parameters.AddWithValue("@NationalID", MpDTO.NationalID); cmdexamclassSave.Parameters.AddWithValue("@Mobile", MpDTO.Mobile); cmdexamclassSave.Parameters.AddWithValue("@Email_Address", MpDTO.EmailAddress); cmdexamclassSave.Parameters.AddWithValue("@UserName", MpDTO.UserName); cmdexamclassSave.Parameters.AddWithValue("@Password", MpDTO.Password); cmdexamclassSave.Parameters.AddWithValue("@TypeAccount", MpDTO.TypeAccount); DataTable dt = new DataTable(); try { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } cmdexamclassSave.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception) { return(false); } }
public bool Insert_CourseUser(ManagementPanelDTO MpDTO) { return(MpDAO.Insert_CourseUser(MpDTO)); }
public bool Insert_CourseClass(ManagementPanelDTO MpClass) { return(MpDAO.Insert_CourseClass(MpClass)); }