public void AssignProjectToClient(ClientProjectViewModel assignProject) { //var getClient = (from user in _db.Clients // join clientproject in _db.ClientProject on user.ClientID equals clientproject.ClientID // where user.ClientID == assignProject.ClientID // select user.ClientID).FirstOrDefault(); foreach (var x in assignProject.ProjectID) { var getClientProject = (from clientproject in _db.ClientProject //join client in _db.Clients on clientproject.ClientID equals client.ClientID //join project in _db.Projects on clientproject.ProjectID equals project.ProjectID where clientproject.ClientID == assignProject.ClientID && clientproject.ProjectID == x select clientproject).Any(); if (getClientProject == false) { var projectAssign = new ClientProject { ClientID = assignProject.ClientID, ProjectID = x }; _db.ClientProject.Add(projectAssign); } _db.SaveChanges(); } }
public void PostClient(ClientProjectViewModel client) { try { var getContact = _db.Clients.Where(x => x.ClientContactNumber == client.ClientContactNumber && x.ClientFirstName == client.ClientFirstName && x.ClientLastName == client.ClientLastName); if (getContact.Count() == 0) { var clientDetail = new Clients { ClientFirstName = client.ClientFirstName, ClientLastName = client.ClientLastName, ClientContactNumber = client.ClientContactNumber, ClientOffice = client.ClientOffice, OfficeAddress = client.OfficeAddress }; _db.Clients.Add(clientDetail); _db.SaveChanges(); //foreach (var x in client.ProjectID) //{ // var clientProject = new ClientProject // { // //ClientID = clientDetail.ClientID, // Clients=clientDetail, // ProjectID = x // }; // _db.ClientProject.Add(clientProject); //} //_db.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> PostClients([FromBody] ClientProjectViewModel clients) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _client.PostClient(clients); return(CreatedAtAction("GetClients", new { id = clients.ClientID }, clients)); }
public async Task <IActionResult> AssignProjectToClient([FromBody] ClientProjectViewModel clients) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _client.AssignProjectToClient(clients); return(Ok()); }
public async Task <IActionResult> PostProjects([FromBody] ClientProjectViewModel projects) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _project.PostProject(projects); return(CreatedAtAction("GetProjects", new { id = projects.ProjectID }, projects)); }
public void UpdateClientProject(ClientProjectViewModel client) { using (IDbConnection db = new SqlConnection(_connectionString)) { var parameter = new DynamicParameters(); parameter.Add("@ClientID", client.ClientID); parameter.Add("@ClientProjectID", client.ClientProjectID); parameter.Add("@ProjectID", client.ProjectID); db.Execute("UpdateClientProject", parameter, commandType: CommandType.StoredProcedure); } }
public void PostClient(ClientProjectViewModel client) { try { //using (IDbConnection db = new SqlConnection(_connectionString)) //{ // var parameter = new DynamicParameters(); // foreach (var items in client.ProjectID) // { // parameter.Add("@ProjectID", items); // } // parameter.Add("@ClientFirstName", client.ClientFirstName); // parameter.Add("@ClientLastName", client.ClientLastName); // parameter.Add("@ClientOffice", client.ClientOffice); // parameter.Add("@OfficeAddress", client.OfficeAddress); // parameter.Add("@ClientContactNumber", client.ClientContactNumber); // db.Execute("InsertIntoClientProjects", parameter, commandType: CommandType.StoredProcedure); //_db.Clients.Add(client.ClientID, client.ClientFirstName, client.ClientLastName, client.ClientOffice, client.ClientContactNumber); var getContact = _db.Clients.Where(x => x.ClientContactNumber == client.ClientContactNumber && x.ClientFirstName == client.ClientFirstName && x.ClientLastName == client.ClientLastName); if (getContact.Count() == 0) { var clientDetail = new Clients { ClientFirstName = client.ClientFirstName, ClientLastName = client.ClientLastName, ClientContactNumber = client.ClientContactNumber, ClientOffice = client.ClientOffice, OfficeAddress = client.OfficeAddress }; _db.Clients.Add(clientDetail); _db.SaveChanges(); foreach (var x in client.ProjectID) { var clientProject = new ClientProject { ClientID = clientDetail.ClientID, ProjectID = x }; _db.ClientProject.Add(clientProject); } _db.SaveChanges(); } else { message = "Cant enter data"; } } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> PutClients(int id, [FromBody] ClientProjectViewModel clients) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != clients.ClientID) { return(BadRequest()); } _client.PutClient(clients); return(Ok()); }
public async Task <IActionResult> PutProjects(int id, [FromBody] ClientProjectViewModel projects) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } //if (id != projects.ProjectID) //{ // return BadRequest(); //} _project.PutProject(projects); return(Ok()); }
public void PostProject(ClientProjectViewModel client) { using (IDbConnection db = new SqlConnection(_connectionString)) { try { var parameter = new DynamicParameters(); parameter.Add("@ProjectName", client.ProjectName); parameter.Add("@ProjectStartDate", Convert.ToDateTime(client.ProjectStartDate)); parameter.Add("@ProjectEndDate", Convert.ToDateTime(client.ProjectEndDate)); db.Execute("InsertIntoProject", parameter, commandType: CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } } }
public void PutClient(ClientProjectViewModel client) { try { using (IDbConnection db = new SqlConnection(_connectionString)) { var parameter = new DynamicParameters(); parameter.Add("@ClientFirstName", client.ClientFirstName); parameter.Add("@ClientLastName", client.ClientLastName); parameter.Add("@ClientOffice", client.ClientOffice); parameter.Add("@OfficeAddress", client.OfficeAddress); parameter.Add("@ClientContactNumber", client.ClientContactNumber); parameter.Add("@ClientID", client.ClientID); db.Execute("UpdateClient", parameter, commandType: CommandType.StoredProcedure); } } catch (Exception ex) { throw ex; } }