public List <Ticketinfo> SelectAllTicketinfo()
{
List <Ticketinfo> tlst = new List <Ticketinfo>();
Ticketinfo tf;
using (OTMDataContext db = new OTMDataContext())
{
var data = (from a in db.Tickets select a).ToList();
foreach (var obj in data)
{
tf = new Ticketinfo();
tf.TicketID = obj.TicketID;
tf.Description = obj.Description;
tf.CreatedDate = obj.CreatedDate;
tf.UpdatedDate = obj.UpdatedDate;
tf.TeamID = obj.TeamID;
tf.Status = obj.Status;
tf.Ticket_Severity = obj.Ticket_Severity;
tf.Expireddate = (DateTime)obj.ExpiredDate;
tf.Ticket_Estimated_Time = (int)obj.Ticket_Estimated_Time;
tlst.Add(tf);
}
}
return(tlst);
}
public List <AccountInfo> SelectAllAccountInfo()
{
List <AccountInfo> listaccinfo = new List <AccountInfo>();
AccountInfo accinfo;
using (OTMDataContext db = new OTMDataContext())
{
var data = (from a in db.Accounts select a).ToList();
foreach (var obj in data)
{
accinfo = new AccountInfo();
accinfo.Account_ID = obj.AccountID;
accinfo.Account_Status = obj.Accountstatus;
accinfo.Credit = obj.Credit;
accinfo.DOB = obj.DOB;
accinfo.Email = obj.Email;
accinfo.NRC = obj.NRC;
accinfo.User_Name = obj.UserName;
accinfo.Password = obj.Password;
accinfo.Phone_Number = obj.PhoneNumber;
accinfo.Created_Date = obj.CreatedDate;
accinfo.Edited_Date = obj.UpdatedDate;
listaccinfo.Add(accinfo);
}
}
return(listaccinfo);
}
public string selectByTeamID(string TeamID)
{
using (OTMDataContext db = new OTMDataContext())
{
var ID = (from a in db.Teams where a.TeamID == TeamID select a).FirstOrDefault();
return(ID.TeamID);
}
}
public string selectByAccountID(string ID)
{
using (OTMDataContext db = new OTMDataContext())
{
var source = (from a in db.Accounts where a.AccountID == ID select a).FirstOrDefault();
return(source.AccountID);
}
}
public string selectByClosedTicketID(string ClosedTID)
{
using (OTMDataContext db = new OTMDataContext())
{
var ID = (from a in db.ClosedTickets where a.ClosedTicketID == ClosedTID select a).FirstOrDefault();
return(ID.ClosedTicketID);
}
}
public void DeleteByTicketID(string TicketID)
{
using (OTMDataContext db = new OTMDataContext())
{
var data = (from a in db.Tickets where a.TicketID == TicketID select a).FirstOrDefault();
db.Tickets.DeleteOnSubmit(data);
db.SubmitChanges();
}
}
public void DeleteByMemberID(string MemberID)
{
using (OTMDataContext db = new OTMDataContext())
{
var data = (from a in db.Members where a.MemberID == MemberID select a).FirstOrDefault();
db.Members.DeleteOnSubmit(data);
db.SubmitChanges();
}
}
public bool updateTicketinfobyId(string ID, Ticketinfo info)
{
using (OTMDataContext db = new OTMDataContext())
{
var source = (from a in db.Tickets where a.TicketID == ID select a).FirstOrDefault();
source.Status = info.Status;
db.SubmitChanges();
return(true);
}
}
public SeverityInfo selectBySeverityID(int SeverityID)
{
using (OTMDataContext db = new OTMDataContext())
{
var ID = (from a in db.Severities where a.SeverityID == SeverityID select a).FirstOrDefault();
SeverityInfo sinfo = new SeverityInfo();
sinfo.SeverityID = ID.SeverityID;
sinfo.SeverityLevel = ID.SeverityLevel;
return(sinfo);
}
}
public bool UpdateByTeamID(string ID, TeamInfo Tinfo)
{
using (OTMDataContext db = new OTMDataContext())
{
var source = (from a in db.Teams where a.TeamID == ID select a).FirstOrDefault();
source.TeamDescription = Tinfo.TeamDescription;
source.CreatedDate = DateTime.UtcNow.AddMinutes(390);
source.UpdatedDate = DateTime.UtcNow.AddMinutes(390);
db.SubmitChanges();
return(true);
}
}
public bool DeleteByAccountID(string ID)
{
using (OTMDataContext db = new OTMDataContext())
{
var source = (from a in db.Accounts where a.AccountID == ID select a).FirstOrDefault();
if (source != null)
{
db.Accounts.DeleteOnSubmit(source);
db.SubmitChanges();
}
return(true);
}
}
public Member_Info selectByMemberID(string MemberID)
{
using (OTMDataContext db = new OTMDataContext())
{
var ID = (from a in db.Members where a.MemberID == MemberID select a).FirstOrDefault();
Member_Info minfo = new Member_Info();
minfo.TeamID = ID.TeamID;
minfo.MemberNumber = ID.MemberNumber;
minfo.CreatedDate = ID.CreatedDate;
minfo.UpdatedDate = ID.UpdatedDate;
return(minfo);
}
}
public void InsertToTeam(TeamInfo Tinfo)
{
using (OTMDataContext db = new OTMDataContext())
{
Team Teamtbl = new Team();
Guid ID = Guid.NewGuid();
Teamtbl.TeamID = ID.ToString();
Teamtbl.TeamDescription = Tinfo.TeamDescription;
Teamtbl.CreatedDate = DateTime.UtcNow.AddMinutes(390);
Teamtbl.UpdatedDate = DateTime.UtcNow.AddMinutes(390);
db.Teams.InsertOnSubmit(Teamtbl);
db.SubmitChanges();
}
}
public void MemberInsert(Member_Info minfo)
{
Member m;
using (OTMDataContext db = new OTMDataContext())
{
m = new Member();
Guid ID = Guid.NewGuid();
m.MemberID = ID.ToString();
m.TeamID = minfo.TeamID;
m.MemberNumber = minfo.MemberNumber;
m.CreatedDate = minfo.CreatedDate;
m.UpdatedDate = minfo.UpdatedDate;
db.Members.InsertOnSubmit(m);
db.SubmitChanges();
}
}
public void InserttoUsertbl(UserInfo Uinfo)
{
using (OTMDataContext db = new OTMDataContext())
{
User Usertbl = new User();
Guid ID = Guid.NewGuid();
Usertbl.UserID = ID.ToString();
Usertbl.UserName = Uinfo.UserName;
Usertbl.Password = Uinfo.Password;
Usertbl.UserType = 1;
Usertbl.CreatedDate = DateTime.UtcNow.AddMinutes(390);
Usertbl.UpdatedDate = DateTime.UtcNow.AddMinutes(390);
db.Users.InsertOnSubmit(Usertbl);
db.SubmitChanges();
}
}
public void insertto(Ticketinfo tinfo)
{
using (OTMDataContext db = new OTMDataContext())
{
Ticket ti = new Ticket();
Guid id = Guid.NewGuid();
ti.TicketID = id.ToString();
ti.TeamID = id.ToString();
ti.Description = tinfo.Description;
ti.Status = tinfo.Status;
ti.CreatedDate = DateTime.UtcNow.AddMinutes(390);
ti.UpdatedDate = DateTime.UtcNow.AddMinutes(390);
ti.ExpiredDate = DateTime.UtcNow.AddMinutes(390);
db.Tickets.InsertOnSubmit(ti);
db.SubmitChanges();
}
}
public void ClosedTicketInsert(ClosedTicketInfo cinfo)
{
ClosedTicket closed;
using (OTMDataContext db = new OTMDataContext())
{
closed = new ClosedTicket();
Guid ID = Guid.NewGuid();
closed.ClosedTicketID = ID.ToString();
closed.TicketID = ID.ToString();
closed.Solution = cinfo.Solution;
closed.CreatedDate = cinfo.CreatedDate;
closed.UpdatedDate = cinfo.UpdatedDate;
db.ClosedTickets.InsertOnSubmit(closed);
db.SubmitChanges();
}
}
public List <SeverityInfo> SelectAllSeverityInfo()
{
List <SeverityInfo> slist = new List <SeverityInfo>();
SeverityInfo sinfo;
using (OTMDataContext db = new OTMDataContext())
{
var source = (from a in db.Severities select a).ToList();
foreach (var obj in source)
{
sinfo = new SeverityInfo();
sinfo.SeverityID = obj.SeverityID;
sinfo.SeverityLevel = obj.SeverityLevel;
slist.Add(sinfo);
}
}
return(slist);
}
public List <TeamInfo> SelectAllTeamInfo()
{
List <TeamInfo> tlist = new List <TeamInfo> ();
TeamInfo tinfo;
using (OTMDataContext db = new OTMDataContext())
{
var source = (from a in db.Teams select a).ToList();
foreach (var obj in source)
{
tinfo = new TeamInfo();
tinfo.TeamID = obj.TeamID;
tinfo.TeamDescription = obj.TeamDescription;
tinfo.CreatedDate = obj.CreatedDate;
tinfo.UpdatedDate = obj.UpdatedDate;
tlist.Add(tinfo);
}
}
return(tlist);
}
public bool UpdateByAccountID(string ID, AccountInfo ainfo)
{
using (OTMDataContext db = new OTMDataContext())
{
var source = (from a in db.Accounts where a.AccountID == ID select a).FirstOrDefault();
source.Email = ainfo.Email;
source.Accountstatus = true;
source.UserName = ainfo.User_Name;
source.Password = ainfo.Password;
source.Credit = ainfo.Credit;
source.NRC = ainfo.NRC;
source.PhoneNumber = ainfo.Phone_Number;
source.DOB = ainfo.DOB;
source.CreatedDate = DateTime.UtcNow.AddMinutes(390);
source.UpdatedDate = DateTime.UtcNow.AddMinutes(390);
db.SubmitChanges();
return(true);
}
}
public void InserttoAccount(AccountInfo ainfo)
{
using (OTMDataContext db = new OTMDataContext())
{
Account Acctbl = new Account();
Guid ID = Guid.NewGuid();
Acctbl.AccountID = ID.ToString();
Acctbl.Accountstatus = true;
Acctbl.Email = ainfo.Email;
Acctbl.UserName = ainfo.User_Name;
Acctbl.Password = ainfo.Password;
Acctbl.Credit = ainfo.Credit;
Acctbl.NRC = ainfo.NRC;
Acctbl.PhoneNumber = ainfo.Phone_Number;
Acctbl.DOB = ainfo.DOB;
Acctbl.CreatedDate = DateTime.UtcNow.AddMinutes(390);
Acctbl.UpdatedDate = DateTime.UtcNow.AddMinutes(390);
db.Accounts.InsertOnSubmit(Acctbl);
db.SubmitChanges();
}
}
public List <ClosedTicketInfo> SelectAllClosedTicketInfo()
{
List <ClosedTicketInfo> lstclosedinfo = new List <ClosedTicketInfo>();
ClosedTicketInfo closedinfo;
using (OTMDataContext db = new OTMDataContext())
{
var data = (from a in db.ClosedTickets select a).ToList();// db.GETALLClosedTicket(); lamda expression
foreach (var obj in data)
{
closedinfo = new ClosedTicketInfo();
closedinfo.ClosedTicketID = obj.ClosedTicketID;
closedinfo.TicketID = obj.TicketID;
closedinfo.Solution = obj.Solution;
closedinfo.CreatedDate = obj.CreatedDate;
closedinfo.UpdatedDate = obj.UpdatedDate;
lstclosedinfo.Add(closedinfo);
}
return(lstclosedinfo);
}
}
public List <UserInfo> SelectAllUserInfo()
{
List <UserInfo> lstUserInfo = new List <UserInfo>();
UserInfo userinfo;
using (OTMDataContext db = new OTMDataContext())
{
var data = (from a in db.Users select a).ToList();
foreach (var obj in data)
{
userinfo = new UserInfo();
userinfo.UserID = obj.UserID;
userinfo.UserName = obj.UserName;
userinfo.UserType = obj.UserType;
userinfo.CreatedDate = obj.CreatedDate;
userinfo.UpdatedDate = obj.UpdatedDate;
lstUserInfo.Add(userinfo);
}
}
return(lstUserInfo);
}
public List <Member_Info> SelectAllMember_Info()
{
List <Member_Info> Mlist = new List <Member_Info>();
Member_Info Minfo;
using (OTMDataContext db = new OTMDataContext())
{
var data = (from a in db.Members select a).ToList();
foreach (var obj in data)
{
Minfo = new Member_Info();
Minfo.MemberID = obj.MemberID;
Minfo.TeamID = obj.TeamID;
Minfo.MemberNumber = obj.MemberNumber;
Minfo.CreatedDate = obj.CreatedDate;
Minfo.UpdatedDate = obj.UpdatedDate;
Mlist.Add(Minfo);
}
}
return(Mlist);
}
