public static string getConsultantsData(Consultants info) { string config = Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]); List <Consultants> Consultants = new List <Consultants>(); SqlConnection con = new SqlConnection(config); con.Open(); using ( SqlCommand cmd = new SqlCommand("select * from Doctors_Data where Type = 'Consultant' and Spcy_id = @Spcy_id and Branch = @Branch_ID", con) ) { cmd.Parameters.Add("@Spcy_id", SqlDbType.Int).Value = info.Spcy_id; cmd.Parameters.Add("@Branch_ID", SqlDbType.Int).Value = info.Branch_ID; SqlDataReader idr = cmd.ExecuteReader(); if (idr.HasRows) { Consultants = populateConsultantsLisst(idr, con); } } con.Close(); return(JsonConvert.SerializeObject(Consultants)); }
public Consultant AddConsultant(string fullName, string designation, string linkedIn, string blog, string hackernews, string stackoverflow, string github) { var consultant = new Consultant(); consultant.Name = fullName; consultant.Designation = designation; consultant.LinkedinProfile = linkedIn; consultant.Picture = DEFAULT_IMAGES.PROFILE_PICTURE; consultant.TenantId = TenantId; Consultants.Add(consultant); if (!string.IsNullOrEmpty(blog)) { consultant.AddCredential(CREDENTIAL_TYPE.BLOG, blog); } if (!string.IsNullOrEmpty(hackernews)) { consultant.AddCredential(CREDENTIAL_TYPE.HACKERNEWS, hackernews); } if (!string.IsNullOrEmpty(stackoverflow)) { consultant.AddCredential(CREDENTIAL_TYPE.STACKOVERFLOW, stackoverflow); } if (!string.IsNullOrEmpty(github)) { consultant.AddCredential(CREDENTIAL_TYPE.GITHUB, github); } return(consultant); }
public bool DeleteConsultant(int id) { using (var dbContext = new SalesBogEntities()) { Consultants consultant = dbContext.Consultants.Find(id); dbContext.Consultants.Remove(consultant); return(dbContext.SaveChanges() > 0 ? true : false); } }
protected void SelectProjectMembers(int projectId) { Consultants.DataBind(); List <string> userList = Project.GetProjectMembers(projectId); foreach (string user in userList) { ListItem item = Consultants.Items.FindByValue(user); item.Selected = true; } }
public ActionResult NewConsultant(Consultants consultant) { var sho = (from shop in db.Shops select shop.ShopName).ToList(); var cons = (from con in db.Consultants select con.ConsultantSurname).ToList(); db.Consultants.Add(consultant); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Update(string city, string country, string description, string phone, string email, IEnumerable <long> tagIds, IEnumerable <string> tagNames, int?minimumRate, HttpPostedFileBase image, string consultantName = null) { //clear existing tags Tags.Clear(); City = city; Country = country; Description = description; Account.Phone = phone; Account.Email = email; var tags = EntityContext.CreateQuery <Tag>().Where(t => tagIds.Contains(t.Id)).ToList(); tags.ForEach(t => Tags.Add(t)); if (tagNames != null && tagNames.Count() > 0) { var existingTagNames = tags.Select(t => t.Name); var newTags = tagNames.Select(n => n.Trim()).Where(tn => !string.IsNullOrEmpty(tn) && !existingTagNames.Contains(tn)) .Distinct().Take(10).ToList(); if (newTags.Count() > 0) { newTags.ForEach(t => Tags.Add(Tag.Create(t, TenantId, EntityContext))); } } MinimumRate = minimumRate; Currency = CURRENCY.USD; SaveLogo(image); Name = consultantName; if (Type == COMPANY_TYPE.INDIVIDUAL) { if (!this.IsLoaded(c => c.Consultants)) { this.Load(this.EntityContext, c => c.Consultants); } Consultants.Single().Name = consultantName; } }
private void txtUserPassword_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { users.UserName = txtUserName.Text; users.UserPassword = txtUserPassword.Text; try { string where = string.Format("where UserName='******' and UserPassword='******'", users.UserName, users.UserPassword); DataTable dt = da.GetData <Users>(where); users.Id = Convert.ToInt32(dt.Rows[0][3].ToString()); if (dt.Rows[0][2].ToString().ToUpper() == "MANAGER") { Manager man = new Manager(home, users); man.Show(); home.Hide(); } if (dt.Rows[0][2].ToString().ToUpper() == "REPORTER") { Reporter rep = new Reporter(home, users); rep.Show(); home.Hide(); } if (dt.Rows[0][2].ToString().ToUpper() == "CONSULTANT") { Consultants con = new Consultants(home, users); con.Show(); home.Hide(); } if (dt.Rows[0][2].ToString().ToUpper() == "OWNER") { Owners owns = new Owners(home, users); owns.Show(); home.Hide(); } MessageBox.Show("Login Success"); } catch (Exception en) { MessageBox.Show("Login Failed"); } } }
public List <Consultants> GetMedicalConsultants(int medicalId) { Query = "SELECT Id, ConsultantName FROM MedicalConsultants WHERE MedicalId = @medicalId ORDER BY ConsultantName"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("medicalId", medicalId); Connection.Open(); Reader = Command.ExecuteReader(); List <Consultants> consultants = new List <Consultants>(); while (Reader.Read()) { Consultants consultant = new Consultants(); consultant.Id = Convert.ToInt32(Reader["Id"]); consultant.ConsultantName = Reader["ConsultantName"].ToString(); consultants.Add(consultant); } Reader.Close(); Connection.Close(); return(consultants); }
void Page_Load(object sender, EventArgs e) { GetCurrentProject(); if (!Page.IsPostBack) { ManagerData.SelectParameters.Add(new Parameter("roleName", TypeCode.String, "ProjectManager")); ProjectConsultantData.SelectParameters.Add(new Parameter("roleName", TypeCode.String, "Consultant")); if (CurrentProject != null) { ProjectName.Text = CurrentProject.Name; DateTime dt = Convert.ToDateTime(CurrentProject.CompletionDate); CompletionDate.Text = dt.ToString("d"); Duration.Text = Convert.ToString(CurrentProject.EstimateDuration); Description.Text = CurrentProject.Description; Managers.SelectedValue = CurrentProject.ManagerUserName; Consultants.DataBind(); ProjectCategoryColumn.Visible = true; } else { ProjectCategoryColumn.Visible = false; } if ((Page.User.IsInRole("ProjectAdministrator"))) { ProjectData.SelectMethod = "GetAllProjects"; } else { ProjectData.SelectParameters.Add(new Parameter("userName", TypeCode.String, Page.User.Identity.Name)); ProjectData.SelectMethod = "GetProjectsByManagerUserName"; ProjectData.SortParameterName = "sortParameter"; } } DeleteButton2.Attributes.Add("onclick", "return confirm('Deleting a project will also delete all the time entries and categories associated with the project. This deletion cannot be undone. Are you sure you want to delete this project?')"); }
public async Task GetConsultants() { if (initialized == true) { return; } IsBusy = true; IEnumerable <Consultant> consultants = await consultantService.Get(); // очищаем список //Consultations.Clear(); while (Consultants.Any()) { Consultants.RemoveAt(Consultants.Count - 1); } // добавляем загруженные данные foreach (Consultant c in consultants) { Consultants.Add(c); } IsBusy = false; initialized = true; }
static InMemoryConsultantsRepository() { _consultants = new Consultants { new Consultant { ID = 1, Name = "Dominick Baier", EmailAddress = "*****@*****.**", Country = "DE", Owner = "christian" }, new Consultant { ID = 2, Name = "Christian Weyer", EmailAddress = "*****@*****.**", Country = "DE", Owner = "christian" }, new Consultant { ID = 3, Name = "Ingo Rammer", EmailAddress = "*****@*****.**", Country = "Pampa", Owner = "christian" }, new Consultant { ID = 4, Name = "Richard Blewett", EmailAddress = "*****@*****.**", Country = "UK", Owner = "dominick" }, new Consultant { ID = 5, Name = "Oliver Sturm", EmailAddress = "*****@*****.**", Country = "UK", Owner = "dominick" }, new Consultant { ID = 6, Name = "Jörg Neumann", EmailAddress = "*****@*****.**", Country = "DE", Owner = "dominick" }, new Consultant { ID = 7, Name = "Christian Nagel", EmailAddress = "*****@*****.**", Country = "AT", Owner = "dominick" }, }; }
void before_each() { controller = new ConsultantsController(); consultants = new Consultants(); }
public void Import(Context context, string path) { //@"C:\Users\KSIUDA\Desktop\SQL\Training List.xlsx" Excel.Application xlApp = new Excel.Application(); Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(path); Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1]; Excel.Range xlRange = xlWorksheet.UsedRange; int rowCount = xlRange.Rows.Count; int colCount = xlRange.Columns.Count; var trainings = new List <Tuple <int, string> >(); var consultants = new List <Tuple <int, string> >(); var blanks = new List <int>(); for (int row = 3; row <= rowCount; row++) { string training = ""; string instructor = ""; string duration = ""; string type = ""; for (int column = 2; column < 8; column++) { if (column == 2) { if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null) { string value = xlRange.Cells[row, column].Value2.ToString(); if (value.ToUpper() != value) { training = value; } else if (value.ToUpper() == value && value.Length < 7) { training = value; } else { blanks.Add(row); } } } if (column == 3) { if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null) { string value = xlRange.Cells[row, column].Value2.ToString(); if (value.ToUpper() != value) { type = value; } } } if (column == 6) { if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null) { string value = xlRange.Cells[row, column].Value2.ToString(); if (value.ToUpper() != value) { instructor = value; } } } if (column == 7) { if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null) { string value = xlRange.Cells[row, column].Value2.ToString(); duration = value; } } } if (instructor != "" || training != "") { if (instructor == "") { instructor = "None"; } if (duration == "") { duration = null; } Int32.TryParse(duration, out int dur); trainings.Add(Tuple.Create(trainings.Count() + 1, training)); var Training = new Trainings { Name = training, Type = type, Trainer = instructor, Duration = dur, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now }; context.Trainings.Add(Training); context.SaveChanges(); } } for (int row = 1; row <= 1; row++) { string consultant = ""; for (int column = 10; column <= colCount; column++) { string value = xlRange.Cells[row, column].Value2.ToString(); consultant = value; consultants.Add(Tuple.Create(consultants.Count() + 1, consultant)); var Consultant = new Consultants { Name = consultant, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now }; context.Consultants.Add(Consultant); context.SaveChanges(); } } foreach (var consultant in consultants) { int blank = 0; int id; for (int row = 3; row <= trainings.Count() + 2 + blanks.Count(); row++) { string trainingState = ""; int counter = row - 2; for (int column = 10 + consultant.Item1 - 1; column < 10 + consultant.Item1; column++) { if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null) { string value = xlRange.Cells[row, column].Value2.ToString(); trainingState = value; if (trainingState == "") { blank++; } else { id = counter - blank; var query = trainings.AsEnumerable(); var trainigname = from train in query where train.Item1 == id select train.Item2; string name = String.Join("", trainigname); var TrainingDetails = new TrainingDetails { TrainingName = name, ConsultantName = consultant.Item2, Status = trainingState, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now }; context.TrainingDetails.Add(TrainingDetails); context.SaveChanges(); } } else { blank++; } } } } }
public ConsultantsTest() { _consultants = new Consultants(new ConsultantsRepositoryDouble()); }