private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
int rowindex = dataGridView1.CurrentRow.Index;
ID = int.Parse(dataGridView1.Rows[rowindex].Cells[0].Value.ToString());
currentobj = currentobj.GetByID(ID);
push();
}
public static Entities.Company CompanyEntities(DAL.Company r)
{
return(new Entities.Company()
{
CompanyAreaId = r.CompanyAreaId,
CompanyCityId = r.CompanyCityId,
CompanyId = r.CompanyId,
CompanyMail = r.CompanyMail,
CompanyName = r.CompanyName,
CompanyNumBuild = r.CompanyNumBuild,
CompanyStreet = r.CompanyStreet,
CompanyTel = r.CompanyTel,
});
}
public static DTO.CompanyDto ConvertDALtoDTO(DAL.Company company)
{
if (company == null)
{
return(null);
}
return(new DTO.CompanyDto()
{
CompanyId = company.CompanyId,
CompanyName = company.CompanyName,
Address = company.Address,
Mail = company.Mail,
Publishes = company.Publishes != null?DTO.converters.ConvertPublish.ConvertListDALtoDTO(company.Publishes.ToList()) : null
});
}
public static List <JobView> JobView(List <Job> job)
{
try
{
using (DAL.IdialEntities3 dbn = new DAL.IdialEntities3())
{
//new connection to the database
dbn.Database.Connection.Open();
String diff2 = "";
List <Entities.JobView> jv = new List <JobView>();
DateTime temp;
foreach (var item in job)
{
DAL.Workspace w = dbn.Workspace.FirstOrDefault(p1 => p1.WSId == item.JobWorkspaceId);
DAL.SubjectJob s = dbn.SubjectJob.FirstOrDefault(p1 => p1.SubId == item.JobSubId);
DAL.OutNet outNet = dbn.OutNet.FirstOrDefault(o => o.OutNetId == item.JobPartOutNetId);
DAL.Company company = dbn.Company.FirstOrDefault(q => q.CompanyId == item.JobCompanyId);
DAL.City city = dbn.City.FirstOrDefault(c => c.CityId == company.CompanyCityId);
DAL.Area area = dbn.Area.FirstOrDefault(a => a.AreaId == company.CompanyAreaId);
DAL.SubjectJob SubjectJob = dbn.SubjectJob.FirstOrDefault(o => o.SubId == item.JobSubId);
DAL.Part p = dbn.Part.FirstOrDefault(s2 => s2.PartId == item.JobPartId);
DAL.Job job1 = dbn.Job.FirstOrDefault(j => j.JobId == item.JobId);
Entities.JobView v = new JobView();
DateTime.TryParse(item.JobDateAdv.ToString(), out temp);
if (temp != null)
{
diff2 = Convert.ToInt32((DateTime.Today - temp).TotalDays).ToString();
}
v = Entities.JobView.CreateJobView(area, company, job1, SubjectJob, w, p, outNet, city, diff2);
jv.Add(v);
}
db.Database.Connection.Close();
return(jv);
}
//DAL.IdialEntities3.Connection.Open();
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
var User = Membership.GetUser().UserName;
var context = new HireMeEntities();
DAL.Company obj = new DAL.Company();
obj.Name = txtCompanyName.Text;
obj.Industry = Convert.ToInt32(ddlIndustry.SelectedValue);
obj.PhoneNumber = Convert.ToInt32(txtPhoneNumber.Text);
//obj.co = Convert.ToInt32(txtCompanyEmail.Text);
obj.Country = Convert.ToInt32(ddlCountry.SelectedValue);
obj.City = Convert.ToInt32(ddlCity.SelectedValue);
obj.WebSite = txtWebSite.Text;
obj.UserId = context.aspnet_Membership.Where(x => x.aspnet_Users.UserName == User).FirstOrDefault().UserId;
context.Companies.Add(obj);
context.SaveChanges();
}
protected void btnSave_Click(object sender, EventArgs e)
{
Guid userId = new Guid(Request.QueryString["UserId"]);
var context = new HireMeEntities();
DAL.Company obj = new DAL.Company();
obj.Name = txtCompanyName.Text;
obj.Industry = Convert.ToInt32(ddlIndustry.SelectedValue);
obj.PhoneNumber = Convert.ToInt32(txtPhoneNumber.Text);
//obj.co = Convert.ToInt32(txtCompanyEmail.Text);
obj.Country = Convert.ToInt32(ddlCountry.SelectedValue);
obj.City = Convert.ToInt32(ddlCity.SelectedValue);
obj.WebSite = txtWebSite.Text;
obj.UserId = userId;
context.Companies.Add(obj);
context.SaveChanges();
divSuccess.Visible = true;
}
protected void butDelete_onClick(object sender, EventArgs e)
{
try
{
int id = int.Parse(((Button)sender).CommandName);
//AdminHelper adminHelper = new AdminHelper();
LimoEntitiesEntityFremwork limoEntities = new LimoEntitiesEntityFremwork();
DAL.Company companyTemp = limoEntities.Companies.Where(xx => xx.CompanyID == id).FirstOrDefault();
if (companyTemp != null)
{
limoEntities.Companies.DeleteObject(companyTemp);
limoEntities.SaveChanges();
}
Response.Redirect("~/admin/Pages/ManageCompany.aspx");
}
catch (Exception ex)
{
divProblem.Visible = true;
}
}
//public JobView():base()
//{
//}
public static Entities.JobView CreateJobView(DAL.Area a, DAL.Company c, DAL.Job j, DAL.SubjectJob s, DAL.Workspace w, DAL.Part p, DAL.OutNet o, DAL.City ci, string diff)
{
return(new Entities.JobView()
{
JobDateAdv = j.JobDateAdv,
JobDateShow = diff,
CompanyName = c.CompanyName,
CompanyId = c.CompanyId,
JobRole = j.JobRole,
JobDateCaughtJob = j.JobDateCaughtJob,
PartName = p.PartName,
OutNetName = o.OutNetName,
WSName = w.WSName,
JobExperience = j.JobExperience,
JobStars = j.JobStars,
JobDescribe = j.JobDescribe,
AreaName = a.AreaName,
BossId = j.JobBossId,
CityName = ci.CityName,
SubjectName = s.SubName,
JobRequire = j.JobRequire,
JobId = j.JobId
});
}
public static void Init()
{
var CompanyList = new List <DAL.Company>();
var CompanyDetails = new DAL.Company();
var db = new DAL.TargetFinancialDataContext();
var CheckData = new List <CVTemp>();
//vid_na_rabota_550.xlsx
//listing
var res = Workbook.Worksheets(@"C:\Nix\Project_Dev\Bonitet.ConsoleCSV\bin\Debug\vid_na_rabota_550.xlsx");
foreach (var worksheet in res)
{
var AOP = false;
var Tekovna = 0;
var Prethodna = 0;
var Oznaka = 0;
foreach (var row in worksheet.Rows)
{
var cellCounter = 0;
foreach (var cell in row.Cells)
{
if (cell != null)
{
if (cell.Text == "*******")
//if (cell.Text == "ПРЕГЛЕД НА ПОДАТОЦИ ОД ГОДИШНА СМЕТКА ЗА 2016 ГОДИНА - ВИД НА РАБОТА 550")
{
CompanyList.Add(CompanyDetails);
if (CompanyDetails.EMBS != null)
{
Console.WriteLine(CompanyList.Count());
if (CheckData != null)
{
break;
}
DALHelper.InsertCompanyValues1Temp(CompanyDetails);
}
CompanyDetails = new DAL.Company();
CompanyDetails.CYTemps.Add(new DAL.CYTemp
{
Company = CompanyDetails,
Year = 2014
});
CompanyDetails.CYTemps.Add(new DAL.CYTemp
{
Company = CompanyDetails,
Year = 2013
});
AOP = false;
Tekovna = 0;
Prethodna = 0;
Oznaka = 0;
}
if (cell.Text == "Назив на правното лице:")
{
CompanyDetails.Name = row.Cells[cellCounter + 1].Text;
}
if (cell.Text == "Место:")
{
CompanyDetails.Mesto = row.Cells[cellCounter + 1].Text;
}
if (cell.Text == "Матичен Број:")
{
CompanyDetails.EMBS = row.Cells[cellCounter + 1].Text.TrimStart('0');
CheckData = DALHelper.GetCompanyValuesByEMBSTemp(CompanyDetails.EMBS);
if (CheckData != null)
{
break;
}
}
else
{
if (CheckData != null)
{
break;
}
}
if (cell.Text == "Ознака за АОП")
{
Oznaka = cell.ColumnIndex;
}
if (cell.Text == "Тековна година")
{
Tekovna = cell.ColumnIndex;
}
if (cell.Text == "Претходна година")
{
Prethodna = cell.ColumnIndex;
}
if (AOP)
{
if (CompanyDetails.CYTemps.First().ID == 0)
{
CompanyDetails = DALHelper.InsertCompanyWithYearsTemp(CompanyDetails);
CompanyDetails.CVTemp = new List <CVTemp>();
}
if (row.Cells[Oznaka] != null)
{
var curOznaka = row.Cells[Oznaka].Text;
var newValID = db.Values.Where(c => c.Type == 1 && c.Name == curOznaka).Select(c => c.ID).FirstOrDefault();
var year4 = CompanyDetails.CYTemps.Where(c => c.Year == 2014).Select(c => c.ID).FirstOrDefault();
var year3 = CompanyDetails.CYTemps.Where(c => c.Year == 2013).Select(c => c.ID).FirstOrDefault();
if (CompanyDetails.CVTemp.Where(c => c.ValueID == newValID && c.YearID == year4).FirstOrDefault() == null)
{
if (row.Cells[Tekovna] != null)
{
var curValue = row.Cells[Tekovna].Text;
if (string.IsNullOrEmpty(curValue) == false)
{
curValue = curValue.Replace(".", "");
var newCompanyValue = new DAL.CVTemp();
newCompanyValue.CompanyID = CompanyDetails.ID;
newCompanyValue.YearID = year4;
double tmpVal = 0;
if (double.TryParse(curValue, out tmpVal))
{
newCompanyValue.Value = tmpVal;
newCompanyValue.ValueID = newValID;
CompanyDetails.CVTemp.Add(newCompanyValue);
}
}
}
}
if (CompanyDetails.CVTemp.Where(c => c.ValueID == newValID && c.YearID == year3).FirstOrDefault() == null)
{
if (row.Cells[Prethodna] != null)
{
var curValue = row.Cells[Prethodna].Text;
if (string.IsNullOrEmpty(curValue) == false)
{
curValue = curValue.Replace(".", "");
var newCompanyValue = new DAL.CVTemp();
newCompanyValue.CompanyID = CompanyDetails.ID;
newCompanyValue.YearID = year3;
double tmpVal = 0;
if (double.TryParse(curValue, out tmpVal))
{
newCompanyValue.Value = tmpVal;
newCompanyValue.ValueID = newValID;
CompanyDetails.CVTemp.Add(newCompanyValue);
}
}
}
}
}
}
if (Tekovna > 0 && Prethodna > 0 && Oznaka > 0)
{
AOP = true;
}
}
cellCounter++;
}
}
}
db.Dispose();
db = null;
}