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());
}
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"
},
};
}
