public ELProject SelectProject(ELProject eLProject, string connectionString)
{
ELProject objProject = new ELProject();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = connectionString;
conn.Open();
SqlCommand cmd = new SqlCommand("EXEC SelectProject @ProjectId", conn);
cmd.Parameters.Add(new SqlParameter("ProjectId", eLProject.Id));
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
objProject.Id = Guid.Parse(reader[0].ToString());
objProject.Name = (reader[1].ToString());
objProject.Creator = Guid.Parse(reader[2].ToString());
objProject.CreatedAt = DateTime.Parse(reader[3].ToString());
objProject.Modifier = Guid.Parse(reader[4].ToString());
objProject.ModifiedAt = DateTime.Parse(reader[5].ToString());
}
}
}
return(objProject);
}
protected void AddProjectSubmit_Click(object sender, EventArgs e)
{
Guid ProjectId;
ProjectId = Guid.NewGuid();
IdProjectId.Text = ProjectId.ToString();
IdProjectName.Text = TextBoxProjectName.Text;
IdProjectCreator.Text = UserName;
IdProjectCreatedAt.Text = DateTime.Now.ToString();
IdProjectModifier.Text = UserName;
IdProjectModifierAt.Text = DateTime.Now.ToString();
ELProject obj = new ELProject();
obj.Id = ProjectId;
obj.Name = TextBoxProjectName.Text;
obj.Creator = Id;
obj.CreatedAt = DateTime.Now;
obj.Modifier = Id;
obj.ModifiedAt = obj.CreatedAt;
DLProject dLProject = new DLProject();
dLProject.AddProject(obj, ObjConetion.connectionstring);
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert( '" + TextBoxProjectName.Text + " ' );window.location ='ProjectViewPage.aspx';", true);
}
public List <ELProject> SelectAllProject(string connectionString)
{
List <ELProject> projectList = new List <ELProject>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = connectionString;
conn.Open();
SqlCommand cmd = new SqlCommand("EXEC SelectAllProject", conn);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
ELProject obj = new ELProject();
obj.Id = Guid.Parse(reader[0].ToString());
obj.Name = (reader[1].ToString());
obj.Creator = Guid.Parse(reader[2].ToString());
obj.CreatedAt = DateTime.Parse(reader[3].ToString());
obj.Modifier = Guid.Parse(reader[4].ToString());
obj.ModifiedAt = DateTime.Parse(reader[5].ToString());
projectList.Add(obj);
}
}
}
return(projectList);
}
public void DeleteProject(ELProject eLProject, string connectionString)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = connectionString;
conn.Open();
SqlCommand cmd = new SqlCommand("EXEC DeleteProject @ProjectId", conn);
cmd.Parameters.Add(new SqlParameter("ProjectId", eLProject.Id));
cmd.ExecuteNonQuery();
}
}
protected void ProjectUpdateButton_Click(object sender, EventArgs e)
{
string pIdText = IdProjectName.Text;
ELProject updatedProject = new ELProject();
updatedProject.Id = Guid.Parse(ProjectId);
updatedProject.Name = pIdText;
updatedProject.Modifier = Guid.Parse(Session["UserId"].ToString());
updatedProject.ModifiedAt = DateTime.Now;
dLProject.UpdateProject(updatedProject, ObjConetion.connectionstring);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Updated Successfully');Window.location ='ProjectViewPage.aspx';", true);
}
public void UpdateProject(ELProject eLProject, string connectionString)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = connectionString;
conn.Open();
SqlCommand cmd = new SqlCommand("EXEC UpdateProject @ProjectId,@Name,@Modifier,@ModifiedAt", conn);
cmd.Parameters.Add(new SqlParameter("ProjectId", eLProject.Id));
cmd.Parameters.Add(new SqlParameter("Name", eLProject.Name));
cmd.Parameters.Add(new SqlParameter("Modifier", eLProject.Modifier));
cmd.Parameters.Add(new SqlParameter("ModifiedAt", eLProject.ModifiedAt));
cmd.ExecuteNonQuery();
}
}
protected void Page_Load(object sender, EventArgs e)
{
ELProject obj = new ELProject();
ProjectId = Request.QueryString["projectId"];
LabelProjectId.Text = ProjectId;
obj.Id = Guid.Parse(ProjectId);
obj = dLProject.SelectProject(obj, ObjConetion.connectionstring);
if (!IsPostBack)
{
IdProjectName.Text = obj.Name;
}
ProjectCreator.Text = obj.Creator.ToString();
ProjectCreatedAt.Text = obj.CreatedAt.ToString();
ProjectModifier.Text = obj.Modifier.ToString();
ProjectModifiedAt.Text = obj.ModifiedAt.ToString();
}
protected void GridPageView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//Response.Write(GridPageView.Rows[e.RowIndex].Cells[2].Text);
var proId = GridPageView.Rows[e.RowIndex].Cells[2].Text;
ELProject ObjElProjectDelete = new ELProject();
ObjElProjectDelete.Id = Guid.Parse(proId);
try
{
dLProject.DeleteProject(ObjElProjectDelete, ObjConetion.connectionstring);
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You Cant Delete Project because Its Refernce of Customer')", true);
}
ViewPorjectData();
BindGridList();
}
public void AddProject(ELProject elProject, string connectionString)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = connectionString;
conn.Open();
SqlCommand cmd =
new SqlCommand
("EXEC AddProject " +
"@Name, " +
"@Creator, " +
"@CreatedAt, " +
"@Modifier, " +
"@ModifiedAt", conn);
cmd.Parameters.Add(new SqlParameter("Name", elProject.Name));
cmd.Parameters.Add(new SqlParameter("Creator", elProject.Creator));
cmd.Parameters.Add(new SqlParameter("CreatedAt", elProject.CreatedAt));
cmd.Parameters.Add(new SqlParameter("Modifier", elProject.Modifier));
cmd.Parameters.Add(new SqlParameter("ModifiedAt", elProject.ModifiedAt));
cmd.ExecuteNonQuery();
}
}
