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