/// <summary>
/// This function returs the current tasks which are assigned to the user
/// </summary>
/// <param name="empID"> The employee ID of the user</param>
/// <returns></returns>
public IEnumerable <currenttasks> getTasks(int empID)
{
OfficeDeskDB db = new OfficeDeskDB();
var CD = db;
var CT = from currenttasks in db.currenttaskss
where currenttasks.empId == empID
select currenttasks;
return(CT);
}
public string getClientName(int client_id)
{
string client_name = "";
OfficeDeskDB db = new OfficeDeskDB();
var client = from clients in db.clientss
where clients.ID == client_id
select clients;
if (client.Count() != 0)
{
foreach (clients c in client)
{
client_name = c.name;
}
}
return(client_name);
}
public int determineUserID(string user_name)
{
int user_ID = 0;
OfficeDeskDB db = new OfficeDeskDB();
var user = from users in db.userss
where users.user_name == user_name
select users;
if (user.Count() == 1)
{
foreach (users u in user)
{
user_ID = u.ID;
}
}
return(user_ID);
}
public void updateClient(clients clnt)
{
OfficeDeskDB db = new OfficeDeskDB();
var client = from clients in db.clientss
where clients.ID == clnt.ID
select clients;
if (client.Count() > 0)
{
foreach (clients c in client)
{
c.name = clnt.name;
c.pan_no = clnt.pan_no;
c.email = clnt.email;
c.contact_no = clnt.contact_no;
c.address = clnt.address;
c.bank_accountNo = clnt.bank_accountNo;
c.accountType = clnt.accountType;
c.aadhar_no = clnt.aadhar_no;
c.aadharLinkStatus = clnt.aadharLinkStatus;
c.group_id = clnt.group_id;
c.gstin = clnt.gstin;
}
db.SaveChanges();
db.Dispose();
}
else
{
var client_new = new clients();
client_new.name = clnt.name;
client_new.pan_no = clnt.pan_no;
client_new.email = clnt.email;
client_new.contact_no = clnt.contact_no;
client_new.address = clnt.address;
client_new.bank_accountNo = clnt.bank_accountNo;
client_new.accountType = clnt.accountType;
client_new.aadhar_no = clnt.aadhar_no;
client_new.aadharLinkStatus = clnt.aadharLinkStatus;
client_new.group_id = clnt.group_id;
client_new.gstin = clnt.gstin;
db.clientss.Add(client_new);
db.SaveChanges();
db.Dispose();
}
}
public string getGroup(int groupID)
{
string groupName = "";
OfficeDeskDB db = new OfficeDeskDB();
var group = from groups in db.groupss
where groups.ID == groupID
select groups;
if (group.Count() > 0)
{
foreach (groups g in group)
{
groupName = g.group_name;
}
}
return(groupName);
}
/// <summary>
/// method to update existing as well as new tasks.
/// </summary>
/// <param name="empID">employee id of user</param>
public void updateTasks(currenttasks task)
{
OfficeDeskDB db = new OfficeDeskDB();
var CD = db;
var CT = from currenttaskss in db.currenttaskss
where currenttaskss.ID == task.ID
select currenttaskss;
if (CT.Count() != 0)
{
foreach (currenttasks ct in CT)
{
ct.DateOfAssignment = Convert.ToDateTime(task.DateOfAssignment);
ct.SubjectWithParty = task.SubjectWithParty;
ct.assignee = task.assignee;
ct.priority = task.priority;
ct.TaskDescription = task.TaskDescription;
ct.DocumentsSource = task.TaskDescription;
ct.assigner = task.assigner;
ct.status = task.status;
ct.remarks = task.remarks;
ct.ClientID = task.ClientID;
db.SaveChanges();
db.Dispose();
}
}
else
{
currenttasks ct = new currenttasks();
ct.DateOfAssignment = Convert.ToDateTime(task.DateOfAssignment);
ct.ClientID = task.ClientID;
ct.SubjectWithParty = task.SubjectWithParty;
ct.empId = task.empId;
ct.areaOfWork = task.areaOfWork;
ct.priority = task.priority;
ct.TaskDescription = task.TaskDescription;
ct.DocumentsSource = task.DocumentsSource;
ct.assignee = task.assignee;
ct.assigner = task.assigner;
ct.status = task.status;
ct.remarks = task.remarks;
db.currenttaskss.Add(ct);
db.SaveChanges();
db.Dispose();
}
}
public bool check_user(string user_name, string user_password)
{
bool result;
OfficeDeskDB db = new OfficeDeskDB();
var user = from users in db.userss
where users.user_name == user_name && users.password == user_password
select users;
if (user.Count() > 0)
{
foreach (users u in user)
{
GlobalVar.app_userID = u.ID;
}
result = true;
}
else
{
result = false;
}
return(result);
}
