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