public ActionResult AssignedEmployees(FormCollection fc)
{
bool result = false;
try
{
var SelectedEmployees = fc["SelectedEmployees"].Split(',');
var ProjectID = Convert.ToInt32(fc["ProjectID"].ToString());
foreach (string employeeID in SelectedEmployees)
{
ProjectMemberAssisgnment model = new ProjectMemberAssisgnment();
model.ProjectId = ProjectID;
model.ProjectMemberId = Convert.ToInt32(employeeID);
result = objDB.SaveAssignedEmployees(model);
}
}
catch (Exception ex)
{
}
if (result)
{
return(Json("Project Category Saved"));
}
else
{
return(Json("Project Category Not Saved"));
}
}
public bool SaveAssignedEmployees(ProjectMemberAssisgnment memberAssisgnment)
{
bool result = false;
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DHRM_COREEntities"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("insert into [tblProjectMemberAssignment]([project_id],[project_member_id]) values(@ProjectID,@EmployeeID);", con);
if (con.State != ConnectionState.Open)
{
con.Open();
}
cmd.Parameters.Clear();
cmd.Parameters.Add("@ProjectID", SqlDbType.Int).Value = memberAssisgnment.ProjectId;
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = memberAssisgnment.ProjectMemberId;
cmd.ExecuteNonQuery();
result = true;
}
}
catch (Exception ex)
{
}
return(result);
}
