protected void saveLoggedInfo_OnClick(object sender, EventArgs e)
{
var query = Request.QueryString;
var projId = Convert.ToInt64(query.Get("id"));
var id = Convert.ToInt64(Session["ID"]);
var workLogId = 0L;
var selectedDate = Request.Form[start_period.UniqueID];
if (!string.IsNullOrEmpty(selectedDate))
{
var convertDate = CovertToDateTime(selectedDate);
var logFound = _projectService.GetWorkLogByProjIdAndDate(projId, convertDate);
if (!logFound)
{
var log = new WorkLog
{
date_logged = convertDate,
proj_id = (int)projId,
user_id = (int)id
};
_insendluEntities.WorkLogs.Add(log);
var check = _insendluEntities.SaveChanges();
if (check == 1)
{
workLogId = log.id;
}
//Accommodation
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(accCost.Text))
{
var date = Request.Form[start_period.UniqueID];
var startP = CovertToDateTime(date);
var accomCost = Convert.ToInt32(accCost.Text);
var accomLocation = accLocation.Text;
var accommodation = new Accommodation
{
cost = accomCost,
start_date = convertDate,
location = accomLocation,
worklog_id = (int)workLogId,
project_id = (int)projId
};
_insendluEntities.Accommodations.Add(accommodation);
_insendluEntities.SaveChanges();
}
//Vehicle Details
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(vCost.Text))
{
var date = Request.Form[start_period.UniqueID];
var vStartDat = CovertToDateTime(date);
var vDetails = vType.Text;
var vMill = vMilage.Text;
var vCos = Convert.ToInt32(vCost.Text);
var vehicle = new Vehicle
{
cost = vCos,
start_date = convertDate,
mileage = vMill,
type = vDetails,
worklog_id = (int)workLogId,
project_id = (int)projId
};
_insendluEntities.Vehicles.Add(vehicle);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(empCostPerDay.Text))
{
//Employees
var date = Request.Form[start_period.UniqueID];
var empStartDate = CovertToDateTime(date);
var emploType = empType.Text;
var numOfEmp = empNumber.Text;
var empCost = Convert.ToInt32(empCostPerDay.Text);
var employees = new Employee
{
cost = empCost,
employee_type = emploType,
no_of_employees = numOfEmp,
start_date = convertDate,
worklog_id = (int)workLogId,
project_id = (int)projId
};
_insendluEntities.Employees.Add(employees);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(matCost.Text))
{
//Print Material
var date = Request.Form[start_period.UniqueID];
var matStart = CovertToDateTime(date);
var matQua = matQuantity.Text;
var matName = materialName.Text;
var matCos = Convert.ToInt32(matCost.Text);
var material = new PrintMaterial
{
worklog_id = (int)workLogId,
cost = matCos,
start_date = convertDate,
project_id = (int)projId,
name = matName,
quantity = matQua
};
_insendluEntities.PrintMaterials.Add(material);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(refCost.Text))
{
//Refreshments
var date = Request.Form[start_period.UniqueID];
var refStart = CovertToDateTime(date);
var refCostAmount = Convert.ToInt32(refCost.Text);
var refreshments = new Refreshment
{
cost = refCostAmount,
start_date = convertDate,
worklog_id = (int)workLogId,
project_id = (int)projId
};
_insendluEntities.Refreshments.Add(refreshments);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(telCost.Text))
{
//Telephone
var date = Request.Form[start_period.UniqueID];
var telStart = CovertToDateTime(date);
var telCostAmount = Convert.ToInt32(telCost.Text);
var telephone = new Telephone
{
cost = telCostAmount,
start_date = convertDate,
worklog_id = (int)workLogId,
project_id = (int)projId
};
_insendluEntities.Telephones.Add(telephone);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(wifiCost.Text))
{
//WIFI
var date = Request.Form[start_period.UniqueID];
var wifiStart = CovertToDateTime(date);
var wifiTotalCost = Convert.ToInt32(wifiCost.Text);
var wifi = new Wifi
{
cost = wifiTotalCost,
worklog_id = (int)workLogId,
start_date = convertDate,
project_id = (int)projId
};
_insendluEntities.Wifis.Add(wifi);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(fieldWorkDrop.Value))
{
//FIELD WORK STATISTICS
var date = Request.Form[start_period.UniqueID];
var fieldStart = CovertToDateTime(date);
var fieldWork = fieldWorkDrop.Value;
var fieldWorkStarts = new FieldWorkStatistic
{
name = fieldWork,
worklog_id = (int)workLogId,
start_date = convertDate,
project_id = (int)projId
};
_insendluEntities.FieldWorkStatistics.Add(fieldWorkStarts);
_insendluEntities.SaveChanges();
}
Response.Redirect("ProjectTimeLine.aspx?id=" + projId);
}
Page.ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('Already Logged work for this day')", true);
}
Page.ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('Please select a date')", true);
}
protected void saveLoggedInfo_OnClick(object sender, EventArgs e)
{
var query = Request.QueryString;
var workLog = Convert.ToInt64(query.Get("id"));
var id = Convert.ToInt64(Session["ID"]);
//Accommodation
if (!string.IsNullOrEmpty(Request.Form[start_period.UniqueID]) && !string.IsNullOrEmpty(Request.Form[end_period.UniqueID]))
{
var startP = Convert.ToDateTime(Request.Form[start_period.UniqueID]).Date;
var endP = Convert.ToDateTime(Request.Form[end_period.UniqueID]).Date;
var accomCost = Convert.ToInt32(accCost.Text);
var accomLocation = accLocation.Text;
var accommodation = new Accommodation()
{
cost = accomCost,
end_start = endP,
start_date = startP,
location = accomLocation,
worklog_id = (int)workLog
};
_insendluEntities.Accommodations.Add(accommodation);
_insendluEntities.SaveChanges();
}
//Vehicle Details
if (!string.IsNullOrEmpty(Request.Form[vStartDate.UniqueID]) && !string.IsNullOrEmpty(Request.Form[vEndDate.UniqueID]))
{
var vStartDat = Convert.ToDateTime(Request.Form[vStartDate.UniqueID]).Date;
var vEndDat = Convert.ToDateTime(Request.Form[vEndDate.UniqueID]).Date;
var vDetails = vType.Text;
var vMill = vMilage.Text;
var vCos = Convert.ToInt32(vCost.Text);
var vehicle = new Vehicle()
{
cost = vCos,
end_start = vEndDat,
start_date = vStartDat,
mileage = vMill,
type = vDetails,
worklog_id = (int)workLog
};
_insendluEntities.Vehicles.Add(vehicle);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[empStart.UniqueID]) && !string.IsNullOrEmpty(Request.Form[empEndDate.UniqueID]))
{
//Employees
var empStartDate = Convert.ToDateTime(Request.Form[empStart.UniqueID]).Date;
var empEnd = Convert.ToDateTime(Request.Form[empEndDate.UniqueID]).Date;
var emploType = empType.Text;
var numOfEmp = empNumber.Text;
var empCost = Convert.ToInt32(empCostPerDay.Text);
var employees = new Employee()
{
cost = empCost,
employee_type = emploType,
end_start = empEnd,
no_of_employees = numOfEmp,
start_date = empStartDate,
worklog_id = (int)workLog
};
_insendluEntities.Employees.Add(employees);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[matStartDate.UniqueID]) && !string.IsNullOrEmpty(Request.Form[matEndDate.UniqueID]))
{
//Print Material
var matStart = Convert.ToDateTime(Request.Form[matStartDate.UniqueID]).Date;
var matEnd = Convert.ToDateTime(Request.Form[matEndDate.UniqueID]).Date;
var matQua = matQuantity.Text;
var matName = materialName.Text;
var matCos = Convert.ToInt32(matCost.Text);
var material = new PrintMaterial()
{
worklog_id = (int)workLog,
cost = matCos,
start_date = matStart,
end_start = matEnd,
name = matName,
quantity = matQua
};
_insendluEntities.PrintMaterials.Add(material);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[refStartDate.UniqueID]) && !string.IsNullOrEmpty(Request.Form[refEndDate.UniqueID]))
{
//Refreshments
var refStart = Convert.ToDateTime(Request.Form[refStartDate.UniqueID]).Date;
var refEnd = Convert.ToDateTime(Request.Form[refEndDate.UniqueID]).Date;
var refCostAmount = Convert.ToInt32(refCost.Text);
var refreshments = new Refreshment()
{
cost = refCostAmount,
end_start = refEnd,
start_date = refStart,
worklog_id = (int)workLog
};
_insendluEntities.Refreshments.Add(refreshments);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[telStartDate.UniqueID]) && !string.IsNullOrEmpty(Request.Form[telEndDate.UniqueID]))
{
//Telephone
var telStart = Convert.ToDateTime(Request.Form[telStartDate.UniqueID]).Date;
var telEndDat = Convert.ToDateTime(Request.Form[telEndDate.UniqueID]).Date;
var telCostAmount = Convert.ToInt32(telCost.Text);
var telephone = new Telephone()
{
cost = telCostAmount,
end_start = telEndDat,
start_date = telStart,
worklog_id = (int)workLog
};
_insendluEntities.Telephones.Add(telephone);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[wifiStartDate.UniqueID]) && !string.IsNullOrEmpty(Request.Form[wifiEndDate.UniqueID]))
{
//WIFI
var wifiStart = Convert.ToDateTime(Request.Form[wifiStartDate.UniqueID]).Date;
var wifiEnd = Convert.ToDateTime(Request.Form[wifiEndDate.UniqueID]).Date;
var wifiTotalCost = Convert.ToInt32(wifiCost.Text);
var wifi = new Wifi()
{
cost = wifiTotalCost,
worklog_id = (int)workLog,
start_date = wifiStart,
end_start = wifiEnd
};
_insendluEntities.Wifis.Add(wifi);
_insendluEntities.SaveChanges();
}
if (!string.IsNullOrEmpty(Request.Form[fieldStartDate.UniqueID]) && !string.IsNullOrEmpty(Request.Form[fieldEndDate.UniqueID]))
{
//FIELD WORK STATISTICS
var fieldStart = Convert.ToDateTime(Request.Form[fieldStartDate.UniqueID]).Date;
var fieldEnd = Convert.ToDateTime(Request.Form[fieldEndDate.UniqueID]).Date;
var fieldWork = fieldWorkDrop.Value;
var fieldWorkStarts = new FieldWorkStatistic()
{
name = fieldWork,
worklog_id = (int)workLog,
start_date = fieldStart,
end_date = fieldEnd
};
_insendluEntities.FieldWorkStatistics.Add(fieldWorkStarts);
_insendluEntities.SaveChanges();
}
Page.ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('Information saved Successfully')", true);
Response.Redirect("Proposals.aspx");
}