public string AddAssociate(Cog.MLIAD.BusinessLogic.Associate.Associate associate) { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { try { int retasct = 0; retasct = asscon.Add_Associate(associate.AssociateID, associate.FirstName, associate.LastName, associate.Mobile, associate.email, associate.DirectReportID, associate.IsApproved, associate.ProjectID, associate.LocationID, associate.DesignationID, associate.DOJ, associate.DOB, associate.IsActive, associate.UserID, associate.Password, associate.GroupID); if (!(retasct == 0)) { BusinessLogic.Associate.Associate approver = (from a in asscon.get_AdminByGroup(associate.GroupID) select new Cog.MLIAD.BusinessLogic.Associate.Associate() { AssociateID = a.AssociateID, FirstName = (a.FirstName == null) ? "" : a.FirstName, LastName = (a.LastName == null) ? "" : a.LastName, Mobile = (a.Mobile == null) ? "" : a.Mobile, email = (a.email == null) ? "" : a.email, UserID = (a.UserId == null) ? "" : a.UserId }).SingleOrDefault<Cog.MLIAD.BusinessLogic.Associate.Associate>(); string sendSubject = "Pending Request"; string mailbody = "<html><body>Dear " + approver.FirstName + ",<br /> You have pending request to approve for " + associate.FirstName + " " + associate.LastName + ".<br / >Please login to www.AssociateConnect.com to approve the request.<br / ><br />Regards,<br />AssociateConnect Admin Team<body><html>"; SendEmail(sendSubject, mailbody, associate.email, approver.email,true); sendSubject = "Request Summited"; mailbody = "<html><body>Dear " + associate.FirstName + ",<br /> your request is successfully submitted to" + approver.FirstName + " " + approver.LastName + " for approval.<br / >You will get confirmation mail once your request gets appreved.<br / ><br />Regards,<br />AssociateConnect Admin Team<body><html>"; SendEmail(sendSubject, mailbody, approver.email, associate.email,true); BusinessLogic.Associate.SMS sms = new SMS(); sms.smsBody = "You have pending request to approve for " + associate.FirstName + " " + associate.LastName + "."; sms.toList = approver.Mobile; SendSMS(sms); sms.smsBody = "your request is successfully submitted to" + approver.FirstName + " " + approver.LastName + " for approval."; sms.toList = associate.Mobile; SendSMS(sms); return "success"; } else return "failure"; } catch (Exception ex) { throw ex; } } }
public string AddAddress(Associate.Address address, string AssociateID) { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { try { int retadd = 0; int AssoID = Convert.ToInt32(AssociateID); retadd = asscon.Add_Address(AssoID, address.AddressTypeID, address.Address1, address.Address2, address.Address3, address.City, address.State, address.Country, address.Zip); if (!(retadd == 0)) return "success"; else return "failure"; } catch (Exception ex) { throw ex; } } }
public List<Associate.Discussion> GetTopics(int CategoryID, int groupID) { try { using (AssociateConnDataContext asso = new AssociateConnDataContext()) { var discussions = (from d in asso.Get_Topics(CategoryID, groupID) orderby d.PostDateTime descending where d.IsParent == true select new Associate.Discussion { TopicDesc = d.TopicDesc, TopicHeader = d.topicheader, TopicID = d.TopicID, PostDateTime = d.PostDateTime, IsParent = d.IsParent, CreatedBy = d.CreatedBy, CreatedByname=d.FirstName + " " + d.LastName , CommentCount = d.CommentCount, Category = new Category { CategoryID = d.CategoryID, IsActive = d.IsActive, CategoryDesc = d.CategoryDesc }, Group = new Group { GroupID = d.GroupID, GroupDesc = d.GroupDesc }, }); List<Associate.Discussion> diss = new List<Associate.Discussion>(discussions); return diss; } } catch (Exception ex) { throw ex; } }
public string AddCategory(Cog.MLIAD.BusinessLogic.Associate.Category category) { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { try { int retasct = 0; retasct = asscon.Add_Category(category.CategoryDesc, category.IsActive); if (!(retasct == 0)) return "success"; else return "failure"; } catch (Exception ex) { throw ex; } } }
public List<Associate.SoftwareVersion> GetSoftwareVersion(int softResourceID) { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var resources = (from a in asscon.Get_SoftwareVersion(softResourceID) select new Associate.SoftwareVersion() { SoftwareVersionID = a.SoftVersionID, SoftwareVersionDesc = a.SoftVersionDesc }).ToList<Associate.SoftwareVersion>(); return resources; } }
public List<Associate.SoftwareCategory> GetSoftwareCategory() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var categories = (from a in asscon.Get_SoftwareCategory() select new Associate.SoftwareCategory() { SoftwareCategoryID = a.SoftCategoryID, SoftwareCategoryDesc = a.SoftCategoryDesc }).ToList<Associate.SoftwareCategory>(); return categories; } }
public List<Associate.Project> GetProject() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var projects = (from a in asscon.Get_Project() select new Associate.Project() { ProjectID = a.ProjectID, ProjectName = a.ProjectName }).ToList<Associate.Project>(); return projects; } }
public List<Associate.PhoneType> GetPhoneType() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var types = (from a in asscon.Get_PhoneType() select new Associate.PhoneType() { PhoneTypeID = Convert.ToInt32(a.PhoneTypeID), PhoneTypeDesc = a.PhoneType }).ToList<Associate.PhoneType>(); return types; } }
public List<Associate.Associate> GetApprovalRequest() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var ids = (from a in asscon.Get_ApprovalRequest() select new Associate.Associate() { AssociateID = a.AssociateID }).ToList<Associate.Associate>(); return ids; } }
public List<SMSAccount> GetAllAccounts() { List<SMSAccount> acc = new List<SMSAccount>(); using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var associate = (from a in asscon.sp_SMSAccounts("SELECT",null,null,null,null,null) select new SMSAccount() { id=a.Id, password=a.Password, phoneNumber=a.Phone, sentSMS=a.SentSMS, email=a.Email }).ToList<SMSAccount>(); acc = associate; return acc; } }
public List<Associate.AddressType> GetAddressType() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var types = (from a in asscon.Get_AddressType() select new Associate.AddressType() { AddressTypeID = a.AddressTypeID, AddressTypeDesc = a.AddressType }).ToList<Associate.AddressType>(); return types; } }
public List<Associate.Account> GetAccount(int PracticeID) { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var accounts = (from a in asscon.Get_Account(PracticeID) select new Associate.Account() { AccountID = a.AccountID, AccountName = a.AccountName }).ToList<Associate.Account>(); return accounts; } }
public Associate.Associate ForgotPassword(string userid, int associateid, string name) { try { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var Associate = (from a in asscon.GetUserPWD(userid, associateid, name) select new Associate.Associate() { email = a.email, Mobile = a.Mobile, Password = a.Password, }).SingleOrDefault(); return Associate; } } catch (Exception e) { throw e; } }
public string EditSoftware(Associate.SoftwareRequest software) { int SoftRequestID = Convert.ToInt32(software.id); int SoftCategoryID = Convert.ToInt32(software.SoftCategory); int SoftResourceID = Convert.ToInt32(software.SoftResource); int SoftVersionID = Convert.ToInt32(software.SoftVersion); int ProjectID = Convert.ToInt32(software.ProjectName); using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { try { int retval = asscon.Edit_Software(SoftRequestID, SoftResourceID, SoftCategoryID, SoftVersionID, ProjectID); if (retval == 1) return "sucess"; else return "failure"; } catch (Exception ex) { throw ex; } } }
public string EditFirewall(Associate.FirewallRequest firewall) { int RequestedID = Convert.ToInt32(firewall.id); int ProjectID = Convert.ToInt32(firewall.ProjectName); using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { try { int retval = asscon.Edit_Firewall(RequestedID, firewall.FirewallRequestDesc, firewall.Destination, firewall.Source, firewall.Port, ProjectID); if (retval == 1) return "sucess"; else return "failure"; } catch (Exception ex) { throw ex; } } }
public List<Associate.Group> GetGroupsByUser(int uid) { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var groups = (from a in asscon.Get_GroupByID(uid) select new Associate.Group() { GroupID = a.GroupID, GroupDesc = a.GroupName }).ToList<Associate.Group>(); return groups; } }
public List<Associate.Location> GetLocation() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var locations = (from a in asscon.Get_Location() select new Associate.Location() { LocationID = a.LocationID, LocationName = a.Location }).ToList<Associate.Location>(); return locations; } }
public Associate.Associate GetAssociate(string userid) { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var associate = (from a in asscon.Associates where a.UserId == userid select new Associate.Associate() { AssociateID = a.AssociateID , DesignationID = a.DesignationID , DirectReportID =a.DirectReportID , DOB =a.DOB , DOJ =a.DOJ , email =a.email , FirstName =a.FirstName , LastName =a.LastName , LocationID =a.LocationID , Mobile =a.Mobile }).SingleOrDefault<Associate.Associate>(); return associate; } }
public List<Associate.Practice> GetPractice() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var practices = (from a in asscon.Get_Practice() select new Associate.Practice() { PracticeID = a.PracticeID, PracticeName = a.PracticeName }).ToList<Associate.Practice>(); return practices; } }
public Associate.Associate GetAssociateByID(string AssociateID) { int id = (AssociateID == string.Empty) ? 0 : Convert.ToInt32(AssociateID); using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var associates = (from a in asscon.Get_AssociateByID(id) select new Associate.Associate() { AssociateID = a.AssociateID, FirstName = a.FirstName, LastName = a.LastName, Designation = a.Designation, Practice = a.PracticeName, Account = a.AccountName, Location = a.Location, email = a.email, Mobile = a.Mobile, DOJ = a.DOJ, ProjectName = a.ProjectName, Gender = a.Gender }).SingleOrDefault<Associate.Associate>(); return associates; } }
public List<Associate.Role> GetRole() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var roles = (from a in asscon.Get_Role() select new Associate.Role() { RoleID = a.RoleID, RoleDesc = a.RoleDesc }).ToList<Associate.Role>(); return roles; } }
public BusinessLogic.Associate.Associate GetAssociatesByUserID(string UserID) { try { using (AssociateConnDataContext asso = new AssociateConnDataContext()) { var associate = (from d in asso.Get_AssociateByUserID(UserID) select new Associate.Associate { AssociateID = d.AssociateID, FirstName = d.FirstName, LastName = d.LastName }).SingleOrDefault<Associate.Associate>(); return associate; } } catch (Exception ex) { throw ex; } }
public List<Associate.SoftwareResource> GetSoftwareResource(int softCategoryID) { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var resources = (from a in asscon.Get_SoftwareResource(softCategoryID) select new Associate.SoftwareResource() { SoftwareResourceID = a.SoftResourceID, SoftwareResourceDesc = a.SoftResourceDesc }).ToList<Associate.SoftwareResource>(); return resources; } }
public List<BusinessLogic.Associate.Associate> GetAssociatesPerGroup(int groupid) { try { using (AssociateConnDataContext asso = new AssociateConnDataContext()) { var assoList = (from d in asso.Get_AssoListPerGroup(groupid) select new Associate.Associate { AssociateID = d.AssociateID, FirstName = d.FirstName, LastName = d.LastName, email = d.email, Mobile = d.Mobile }).ToList<Associate.Associate>(); return assoList; } } catch (Exception ex) { throw ex; } }
public Associate.Discussion GetTopic(int topicID) { try { using (AssociateConnDataContext asso = new AssociateConnDataContext()) { var discussion = (from d in asso.Get_Topic(topicID) orderby d.PostDateTime descending where d.TopicID == topicID select new Associate.Discussion { TopicDesc = d.TopicDesc, TopicHeader = d.topicheader, TopicID = d.TopicID, PostDateTime = d.PostDateTime, IsParent = d.IsParent, CreatedBy = d.CreatedBy, CreatedByname = d.FirstName + " " + d.LastName, CommentCount = d.CommentCount, Category = new Category { CategoryID = d.CategoryID, CategoryDesc = d.CategoryDesc }, Group = new Group { GroupID = d.GroupID, GroupDesc = d.GroupDesc }, }).SingleOrDefault(); return discussion; } } catch (Exception ex) { throw ex; } }
public List<BusinessLogic.Associate.Associate> GetAssociatesPerGroupAndRole(int groupid, int roleid) { try { using (AssociateConnDataContext asso = new AssociateConnDataContext()) { var assoList = (from d in asso.GetMemberByGroupAndRole(groupid, roleid) select new Associate.Associate { AssociateID = d.AssociateID, FirstName = d.FirstName, LastName = d.LastName }).ToList<Associate.Associate>(); return assoList; } } catch (Exception ex) { throw ex; } }
public List<Associate.DiscussionDetails> GetTopicDetails(int topicID) { try { using (AssociateConnDataContext asso = new AssociateConnDataContext()) { var dissDetails = (from d in asso.Get_TopicDetails(topicID) orderby d.CreatedOn descending select new Associate.DiscussionDetails { TopicDetailID = d.DiscussionDetailID, DetailDesc = d.DetailDesc, CreatedOn = d.CreatedOn, CreatedBy = d.CreatedBy, CreatedByname = d.CreatedByName, ParentID = topicID, }).ToList<Associate.DiscussionDetails>(); return dissDetails; } } catch (Exception ex) { throw ex; } }
public List<Associate.Category> GetCategories() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var groups = (from a in asscon.Get_Category() select new Associate.Category() { CategoryID = a.CategoryID, CategoryDesc = a.CategoryDesc }).ToList<Associate.Category>(); return groups; } }
public Associate.Associate LoginUser(string userid, string pwd) { try { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var Associate = (from a in asscon.getAthenticateUser(userid, pwd) select new Associate.Associate() { AssociateID=a.AssociateID, //Designation = a.Designation, //DesignationID = a.DesignationID , //DirectReportID = a.DirectReportID, //DirectReporter = a.DirectReporter, //DOB = a.DOB, //DOJ = a.DOJ, email=a.email, Gender=a.Gender, //Location = a.Location, //LocationID = a.LocationID, Mobile = a.Mobile, Name=a.Name, //ProjectID=a.ProjectID.Value, //ProjectName=a.ProjectName, IsApproved=a.IsApproved }).SingleOrDefault(); Associate.groupList = (from b in asscon.getAssociateRoleGroup(userid) select new Associate.Group() { GroupDesc = b.GroupDesc, GroupName=b.GroupName, GroupID = b.GroupID.Value }).ToList<Associate.Group>(); Associate.Role = (from b in asscon.getAssociateRoleGroup(userid) select new Associate.Role() { RoleDesc = b.RoleDesc, RoleID = b.RoleID.Value }).FirstOrDefault(); if (Associate.groupList.Count > 0) { return Associate; } else { throw new Exception("No group available for the user"); //return null; } } } catch (Exception e) { throw e; } }
public List<Associate.Designation> GetDesignation() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var designations = (from a in asscon.Get_Designation() select new Associate.Designation() { DesignationID = a.DesignationID, DesignationName = a.Designation }).ToList<Associate.Designation>(); return designations; } }