public async Task UpdateOwner(OwnerDetail req)
{
var owner = _context.Owner.Where(x => x.OwnerId == req.OwnerId).FirstOrDefault();
owner = _mapper.Map <Owner>(req);
_context.SaveChanges();
}
public override void LoadReport(StreamReader src, FileInfo fi)
{
_Timestamp = fi.LastWriteTimeUtc;
SimpleCSVReader r = new SimpleCSVReader(src, '\t',
new List <SimpleCSVReaderColumnNameReplacer>()
{
new SimpleCSVReaderColumnNameReplacer(SimpleCSVReaderReplaceMode.Equals, "size (including recycle bins)(byte)", "size"),
new SimpleCSVReaderColumnNameReplacer(SimpleCSVReaderReplaceMode.Equals, "size (excluding recycle bins)(byte)", "nobinsize"),
new SimpleCSVReaderColumnNameReplacer(SimpleCSVReaderReplaceMode.Equals, "size(byte)", "size"),
new SimpleCSVReaderColumnNameReplacer(SimpleCSVReaderReplaceMode.Equals, "username", "owner"),
new SimpleCSVReaderColumnNameReplacer(SimpleCSVReaderReplaceMode.Equals, "shared folder", "share"),
}
);
while (r.EndOfStream == false)
{
r.ReadLine();
var detail = new OwnerDetail(r.GetValue("owner"), r.GetValue("share"), long.Parse(r.GetValue("file count")), long.Parse(r.GetValue("size")));
_files.Add(detail);
}
src.Close();
}
public IHttpActionResult PutOwnerDetail(long id, OwnerDetail ownerDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != ownerDetail.Owner_detail_No)
{
return(BadRequest());
}
db.Entry(ownerDetail).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!OwnerDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public int VehicleRegisterEdit(int id, CompleteDetailsViewModel edit)
{
using (var entity = new VehicleRegistrationContext())
{
using (System.Data.Entity.DbContextTransaction dbTran = entity.Database.BeginTransaction())
{
try
{
var details = (from m in entity.VehicleDetails
where m.VehicleId == id
select m).FirstOrDefault();
details.VehicleNameId = edit.VehicleNameId;
details.Colour = edit.Colour;
details.ChasisNumber = edit.ChasisNumber;
entity.SaveChanges();
var nameCount = (from n in entity.OwnerDetails
where n.OwnerName == edit.OwnerName
select n.OwnerName).Count();
if (nameCount == 0)
{
OwnerDetail addOwner = new OwnerDetail();
addOwner.OwnerName = edit.OwnerName;
addOwner.Address = edit.Address;
addOwner.Country = edit.CountryId;
entity.OwnerDetails.Add(addOwner);
entity.SaveChanges();
}
var ownerId = (from o in entity.OwnerDetails
where o.OwnerName == edit.OwnerName
select o.Id).FirstOrDefault();
var ownerNewDetails = (from m in entity.OwnerVehicleIntermediates
join n in entity.OwnerDetails
on m.OwnerId equals n.Id
join v in entity.VehicleDetails
on m.VehiclesId equals v.VehicleId
where v.VehicleId == id
select m).FirstOrDefault();
ownerNewDetails.OwnerId = ownerId;
int set = entity.SaveChanges();
dbTran.Commit();
return(2);
}
catch
{
dbTran.Rollback();
return(0);
}
}
}
}
public IHttpActionResult GetOwnerDetailer(long id)
{
OwnerDetail ownerDetail = db.OwnerDetails.Find(id);
if (ownerDetail == null)
{
return(NotFound());
}
return(Ok(ownerDetail));
}
public IHttpActionResult PostOwnerDetail(OwnerDetail ownerDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.OwnerDetails.Add(ownerDetail);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = ownerDetail.Owner_detail_No }, ownerDetail));
}
//internal IEnumerable<UserDetail> GetUserDetails(string userId)
//{
// List<UserDetail> userDetails = new List<UserDetail>();
// Dictionary<string, SqlParameter> cmdParameters = new Dictionary<string, SqlParameter>();
// cmdParameters["UserID"] = new SqlParameter("UserID", userId);
// DataSet dataSet = dbutility.ExecuteQuery("QuotationDb", "dbo.GetUserDetails", cmdParameters);
// if (dataSet != null)
// {
// var dataTable = dataSet.Tables[0];
// userDetails = dataTable.AsEnumerable().Select(row =>
// new UserDetail
// {
// UserID = (int)row.Field<long>("UserID"),
// UserName = row.Field<string>("UserName"),
// Password = row.Field<string>("Password"),
// CreatedBy = row.Field<string>("CreatedBy"),
// CreatedDate = row.Field<DateTime?>("CreatedDate"),
// LastUpdatedBy = row.Field<string>("LastUpdatedBy"),
// LastUpdatedDate = row.Field<DateTime?>("LastUpdatedDate")
// }).ToList();
// }
// return userDetails;
//}
internal ErrorDetail UpdateOwnerDetails(OwnerDetail ownerDetail, string flag)
{
Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>();
cmdParameters["@Flag"] = new SqlParameter("@Flag", flag);
cmdParameters["@Name"] = new SqlParameter("@Name", ownerDetail.Name);
cmdParameters["@NRIC"] = new SqlParameter("@NRIC", ownerDetail.NRIC);
cmdParameters["@Contact"] = new SqlParameter("@Contact", ownerDetail.Contact);
cmdParameters["@BizRegNo"] = new SqlParameter("@BizRegNo", ownerDetail.BizRegNo);
cmdParameters["@DateOfBirth"] = new SqlParameter("@DateOfBirth", ownerDetail.DateOfBirth);
cmdParameters["@Gender"] = new SqlParameter("@Gender", ownerDetail.Gender);
cmdParameters["@MaritalStatus"] = new SqlParameter("@MaritalStatus", ownerDetail.MaritalStatus);
cmdParameters["@Occupation"] = new SqlParameter("@Occupation", ownerDetail.Occupation);
cmdParameters["@Industry"] = new SqlParameter("@Industry", ownerDetail.Industry);
cmdParameters["@LicenseDate"] = new SqlParameter("@LicenseDate", ownerDetail.LicenseDate);
cmdParameters["@Email"] = new SqlParameter("@Email", ownerDetail.Email);
cmdParameters["@Address"] = new SqlParameter("@Address", ownerDetail.Address);
cmdParameters["@RenewalRemindDays"] = new SqlParameter("RenewalRemindDays", ownerDetail.RenewalRemindDays);
cmdParameters["@LogUser"] = new SqlParameter("@LogUser", ownerDetail.CreatedBy);
SqlParameter outPutParameter1 = new SqlParameter();
outPutParameter1.ParameterName = "@ERRORNO";
outPutParameter1.SqlDbType = System.Data.SqlDbType.Int;
outPutParameter1.Size = 255;
outPutParameter1.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@ERRORNO"] = outPutParameter1;
SqlParameter outPutParameter2 = new SqlParameter();
outPutParameter2.ParameterName = "@ERRORDESC";
outPutParameter2.SqlDbType = System.Data.SqlDbType.VarChar;
outPutParameter2.Size = 255;
outPutParameter2.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@ERRORDESC"] = outPutParameter2;
ErrorDetail errorDetail = new ErrorDetail();
dbutility.ExecuteNonQuery("QuotationDb", "dbo.UpdateOwnerDetails", cmdParameters);
//if (dataSet != null && dataSet.Tables.Count > 1)
//{
// var dataTable = dataSet.Tables[0];
// errorDetail.Code = dataTable.Rows[0].Field<int>("@ERRORNO");
// errorDetail.Info = dataTable.Rows[0].Field<string>("@ERRORDESC");
//}
errorDetail.Code = int.Parse(outPutParameter1.Value.ToString());
errorDetail.Info = outPutParameter2.Value.ToString();
return(errorDetail);
}
public IHttpActionResult DeleteOwnerDetail(long id)
{
OwnerDetail ownerDetail = db.OwnerDetails.Find(id);
if (ownerDetail == null)
{
return(NotFound());
}
db.OwnerDetails.Remove(ownerDetail);
db.SaveChanges();
return(Ok(ownerDetail));
}
public ActionResult Edit(OwnerViewModel ownerDetail)
{
if (ModelState.IsValid)
{
OwnerDetail dbOwnerDetail = (OwnerDetail)GBContext.OwnerDetails.Where(m => m.OwnerDetailID == ownerDetail.OwnerDetailID).FirstOrDefault();
//check ph number
if (dbOwnerDetail.PhoneNumber != dbOwnerDetail.PhoneNumber)
{
var User = GBContext.OwnerDetails.Where(m => m.PhoneNumber == ownerDetail.PhoneNumber).FirstOrDefault();
if (User != null)
{
return(Json(new { Success = false, Message = "Phone number already exists!" }, JsonRequestBehavior.AllowGet));
}
}
dbOwnerDetail.FirstName = ownerDetail.FirstName;
dbOwnerDetail.LastName = ownerDetail.LastName;
dbOwnerDetail.PhoneNumber = ownerDetail.PhoneNumber;
dbOwnerDetail.Pincode = ownerDetail.Pincode;
dbOwnerDetail.Email = ownerDetail.Email;
dbOwnerDetail.Notes = ownerDetail.Notes;
dbOwnerDetail.LastUpdatedBy = SessionManager.GetSessionUser().Id;
dbOwnerDetail.LastUpdatedOn = DateTime.Now;
if (ownerDetail.FollowUpOn != null && ownerDetail.FollowUpOn != String.Empty)
{
dbOwnerDetail.FollowUpOn = DateTime.ParseExact(ownerDetail.FollowUpOn.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
dbOwnerDetail.FollowUpNotes = ownerDetail.FollowUpNotes;
if (ownerDetail.NextFollowUp != null && ownerDetail.NextFollowUp != String.Empty)
{
dbOwnerDetail.NextFollowUp = DateTime.ParseExact(ownerDetail.NextFollowUp.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
GBContext.OwnerDetailsActivityLogs.Add(Mapper.Map <OwnerDetail, OwnerDetailsActivityLog>(dbOwnerDetail));
if (GBContext.SaveChanges() > 0)
{
return(Json(new { Success = true, Message = "Owner Details updated Successfully!!" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Success = false, Message = "Error in updating owner details.Please try again later." }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { Success = false, Message = "Please check your inputs and try again." }, JsonRequestBehavior.AllowGet));
}
public async Task <IHttpActionResult> DeleteOwnerDetails([FromBody] OwnerDetail ownerDetail)
{
try
{
ErrorDetail errorDetail = await Task.Run(() => quotationDb.UpdateOwnerDetails(ownerDetail, "DELETE"));
if (errorDetail == null)
{
return(NotFound());
}
return(Ok(errorDetail));
}
catch (Exception)
{
return(InternalServerError());
}
}
public ErrorDetail AddOwnerDetails(OwnerDetail ownerDetail)
{
ErrorDetail errorDetail = new ErrorDetail();
try
{
//using (var formData = new MultipartFormDataContent())
//{
// formData.Add(new StringContent(JsonConvert.SerializeObject(ownerDetail), Encoding.UTF8, "application/json"), "ownerDetail");
// //formData.Add(new StringContent(flag), "flag");
// HttpResponseMessage responseMessage = client.PostAsync("/api/Quotation/UpdateOwnerDetails", formData).Result;
// if (responseMessage.IsSuccessStatusCode)
// {
// string data = responseMessage.Content.ReadAsStringAsync().Result;
// errorDetail = JsonConvert.DeserializeObject<ErrorDetail>(data);
// }
// else
// {
// errorDetail.Info = responseMessage.ReasonPhrase;
// }
//}
ownerDetail.CreatedDate = DateTime.Now;
ownerDetail.LastUpdatedDate = DateTime.Now;
HttpResponseMessage responseMessage = client.PostAsJsonAsync("/api/Quotation/AddOwnerDetails", ownerDetail).Result;
if (responseMessage.IsSuccessStatusCode)
{
string data = responseMessage.Content.ReadAsStringAsync().Result;
errorDetail = JsonConvert.DeserializeObject <ErrorDetail>(data);
}
else
{
errorDetail.Info = responseMessage.ReasonPhrase;
}
}
catch (Exception ex)
{
errorDetail.Info = ex.Message;
}
return(errorDetail);
}
public JsonResult Add(OwnerViewModel model)
{
if (ModelState.IsValid)
{
var UserID = SessionManager.GetSessionUser().Id;
var ownerDetail = GBContext.OwnerDetails.Where(m => m.PhoneNumber == model.PhoneNumber).FirstOrDefault();
if (ownerDetail == null)
{
OwnerDetail owner = new OwnerDetail();
owner.FirstName = model.FirstName;
owner.LastName = model.LastName;
owner.PhoneNumber = model.PhoneNumber;
owner.Pincode = model.Pincode;
owner.Email = model.Email;
owner.Notes = model.Notes;
owner.UserID = UserID;
owner.CreatedOn = DateTime.Now;
owner.LastUpdatedOn = DateTime.Now;
owner.CityID = model.CityID;
GBContext.OwnerDetails.Add(owner);
GBContext.OwnerDetailsActivityLogs.Add(Mapper.Map <OwnerDetail, OwnerDetailsActivityLog>(owner));
if (GBContext.SaveChanges() > 0)
{
return(Json(new { Success = true, Message = "New owner added successfully." }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Success = false, Message = "Failed to add owner." }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { Success = false, Message = "Owner details(phone number) already exists! Please try with some other owner." }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { Success = false, Message = "Please check your inputs and try again." }, JsonRequestBehavior.AllowGet));
}
public ErrorDetail DeleteOwnerDetails(OwnerDetail ownerDetail)
{
ErrorDetail errorDetail = new ErrorDetail();
try
{
HttpResponseMessage responseMessage = client.PostAsJsonAsync("/api/Quotation/DeleteOwnerDetails", ownerDetail).Result;
if (responseMessage.IsSuccessStatusCode)
{
string data = responseMessage.Content.ReadAsStringAsync().Result;
errorDetail = JsonConvert.DeserializeObject <ErrorDetail>(data);
}
else
{
errorDetail.Info = responseMessage.ReasonPhrase;
}
}
catch (Exception ex)
{
errorDetail.Info = ex.Message;
}
return(errorDetail);
}
public async Task CreateOwner(OwnerDetail req)
{
_context.Owner.Add(_mapper.Map <Owner>(req));
_context.SaveChanges();
}
public Response ResponseSuccessful(OwnerDetail ownerDetail)
{
return(this.ResponseResult(ResponseStatus.Successful, null, ownerDetail));
}
/// <summary>
/// There are no comments for OwnerDetailSet in the schema.
/// </summary>
public void AddToOwnerDetailSet(OwnerDetail ownerDetail)
{
base.AddObject("OwnerDetailSet", ownerDetail);
}
/// <summary>
/// Create a new OwnerDetail object.
/// </summary>
/// <param name="detailId">Initial value of DetailId.</param>
public static OwnerDetail CreateOwnerDetail(int detailId)
{
OwnerDetail ownerDetail = new OwnerDetail();
ownerDetail.DetailId = detailId;
return ownerDetail;
}
public int AddRegistration(CompleteDetailsViewModel addNew)
{
using (var entity = new VehicleRegistrationContext())
{
var vehicleUniqueness = (from m in entity.VehicleDetails
where m.VehicleNumber == addNew.VehicleNumber
select m.VehicleNumber).Count();
var nameCount = (from n in entity.OwnerDetails
where n.OwnerName == addNew.OwnerName
select n.OwnerName).Count();
if (vehicleUniqueness == 0)
{
VehicleDetail addVehicle = new VehicleDetail();
addVehicle.VehicleNumber = addNew.VehicleNumber;
addVehicle.VehicleNameId = addNew.VehicleNameId;
addVehicle.ChasisNumber = addNew.ChasisNumber;
addVehicle.Colour = addNew.Colour;
DateTime dateAndTime = DateTime.Today;
addVehicle.Date = dateAndTime.ToString("dd-MM-yyyy");
addVehicle.IsActive = true;
using (System.Data.Entity.DbContextTransaction dbTran = entity.Database.BeginTransaction())
{
try
{
entity.VehicleDetails.Add(addVehicle);
entity.SaveChanges();
var id = (from m in entity.VehicleDetails
orderby m.VehicleId descending
select m.VehicleId).FirstOrDefault();
if (nameCount == 0)
{
OwnerDetail addOwner = new OwnerDetail();
addOwner.OwnerName = addNew.OwnerName;
addOwner.Country = addNew.CountryId;
addOwner.Address = addNew.Address;
entity.OwnerDetails.Add(addOwner);
entity.SaveChanges();
}
var ownerId = (from o in entity.OwnerDetails
where o.OwnerName == addNew.OwnerName
select o.Id).FirstOrDefault();
OwnerVehicleIntermediate addDetails = new OwnerVehicleIntermediate();
addDetails.VehiclesId = Convert.ToInt32(id);
addDetails.OwnerId = ownerId;
entity.OwnerVehicleIntermediates.Add(addDetails);
entity.SaveChanges();
dbTran.Commit();
return(2);
}
catch
{
dbTran.Rollback();
return(0);
}
}
}
else
{
return(0);
}
}
}
