public List <ELClass> SelectAllClass(string connectionString) { List <ELClass> classList = new List <ELClass>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand("EXEC SelectAllClass", conn)) { using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { ELClass objClass = new ELClass(); objClass.Id = Guid.Parse(reader[0].ToString()); objClass.Name = reader[1].ToString(); objClass.projectId = Guid.Parse(reader[2].ToString()); objClass.customerId = Guid.Parse(reader[3].ToString()); objClass.Description = reader[4].ToString(); objClass.ClassScope = reader[5].ToString(); objClass.ClassPublicVairables = reader[6].ToString(); objClass.Creator = Guid.Parse(reader[7].ToString()); objClass.CreatedAt = DateTime.Parse(reader[8].ToString()); objClass.Modifier = Guid.Parse(reader[9].ToString()); objClass.ModifiedAt = DateTime.Parse(reader[10].ToString()); classList.Add(objClass); } } } } return(classList); }
protected void AddClassSubmit_Click(object sender, EventArgs e) { ELClass classObject = new ELClass(); classObject.Name = TextBoxClassName.Text; classObject.projectId = Guid.Parse(DropDownListProjectName.Text); classObject.customerId = Guid.Parse(DropDownListCustomerName.Text); classObject.Description = TextBoxDescription.Text; classObject.ClassScope = DDClassScope.Text; classObject.ClassPublicVairables = TextBoxClassPublicVariable.Text; classObject.Creator = Id; classObject.CreatedAt = DateTime.Now; classObject.Modifier = classObject.Creator; classObject.ModifiedAt = classObject.CreatedAt; DLClass dLClass = new DLClass(); try { dLClass.AddClass(classObject, ObjConetion.connectionstring); Response.Redirect("ClassMenuPage.aspx?result=" + 1); } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You can not add the class')", true); } }
public ELClass SelectClass(ELClass elclass, string connectionString) { ELClass objClass = new ELClass(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand cmd = new SqlCommand("EXEC SelectClass @ClassId", conn); cmd.Parameters.Add(new SqlParameter("ClassId", elclass.Id)); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { objClass.Id = Guid.Parse(reader[0].ToString()); objClass.Name = (reader[1].ToString()); objClass.projectId = Guid.Parse(reader[2].ToString()); objClass.customerId = Guid.Parse(reader[3].ToString()); objClass.Description = (reader[4].ToString()); objClass.ClassScope = (reader[5].ToString()); objClass.ClassPublicVairables = (reader[6].ToString()); objClass.Creator = Guid.Parse(reader[7].ToString()); objClass.CreatedAt = DateTime.Parse(reader[8].ToString()); objClass.Modifier = Guid.Parse(reader[9].ToString()); objClass.ModifiedAt = DateTime.Parse(reader[10].ToString()); } } } return(objClass); }
public void DeleteClass(ELClass eLClass, string connectionString) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand cmd = new SqlCommand("EXEC DeleteClass @ClassId", conn); cmd.Parameters.Add(new SqlParameter("ClassId", eLClass.Id)); cmd.ExecuteNonQuery(); } }
protected void UpdateClassSubmit_Click(object sender, EventArgs e) { ELClass updateClass = new ELClass(); updateClass.Id = Guid.Parse(ClassId); updateClass.Name = TextBoxClassName.Text; updateClass.Description = TextBoxDescription.Text; updateClass.ClassPublicVairables = TextBoxClassPublicVariable.Text; updateClass.ClassScope = DDClassScope.Text; updateClass.Modifier = Guid.Parse(Session["UserId"].ToString()); updateClass.ModifiedAt = DateTime.Now; dLClass.UpdateClass(updateClass, ObjConetion.connectionstring); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Updated Successfully');Window.location ='ClassMenuPage.aspx';", true); }
protected void Page_Load(object sender, EventArgs e) { ELClass obj = new ELClass(); ClassId = Request.QueryString["classId"]; obj.Id = Guid.Parse(ClassId); obj = dLClass.SelectClass(obj, ObjConetion.connectionstring); if (!IsPostBack) { TextBoxClassName.Text = obj.Name; TextBoxDescription.Text = obj.Description; TextBoxClassPublicVariable.Text = obj.ClassPublicVairables; DDClassScope.Items.FindByValue(obj.ClassScope).Selected = true; ClassCreator.Text = obj.Creator.ToString(); ClassCreatedAt.Text = obj.CreatedAt.ToString(); } }
protected void GridViewClass_RowDeleting(object sender, GridViewDeleteEventArgs e) { Response.Write(GridViewClass.Rows[e.RowIndex].Cells[2].Text); var classId = GridViewClass.Rows[e.RowIndex].Cells[2].Text; ELClass ObjElClassDelete = new ELClass(); ObjElClassDelete.Id = Guid.Parse(classId); try { ObjDlClass.DeleteClass(ObjElClassDelete, ObjConetion.connectionstring); } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You Cant Delete the class because Its Refernces the Methods')", true); } ViewClassData(); BindGridList(); Response.Redirect("ClassMenuPage.aspx?result=-1"); }
public void UpdateClass(ELClass eLClass, string connectionString) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand cmd = new SqlCommand("EXEC UpdateClass @ClassId,@Name,@ProjectId,@CustomerId,@Description,@ClassScope,@ClassPublicVariables,@Modifier,@ModifiedAt", conn); cmd.Parameters.Add(new SqlParameter("ClassId", eLClass.Id)); cmd.Parameters.Add(new SqlParameter("Name", eLClass.Name)); cmd.Parameters.Add(new SqlParameter("ProjectId", eLClass.projectId)); cmd.Parameters.Add(new SqlParameter("CustomerId", eLClass.customerId)); cmd.Parameters.Add(new SqlParameter("Description", eLClass.Description)); cmd.Parameters.Add(new SqlParameter("ClassScope", eLClass.ClassScope)); cmd.Parameters.Add(new SqlParameter("ClassPublicVariables", eLClass.ClassScope)); cmd.Parameters.Add(new SqlParameter("Modifier", eLClass.Modifier)); cmd.Parameters.Add(new SqlParameter("ModifiedAt", eLClass.ModifiedAt)); cmd.ExecuteNonQuery(); } }