public ELMethods SelectMethods(ELMethods eLMethods, string connectionString) { ELMethods objMethods = new ELMethods(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand cmd = new SqlCommand("EXEC SelectMethods @Id", conn); cmd.Parameters.Add(new SqlParameter("Id", eLMethods.Id)); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { objMethods.Id = Guid.Parse(reader[0].ToString()); objMethods.Name = (reader[1].ToString()); objMethods.ClasssId = Guid.Parse(reader[2].ToString()); objMethods.Description = (reader[3].ToString()); objMethods.Scope = (reader[4].ToString()); objMethods.ReturnType = (reader[5].ToString()); objMethods.Creator = Guid.Parse(reader[6].ToString()); objMethods.CreatedAt = DateTime.Parse(reader[7].ToString()); objMethods.Modifier = Guid.Parse(reader[8].ToString()); objMethods.ModifiedAt = DateTime.Parse(reader[9].ToString()); } } } return(objMethods); }
protected void Page_Load(object sender, EventArgs e) { UserName = Session["UserName"].ToString(); Id = Session["UserId"].ToString(); IdUserName.Text = UserName; IdUserId.Text = Id; Response.Write(MethodId); ELMethods ObjElMethod = new ELMethods(); MethodId = Request.QueryString["MethodId"]; LebelMethodId.Text = MethodId; ObjElMethod.Id = Guid.Parse(MethodId); ObjElMethod = ObjDlMethod.SelectMethods(ObjElMethod, ObjConetion.connectionstring); if (!IsPostBack) { TextBoxMethodName.Text = ObjElMethod.Name; DropDownListMethodScope.Text = ObjElMethod.Scope; DropDownListMethodReturnType.Text = ObjElMethod.ReturnType; TextBoxDescription.Text = ObjElMethod.Description; } ClassId.Text = ObjElMethod.ClasssId.ToString(); MethodCreator.Text = ObjElMethod.Creator.ToString(); MethodCreatedAt.Text = ObjElMethod.CreatedAt.ToString(); MethodModifiedAt.Text = ObjElMethod.ModifiedAt.ToString(); MethodModifier.Text = ObjElMethod.Modifier.ToString(); }
public List <ELMethods> SelectAllMethods(string connectionString) { List <ELMethods> methodList = new List <ELMethods>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand cmd = new SqlCommand("EXEC SelectAllMethods", conn); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { ELMethods objMethod = new ELMethods(); objMethod.Id = Guid.Parse(reader[0].ToString()); objMethod.Name = (reader[1].ToString()); objMethod.ClasssId = Guid.Parse(reader[2].ToString()); objMethod.Description = (reader[3].ToString()); objMethod.Scope = (reader[4].ToString()); objMethod.ReturnType = (reader[5].ToString()); objMethod.Creator = Guid.Parse(reader[6].ToString()); objMethod.CreatedAt = DateTime.Parse(reader[7].ToString()); objMethod.Modifier = Guid.Parse(reader[8].ToString()); objMethod.ModifiedAt = DateTime.Parse(reader[9].ToString()); methodList.Add(objMethod); } } } return(methodList); }
public void DeleteMethods(ELMethods eLMethods, string connectionString) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand cmd = new SqlCommand("EXEC DeleteMethods @Id", conn); cmd.Parameters.Add(new SqlParameter("Id", eLMethods.Id)); cmd.ExecuteNonQuery(); } }
protected void UpdateMethodSubmit_Click(object sender, EventArgs e) { ELMethods ObjElMethodUpdate = new ELMethods(); ObjElMethodUpdate.Id = Guid.Parse(MethodId); ObjElMethodUpdate.Name = TextBoxMethodName.Text; ObjElMethodUpdate.Scope = DropDownListMethodScope.Text; ObjElMethodUpdate.ReturnType = DropDownListMethodReturnType.Text; ObjElMethodUpdate.Description = TextBoxDescription.Text; ObjElMethodUpdate.Modifier = Guid.Parse(Id); ObjElMethodUpdate.ModifiedAt = DateTime.Now; ObjDlMethod.UpdateMethods(ObjElMethodUpdate, ObjConetion.connectionstring); }
public void UpdateMethods(ELMethods eLMethods, string connectionString) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand cmd = new SqlCommand("EXEC UpdateMethods @Id,@Name,@ClassId,@Description,@MethodScope,@ReturnType,@Modifier,@ModifiedAt", conn); cmd.Parameters.Add(new SqlParameter("Id", eLMethods.Id)); cmd.Parameters.Add(new SqlParameter("Name", eLMethods.Name)); cmd.Parameters.Add(new SqlParameter("ClassId", eLMethods.ClasssId)); cmd.Parameters.Add(new SqlParameter("Description", eLMethods.Description)); cmd.Parameters.Add(new SqlParameter("MethodScope", eLMethods.Scope)); cmd.Parameters.Add(new SqlParameter("ReturnType", eLMethods.ReturnType)); cmd.Parameters.Add(new SqlParameter("Modifier", eLMethods.Modifier)); cmd.Parameters.Add(new SqlParameter("ModifiedAt", eLMethods.ModifiedAt)); cmd.ExecuteNonQuery(); } }
protected void GridViewMethodsView_RowDeleting(object sender, GridViewDeleteEventArgs e) { Response.Write(GridViewMethodsView.Rows[e.RowIndex].Cells[2].Text); var methodId = GridViewMethodsView.Rows[e.RowIndex].Cells[2].Text; ELMethods ObjElMethodDelete = new ELMethods(); ObjElMethodDelete.Id = Guid.Parse(methodId); try { ObjDlMethod.DeleteMethods(ObjElMethodDelete, ObjConetion.connectionstring); } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You Cant Delete Method because Its Refernce of Perameter')", true); } ViewMethod(); BindDataList(); }
protected void AddMethodSubmit_Click(object sender, EventArgs e) { Guid MethodId; MethodId = new Guid(); ELMethods ObjELMethod = new ELMethods(); ObjELMethod.Id = MethodId; ObjELMethod.Name = TextBoxMethodName.Text; ObjELMethod.ClasssId = Guid.Parse(DropDownListClassId.Text); ObjELMethod.Scope = DropDownListMethodScope.Text; ObjELMethod.ReturnType = DropDownListMethodReturnType.Text; ObjELMethod.Description = TextBoxDescription.Text; ObjELMethod.Creator = Id; ObjELMethod.CreatedAt = DateTime.Now; ObjELMethod.Modifier = Id; ObjELMethod.ModifiedAt = ObjELMethod.CreatedAt; DLMethods ObjDlMethods = new DLMethods(); ObjDlMethods.AddMethods(ObjELMethod, ObjConetion.connectionstring); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert( '" + TextBoxMethodName.Text + " ' );window.location ='MethodsViewPage.aspx';", true); }