private void btnAddEmployee_Click(object sender, EventArgs e)
{
if (txtCus.Text == "" || comboBoxR_Type.Text == "" || txtDetails.Text == "" || comboSupervisor.Text == "")
{
MessageBox.Show("Please fill the all required feilds");
}
else
{
RepairObject objRepair = new RepairObject();
CustomerObject objCustomer = new CustomerObject();
EmployeeObject objEmployee = new EmployeeObject();
objCustomer.Nic = txtCus.Text;
objRepair.JobStartDate = dtpStart.Value;
objRepair.JobEndDate = dtpEnd.Value;
objRepair.rType = comboBoxR_Type.Text;
objRepair.Details = txtDetails.Text;
objEmployee.empid = Convert.ToInt32(comboSupervisor.SelectedValue);
bool checker1 = false;
bool checker2 = false;
if (objRepair.JobStartDate >= DateTime.Today)
{
checker1 = true;
}
if (objRepair.JobEndDate >= DateTime.Today)
{
checker2 = true;
}
if (checker1 == false || checker2 == false)
{
MessageBox.Show("You cant enter this date");
}
else
{
string nic = txtCus.Text;
if ((nic.Count(char.IsDigit) == 9) && nic.EndsWith("v", StringComparison.OrdinalIgnoreCase))
{
DialogResult dr;
dr = MessageBox.Show("Do you want to save the record", "Confirm", MessageBoxButtons.YesNo);
if (dr.ToString() == "Yes")
{
try
{
MegaCoolMethods mcm = new MegaCoolMethods();
bool result = mcm.AddNewRepairJob(objRepair, objCustomer, objEmployee);
if (result)
{
MessageBox.Show("Successfully Saved", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
RepairFillGrid();
avCusFillGrid();
SqlConnection con = ConnectionManager.GetConnection();
con.Open();
string qu = "SELECT TOP 1 JobID FROM Repair_Job ORDER BY JobID DESC";
SqlCommand newcmd = con.CreateCommand();
newcmd.CommandText = qu;
SqlDataReader reader = newcmd.ExecuteReader();
reader.Read();
int y = reader.GetInt32(0);
txtJobID.Text = Convert.ToString(y);
tabControl1.SelectedTab = tabPage2;
}
else
{
MessageBox.Show("Unable to Save", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (ApplicationException appEx)
{
MessageBox.Show(appEx.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
catch (Exception ex)
{
throw ex;
}
}
else
{
MessageBox.Show("Record is not saved", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Error in NIC");
}
}
}
}
public void AddTO(long employeeId, RequestObjectTODTO dto)
{
EmployeeObject entity = employeeObjectRepository
.Get(t => t.Object.Id == dto.Id && t.Employee.Id == employeeId);
if (entity != null)
{
setErrorMsg("ObjectName", Resource.UniqueEmployeeObjectConstraintMsg);
}
if (dto.ObjectTypeId == 0)
{
setErrorMsg("ObjectTypeName", Resource.RequiredConstraintMsg);
}
checkStringConstraint("HardTypeName", dto.HardTypeName, true, 200, 2);
checkStringConstraint("ManufacturerName", dto.ManufacturerName, true, 200, 2);
checkStringConstraint("ModelName", dto.ModelName, true, 200, 2);
if (errorMessages.Count > 0)
{
throw new DataServiceException(Resource.GeneralConstraintMsg, errorMessages);
}
//----
HardType hardType = null;
if (dto.HardTypeId > 0)
{
hardType = hardTypeRepository.Get(dto.HardTypeId);
if (hardType.Name.ToUpper().Trim() != dto.HardTypeName.ToUpper().Trim())
{
hardType = new HardType()
{
Name = dto.HardTypeName.ToUpper().Trim()
};
hardTypeRepository.Save(hardType);
}
}
else
{
HardType existsHardType = hardTypeRepository.Get(new SimpleEntityByNameLikeSpecification <HardType>(dto.HardTypeName));
if (existsHardType != null)
{
hardType = existsHardType;
}
else
{
hardType = new HardType()
{
Name = dto.HardTypeName.ToUpper().Trim()
}
};
hardTypeRepository.Save(hardType);
}
//----
Manufacturer manufacturer = null;
if (dto.ManufacturerId > 0)
{
manufacturer = manufacturerRepository.Get(dto.ManufacturerId);
if (manufacturer.Name.ToUpper().Trim() != dto.ManufacturerName.ToUpper().Trim())
{
manufacturer = new Manufacturer()
{
Name = dto.ManufacturerName.ToUpper().Trim()
};
manufacturerRepository.Save(manufacturer);
}
}
else
{
Manufacturer existsManufacturer = manufacturerRepository.Get(new SimpleEntityByNameLikeSpecification <Manufacturer>(dto.ManufacturerName));
if (existsManufacturer != null)
{
manufacturer = existsManufacturer;
}
else
{
manufacturer = new Manufacturer()
{
Name = dto.ManufacturerName.ToUpper().Trim()
}
};
manufacturerRepository.Save(manufacturer);
}
//----
Model model = null;
if (dto.ModelId > 0)
{
model = modelRepository.Get(dto.ModelId);
if (model.Name.ToUpper().Trim() != dto.ModelName.ToUpper().Trim())
{
model = new Model()
{
Name = dto.ModelName.ToUpper().Trim(), Manufacturer = manufacturer
};
modelRepository.Save(model);
}
}
else
{
Model existsModel = modelRepository.Get(new SimpleEntityByNameLikeSpecification <Model>(dto.ModelName));
if (existsModel != null)
{
model = existsModel;
}
else
{
model = new Model()
{
Name = dto.ModelName.ToUpper().Trim(), Manufacturer = manufacturer
}
};
if (!model.Name.ToUpper().Contains(hardType.Name.ToUpper()))
{
model.Name = String.Format("{0} {1}", hardType.Name.ToUpper(), model.Name);
}
modelRepository.Save(model);
}
RequestObject requestObject = new RequestObject()
{
HardType = hardType,
Model = model,
ObjectType = objectTypeRepository.Get(dto.ObjectTypeId)
};
objectRepository.Save(requestObject);
entity = new EmployeeObject()
{
Object = requestObject,
Employee = employeeRepository.Get(employeeId)
};
employeeObjectRepository.Save(entity);
repository.SaveChanges();
dto.Id = entity.Object.Id;
}
private void btnUpdateJob_Click(object sender, EventArgs e)
{
RepairObject objRepair = new RepairObject();
EmployeeObject objEmployee = new EmployeeObject();
objRepair.rType = comboBoxR_Type.Text;
objRepair.JobEndDate = dtpEnd.Value;
objRepair.Details = txtDetails.Text;
string JobIDss = txtJobID3.Text;
string Superviss = comboSupervisor.Text;
if (JobIDss == "" || objRepair.rType == "" || txtDetails.Text == "" || comboSupervisor.Text == "")
{
MessageBox.Show("Please fill the all required feilds");
}
else
{
bool checker = false;
if (objRepair.JobEndDate >= DateTime.Today)
{
checker = true;
}
if (checker == false)
{
MessageBox.Show("You cant enter this date");
}
else
{
objRepair.JobID = Convert.ToInt32(txtJobID3.Text);
objEmployee.empid = Convert.ToInt32(comboSupervisor.SelectedValue);
DialogResult dr;
dr = MessageBox.Show("Do you want to save the record", "Confirm", MessageBoxButtons.YesNo);
if (dr.ToString() == "Yes")
{
try
{
MegaCoolMethods mcm = new MegaCoolMethods();
bool result = mcm.UpdateRepairJob(objEmployee, objRepair);
if (result)
{
MessageBox.Show("Successfully Saved", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
RepairUpdateFillGrid();
RepairFillGrid();
}
else
{
MessageBox.Show("Unable to Save", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
}
else
{
MessageBox.Show("Record is not saved", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
