public string EditProject(ProjectDetailsModel projectdetails)
{
int result = 0;
try
{
sqlConnection = OpenConnection();
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "uspEditProjectDetails";
sqlCommand.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = projectdetails.EmployeeID;
sqlCommand.Parameters.Add("@Project_Name", SqlDbType.VarChar).Value = projectdetails.Project_Name;
sqlCommand.Parameters.Add("@Client_Name", SqlDbType.VarChar).Value = projectdetails.Client_Name;
sqlCommand.Parameters.Add("@Location", SqlDbType.VarChar).Value = projectdetails.Location;
sqlCommand.Parameters.Add("@Roles", SqlDbType.VarChar).Value = projectdetails.Roles;
result = sqlCommand.ExecuteNonQuery();
if (result > 0)
{
return("success");
}
return("failed");
}
catch (Exception ex)
{
return("An error has been occured, please contact administrator:" + ex.Message);
}
finally
{
CloseConncetion(sqlConnection);
}
}
// GET: Project/Edit/5
public ActionResult Edit(int id)
{
ProjectDetailsModel projmod = new ProjectDetailsModel();
DataTable dbproject = new DataTable();
using (SqlConnection sqlcon = new SqlConnection(connectionstring))
{
sqlcon.Open();
string editquery = "SELECT * FROM Project_Details WHERE EmployeeID=@EmployeeID";
SqlDataAdapter sqladp = new SqlDataAdapter(editquery, sqlcon);
sqladp.SelectCommand.Parameters.AddWithValue("@EmployeeID", id);
sqladp.Fill(dbproject);
}
if (dbproject.Rows.Count == 1)
{
projmod.EmployeeID = Convert.ToInt32(dbproject.Rows[0][0].ToString());
projmod.Project_Name = dbproject.Rows[0][1].ToString();
projmod.Client_Name = dbproject.Rows[0][2].ToString();
projmod.Location = dbproject.Rows[0][3].ToString();
projmod.Roles = dbproject.Rows[0][4].ToString();
return(View(projmod));
}
else
{
return(RedirectToAction("Index"));
}
}
public ProjectEditModel GetProjectEditModel(Project Project)
{
//HolidayLocation hol1 = new HolidayLocation ;
//holidayLocation.Add(hol);
ProjectDetailsModel details = new ProjectDetailsModel
{
ID = Project.ID,
Name = Project.Name,
Project_Description = Project.Comments,
ImageName = Project.ImageName,
ImageOriginalName = Project.ImageOriginalName
};
ProjectEditModel editModel = new ProjectEditModel();
editModel.details = details;
return(editModel);
}
public async Task <IActionResult> ProjectDelete(ProjectDetailsModel pDM)
{
foreach (ZespolProjekt delZP in _s16693context.ZespolProjekt)
{
if (delZP.IdProjekt == pDM.projekt.IdProjekt)
{
_s16693context.ZespolProjekt.Remove(delZP);
}
}
foreach (ProjektPakiet delPP in _s16693context.ProjektPakiet)
{
if (delPP.IdProjekt == pDM.projekt.IdProjekt)
{
_s16693context.ProjektPakiet.Remove(delPP);
}
}
foreach (UslugaProjekt delZadP in _s16693context.UslugaProjekt)
{
if (delZadP.IdProjekt == pDM.projekt.IdProjekt)
{
_s16693context.UslugaProjekt.Remove(delZadP);
}
}
var projekt = await _s16693context.Projekt.FindAsync(pDM.projekt.IdProjekt);
_s16693context.Remove(projekt);
await _s16693context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
public async Task <IActionResult> ProjectDetails(int?id)
{
if (id == null)
{
return(NotFound());
}
var project = await _s16693context.Projekt
.FirstOrDefaultAsync(e => e.IdProjekt == id);
var tasks = await _s16693context.UslugaProjekt
.Include(p => p.IdProjektNavigation)
.Include(z => z.IdUslugaNavigation)
.Where(e => e.IdProjekt == id && e.IdUslugaNavigation.Klasyfikacja == HttpContext.User.FindFirst(ClaimTypes.Role).Value)
.ToListAsync();
var pDM = new ProjectDetailsModel
{
projekt = project,
zadanies = tasks
};
if (project == null)
{
return(NotFound());
}
else
{
return(View(pDM));
}
}
protected void SaveButton_Click1(object sender, EventArgs e)
{
ProjectDetailsModel projectDetailobj = new ProjectDetailsModel
{
ProjectName = ProjectNameTextBox.Text,
ClientName = ClientNameTextBox.Text,
Location = Location_TextBox.Text,
Roles = RolesTextBox.Text,
EmployeeId = Convert.ToInt32(ProjectEmployeeDropDownList1.Text)
};
EmployeeDataAccessLayer projectDataAccessobj = new EmployeeDataAccessLayer();
long RowsAffected = projectDataAccessobj.ProjectSqlConnection(projectDetailobj);
if (RowsAffected > 0)
{
string display = "Successful!";
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true);
}
else
{
string display = "UnSuccessful!";
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true);
}
}
public int SaveProject(ProjectDetailsModel project)
{
int result = 0;
try
{
string connectionstring = "Data Source=RAKI;Initial Catalog=PioneerEmployeeDB;" +
" Integrated Security=True";
SqlConnection mysqlconnection = new SqlConnection(connectionstring);
mysqlconnection.Open();
string sqlprojectdetails = @"INSERT INTO Project_Details(EmployeeID,Project_Name,Client_Name,Location,Roles)VALUES(" + project.EmployeeID + "," + "'" + project.Project_Name + "'," + "'" + project.Client_Name + "'," + "'" + project.Location + "'," + "'" + project.Roles + "')";
SqlCommand command;
command = new SqlCommand(sqlprojectdetails, mysqlconnection);
result = command.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("Details have been saved Successfully:");
}
mysqlconnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("An error has been occured, please contact the administartor: " + ex.Message);
}
return(result);
}
protected void EditButton_Click(object sender, EventArgs e)
{
ProjectDetailsModel model = new ProjectDetailsModel
{
ProjectName = ProjectNameTextBox.Text,
ClientName = ClientNameTextBox.Text,
Location = Location_TextBox.Text,
Roles = RolesTextBox.Text,
//EmployeeId = Convert.ToInt32(EmployeeId_TextBox.Text)
EmployeeId = Convert.ToInt32(ProjectEmployeeDropDownList1.Text)
};
int EditEmployeeId = Convert.ToInt32(Project_Edit_DropDownList1.Text);
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = DESKTOP-6T65F42;" +
"database = PioneerTechConsultancy_Database;Integrated security = SSPI";
SqlCommand projectDetail_cmd = new SqlCommand("UPDATE [ProjectDetail] SET[ProjectName] = " +
"'" + model.ProjectName + "',[ClientName] = '" + model.ClientName + "',[Location] = '" + model.Location + "',[Roles] =' " + model.Roles +
"'WHERE EmployeeID = " + EditEmployeeId, mysqlconnection);
mysqlconnection.Open();
int result = projectDetail_cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert(' Project Details SUCCESSFULLY Edited');", true);
}
private void Savebutton5_Click(object sender, EventArgs e)
{
try
{
ProjectDetailsModel pro = new ProjectDetailsModel();
pro.ProjectID = Convert.ToInt32(ProjectIDtextBox.Text);
pro.EmployeeID = Convert.ToInt32(EmployeeID1textbox.Text);
pro.ProjectName = ProjectNametextbox.Text;
pro.ClientName = Clientnametextbox.Text;
pro.Location = Location1textbox.Text;
pro.Role = Roletextbox.Text;
EmployeeDataAcessLayer objprojectdetails = new EmployeeDataAcessLayer();
objprojectdetails.SaveProject(pro);
/*string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
* "Integrated Security=True";
* SqlConnection mysqlconnection = new SqlConnection(connectionstring);
* mysqlconnection.Open();
* string COMMAND = "INSERT INTO PROJECTDETAILS(ProjectID,EmployeeID,ProjectName,ClientName,Location,Role)VALUES("+ProjectID+","+""+ EmployeeID + "," + "'" + ProjectName + "'," + "'" + ClientName + "'," + "'" + Location + "'," + "'" + Role + "')";
* SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
* cmd.ExecuteNonQuery();
* mysqlconnection.Close();*/
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void EmployeeIDDropDownList_SelectedIndexchanged(object sender, EventArgs e)
{
ProjectDetailsModel projmodel = new ProjectDetailsModel();
ProjectDataAccess projdata = new ProjectDataAccess();
projmodel = projdata.GetProjectDetails(Convert.ToInt32(EmployeeIDDropDownList.SelectedValue));
Project_NameTextBox.Text = projmodel.Project_Name;
Client_NameTextBox.Text = projmodel.Client_Name;
LocationTextBox.Text = projmodel.Location;
RolesTextBox.Text = projmodel.Roles;
}
public async Task <IActionResult> Details(int page = 1)
{
var model = new ProjectDetailsModel();
model.Projects = _projectData.GetAll();
return(View(model));
//return View(await _context.Projects.ToListAsync());
//var qry = _context.Projects.AsNoTracking().OrderBy(p => p.ProjectName);
//var model = await PagingList.CreateAsync(qry, 10, page);
//return View(model);
}
public int AddtoProjectDetails(ProjectDetailsModel proj_details)
{
sqlConnection = OpenConnection();
sqlConnection.Open();
sqlCommand = new SqlCommand("INSERT INTO ProjectDetails VALUES(" +
"'" + proj_details.ProjectName + "','" + proj_details.ClientName + "','" + proj_details.Location + "','" +
proj_details.Role + "'," + proj_details.EmployeeID + ")", sqlConnection);
int result = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return(result);
}
protected void ProjectDetails_SaveButtonID_Click(object sender, EventArgs e)
{
ProjectDetailsModel proj_details = new ProjectDetailsModel
{
ProjectName = ProjectNameTextBox.Text,
ClientName = ClientNameTextBox.Text,
Location = LocationTextBox.Text,
Role = "",
EmployeeID = Convert.ToInt16(ProjectDetailsEmployeeIDTextBox.Text)
};
EmployeeDataAccessLayer employeeDataAccessLayer = new EmployeeDataAccessLayer();
employeeDataAccessLayer.AddtoProjectDetails(proj_details);
}
public long ProjectSqlConnection(ProjectDetailsModel ProjectDetailsmodel)
{
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = DESKTOP-6T65F42;" +
"database = PioneerTechConsultancy_Database;Integrated security = SSPI";
mysqlconnection.Open();
SqlCommand ProjectDetailCommand = new SqlCommand("INSERT INTO ProjectDetail VALUES(" +
"'" + ProjectDetailsmodel.ProjectName + "','" + ProjectDetailsmodel.ClientName + "','" + ProjectDetailsmodel.Location + "','" +
ProjectDetailsmodel.Roles + "'," + ProjectDetailsmodel.EmployeeId + ")", mysqlconnection);
long ProjectConnection = ProjectDetailCommand.ExecuteNonQuery();
mysqlconnection.Close();
return(ProjectConnection);
}
public ActionResult Edit(ProjectDetailsModel prdmodel)
{
using (SqlConnection sqlcon = new SqlConnection(connectionstring))
{
sqlcon.Open();
string edquery = "UPDATE Project_Details SET Project_Name=@Project_Name,Client_Name=@Client_Name,Location=@Location,Roles=@Roles WHERE EmployeeID=@EmployeeID";
SqlCommand cmd = new SqlCommand(edquery, sqlcon);
cmd.Parameters.AddWithValue("@Project_Name", prdmodel.Project_Name);
cmd.Parameters.AddWithValue("@Client_Name", prdmodel.Client_Name);
cmd.Parameters.AddWithValue("@Location", prdmodel.Location);
cmd.Parameters.AddWithValue("@Roles", prdmodel.Roles);
cmd.Parameters.AddWithValue("@EmployeeID", prdmodel.EmployeeID);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(ProjectDetailsModel prmodel)
{
using (SqlConnection sqlcon = new SqlConnection(connectionstring))
{
sqlcon.Open();
string query = "INSERT INTO Project_Details VALUES(@Project_Name,@Client_Name,@Location,@Roles,@EmployeeID)";
SqlCommand cmd = new SqlCommand(query, sqlcon);
cmd.Parameters.AddWithValue("@Project_Name", prmodel.Project_Name);
cmd.Parameters.AddWithValue("@Client_Name", prmodel.Client_Name);
cmd.Parameters.AddWithValue("@Location", prmodel.Location);
cmd.Parameters.AddWithValue("@Roles", prmodel.Roles);
cmd.Parameters.AddWithValue("@EmployeeID", prmodel.EmployeeID);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("Index"));
}
public void SaveProject(ProjectDetailsModel pro)
{
try
{
string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
"Integrated Security=True";
SqlConnection mysqlconnection = new SqlConnection(connectionstring);
mysqlconnection.Open();
string COMMAND = "INSERT INTO PROJECTDETAILS(ProjectID,EmployeeID,ProjectName,ClientName,Location,Role)VALUES(" + pro.ProjectID + "," + "" + pro.EmployeeID + "," + "'" + pro.ProjectName + "'," + "'" + pro.ClientName + "'," + "'" + pro.Location + "'," + "'" + pro.Role + "')";
SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
cmd.ExecuteNonQuery();
mysqlconnection.Close();
}
finally
{
}
}
private void button5_Click(object sender, EventArgs e)
{
try
{
ProjectDetailsModel PDModel = new ProjectDetailsModel()
{
EmployeeID = Convert.ToInt32(EmployeeID1textbox.Text),
Project_Name = ProjectNametextbox.Text,
Client_Name = ClientNametextbox.Text,
Location = ProjectLocationtextbox.Text,
Roles = Roletextbox.Text,
};
ProjectDataAccess project = new ProjectDataAccess();
project.SaveProject(PDModel);
}
catch (Exception ex)
{
MessageBox.Show("Please enter the values:");
}
}
public ProjectDetailsModel GetProjectDetails(int employeeid)
{
ProjectDetailsModel prjdetails = new ProjectDetailsModel();
sqlConnection = OpenConnection();
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "uspGetProjectDetails";
sqlCommand.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = Convert.ToInt32(employeeid);
SqlDataReader projectdatareader = sqlCommand.ExecuteReader();
while (projectdatareader.Read())
{
prjdetails.EmployeeID = projectdatareader.GetInt32(projectdatareader.GetOrdinal("EmployeeID"));
prjdetails.Project_Name = projectdatareader.GetString(projectdatareader.GetOrdinal("Project_Name"));
prjdetails.Client_Name = projectdatareader.GetString(projectdatareader.GetOrdinal("Client_Name"));
prjdetails.Location = projectdatareader.GetString(projectdatareader.GetOrdinal("Location"));
prjdetails.Roles = projectdatareader.GetString(projectdatareader.GetOrdinal("Roles"));
}
CloseConncetion(sqlConnection);
return(prjdetails);
}
public IHttpActionResult GetProjectType()
{
RDSService.RDSService rdsService = new RDSService.RDSService();
DataSet ds = rdsService.SelectList("USP_GetProjectType");
ProjectDetailsModel pdm = new ProjectDetailsModel();
List <ProjectType> lstProjectType = new List <ProjectType>();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ProjectType pt = new ProjectType();
pt.ProjectName = dr[1].ToString();
pt.ProjectTypeId = Convert.ToInt32(dr[0].ToString());
lstProjectType.Add(pt);
}
// pdm.ProjectType = lstProjectType;
}
else
{
return(NotFound());
}
return(Ok(lstProjectType));
}
private void projectDetailsSaveButton_Click(object sender, EventArgs e)
{
try
{
ProjectDetailsModel projectDetailsobj = new ProjectDetailsModel
{
ProjectName = ProjectDetailsProjectNameTextBox.Text,
ClientName = ProjectDetailsProjectNameTextBox.Text,
Location = ProjectDetailsLocationTextBox.Text,
Roles = ProjectDetailsRolesTextBox.Text,
EmployeeId = Convert.ToInt32(ProjectDetailsEmployeeIdTextbox.Text)
};
EmployeeDataAccessLayer employeeDataAccessobj = new EmployeeDataAccessLayer();
long RowsAffected_projectDetails = employeeDataAccessobj.ProjectSqlConnection(projectDetailsobj);
}
catch (Exception exception)
{
MessageBox.Show("An Error has Occured, Please contact the Administrator!" + exception.Message);
}
finally
{
}
}
public IHttpActionResult GetScopeOfWork()
{
RDSService.RDSService rdsService = new RDSService.RDSService();
DataSet ds = rdsService.SelectList("USP_GetScopeOfWork");
ProjectDetailsModel pdm = new ProjectDetailsModel();
List <ScopeOfWork> lstSow = new List <ScopeOfWork>();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ScopeOfWork sow = new ScopeOfWork();
sow.ScopeOfWorkId = Convert.ToInt32(dr[0].ToString());
sow.ScopeOfWorkName = dr[1].ToString();
lstSow.Add(sow);
}
// pdm.ScopeOfWork = lstSow;
}
else
{
return(NotFound());
}
return(Ok(lstSow));
}
protected void ProjectDetailsEdit_Click(object sender, EventArgs e)
{
try
{
ProjectDetailsModel pmodel = new ProjectDetailsModel()
{
EmployeeID = Convert.ToInt32(EmployeeIDDropDownList.SelectedValue),
Project_Name = Project_NameTextBox.Text,
Client_Name = Client_NameTextBox.Text,
Location = LocationTextBox.Text,
Roles = RolesTextBox.Text,
};
ProjectDataAccess prdata = new ProjectDataAccess();
string pdata = prdata.EditProject(pmodel);
if (pdata.Equals("success"))
{
Response.Write("<script>alert('Details have been updated successfully!');</script>");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('Please enter the values!" + ex.Message + "');</script>");
}
}
public void CreateUpdate(ProjectDetailsModel model, HttpPostedFileBase fileUploaded, string path, bool isUpdate)
{
string operation = tbl + " Create Update ";
Logger.Log.Debug(operation + " Begin ");
var Project = new Project();
if (isUpdate)
{
Project = dbContext.Projects.SingleOrDefault(f => f.ID == model.ID);
if (Project == null)
{
throw new Exception("האדם לא קיים");
}
}
//mandatory
if (string.IsNullOrEmpty(model.Name))
{
throw new Exception("שם חובה");
}
Project.Name = model.Name;
//Project.Address = model.Address;
//Project.Address_Comments = HttpUtility.HtmlDecode(model.Address_Comments);
//Project.City = model.City;
//Project.Email = model.Email;
//Project.InMailingList = model.InMailingList;
//Project.MainPhone = model.MainPhone;
Project.Comments = HttpUtility.HtmlDecode(model.Project_Description);
//Project.Phones = model.Phones;
//Project.ZipCode = model.ZipCode;
try
{
if (!isUpdate)
{
dbContext.Projects.Add(Project);
}
if (fileUploaded != null && path != "" && fileUploaded.FileName != "")
{
Guid uniqfilename = Guid.NewGuid();
string oldFileName = fileUploaded.FileName;
string extension = System.IO.Path.GetExtension(oldFileName);
string newFileName = uniqfilename.ToString() + extension;
string fullFileName = System.IO.Path.Combine(path, newFileName);
fileUploaded.SaveAs(fullFileName);
//string newFileName = Hypnosis.Web.MyHelpers.FilesHelper.RelativePath+uniqfilename;
Project.ImageOriginalName = oldFileName;
Project.ImageName = newFileName;
}
dbContext.SaveChanges();
}
//dbContext.SaveChanges();
catch (DbEntityValidationException e)
{
string msgs = "";
foreach (var eve in e.EntityValidationErrors)
{
Logger.Log.ErrorFormat("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Logger.Log.ErrorFormat("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
msgs += ": " + ve.ErrorMessage;
}
}
throw new Exception("הייתה בעיה בשמירת הנתונים" + msgs);
}
catch (Exception ex)
{
string msg = "";
if (ex.InnerException != null)
{
var inner = ex.InnerException;
while (inner != null)
{
if (inner.InnerException != null)
{
inner = inner.InnerException;
}
else
{
break;
}
}
msg = inner.Message;
}
else
{
msg = ex.Message;
}
throw new Exception("הייתה בעיה בשמירת הנתונים: " + msg);
}
Logger.Log.Debug(operation + " End ");
}
