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