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