private string CreateContractorInfo(ContractorQualification cq, out string contractorID)
{
contractorID = string.Empty;
Console.WriteLine("Save：" + DateTime.Now.ToString());
try
{
var Contractors = Db.ContractorQualifications.Where(c => c.ContractorName == cq.ContractorName.ToUpper() && c.isvalid == 1).ToList();
if (Contractors.Count <= 0)
{
string type = "Contractor";
cq.ContractorID = gate.SelectScalar <string>("select dbo.fnContractorEmployeeID(@typeID)", new object[] { type });
cq.ContractorName = cq.ContractorName.ToUpper();
cq.Stamp = DateTime.Now;
cq.Status = "N";
cq.ContractorFile = cq.ContractorFile;
cq.EmailContractor = cq.EmailContractor;
Db.ContractorQualifications.Add(cq);
}
else
{
return(string.Format("{0} is exsit", cq.ContractorName));
}
Db.SaveChanges();
JsonObject json = new JsonObject();
json["contractorID"] = cq.ContractorID;
contractorID = json.ToString();
return("");
}
catch (Exception e)
{
Loger.Error(e);
return(e.Message + e.StackTrace);
}
}
public IHttpActionResult GetByname(string contractorName)
{
try
{
var contractorQualification = Db.ContractorQualifications.Where(c => c.ContractorName == contractorName).OrderByDescending(c => c.Stamp).ToList();
if (contractorQualification.Count > 0)
{
var valid = contractorQualification.FindAll(c => c.isvalid == 1).ToList();
if (valid.Count > 1)//两个有效，系统错误--Hai lỗi hệ thống hợp lệ
{
return(BadRequest(string.Format("{0} Duplicate information, please call managers", contractorName)));
}
else if (valid.Count == 1)
{
var contractorQua = Db.ContractorQualifications.Find(contractorQualification[0].ContractorID);
return(Ok(contractorQua));
}
var newcq = contractorQualification[0];
// newcq.QualificationFiles = Db.ContractorQualificationFiles.Where(c => c.EmployerId == newcq.ContractorID).ToList();
// newcq.ContractorID = "";
//newcq.Status = "";
///Console.WriteLine(newcq.QualificationFiles.Count);
// newcq.QualificationFiles = newcq.QualificationFiles;
// newcq.isvalid = 0;
return(Ok(newcq));
}
var cq = new ContractorQualification
{
ContractorName = contractorName
};
return(Ok(cq));
}
catch (Exception e)
{
Loger.Error(e);
return(BadRequest(e.Message + e.StackTrace));
}
}
public IHttpActionResult Save(ContractorQualification cq)
{
if (string.IsNullOrEmpty(cq.ContractorID))
{
string contractorID = "";
string errmsg = CreateContractorInfo(cq, out contractorID);
if (string.IsNullOrEmpty(errmsg))
{
var response = Request.CreateResponse(HttpStatusCode.OK);
JsonObject json = new JsonObject();
json["contractorID"] = contractorID;
return(Ok(json));
}
else
{
return(BadRequest(errmsg));
}
}
else
{
string contractorID = cq.ContractorID;
string errmsg = UpdateContractorInfo(cq, out contractorID);
if (string.IsNullOrEmpty(errmsg))
{
var response = Request.CreateResponse(HttpStatusCode.OK);
JsonObject json = new JsonObject();
json["contractorID"] = contractorID;
return(Ok(json));
}
else
{
return(BadRequest(errmsg));
}
}
}
private string UpdateContractorInfo(ContractorQualification cq, out string contractorID)
{
contractorID = cq.ContractorID.ToString();
try
{
if (!string.IsNullOrEmpty(cq.ContractorID.ToString()))
{
var contractorQualification = Db.ContractorQualifications.Where(c => c.ContractorName == cq.ContractorName && c.isvalid == 1).ToList();
if (contractorQualification.Count >= 1)
{
if (contractorQualification.Count == 1)
{
if (contractorID != contractorQualification[0].ContractorID)
{
return("ContractorID is being created,ContractorID isn't the same!");
}
}
else
{
return("ContractorID already exists");
}
}
var _ContractorQualification = Db.ContractorQualifications.Find(cq.ContractorID);
if (_ContractorQualification != null)
{
_ContractorQualification.ContractorID = cq.ContractorID;
_ContractorQualification.ContractorName = cq.ContractorName.ToUpper();
_ContractorQualification.CType = cq.CType;
_ContractorQualification.isvalid = cq.isvalid;
_ContractorQualification.Remark = cq.Remark;
_ContractorQualification.DepartmentID = cq.DepartmentID;
_ContractorQualification.UserID = cq.UserID;
_ContractorQualification.AccDate = cq.AccDate;
_ContractorQualification.Status = cq.Status;
_ContractorQualification.Rcode = cq.Rcode;
_ContractorQualification.Type = cq.Type;
_ContractorQualification.Stamp = DateTime.Now;
_ContractorQualification.Region = cq.Region;
_ContractorQualification.StartDate = cq.StartDate;
_ContractorQualification.EndDate = cq.EndDate;
_ContractorQualification.ContractorByEmloyee = cq.ContractorByEmloyee;
_ContractorQualification.InternalNumber = cq.InternalNumber;
_ContractorQualification.Email = cq.Email;
_ContractorQualification.ContractorFile = cq.ContractorFile;
_ContractorQualification.EmailContractor = cq.EmailContractor;
Db.Entry(_ContractorQualification).State = EntityState.Modified;
}
else
{
return("ContractorID is not exist!");
}
Db.SaveChanges();
JsonObject json = new JsonObject();
json["contractorID"] = cq.ContractorID;
contractorID = json.ToString();
return("");
}
else
{
return("ContractorID is Null!");
}
}
catch (Exception e)
{
Loger.Error(e);
return(e.Message + e.StackTrace);
}
}
