public IActionResult DapperTransactionalInsert([FromBody] CreditCard CreditCard)
{
using (IDbConnection dbConnection = new SqlConnection(_connectionString))
{
if (dbConnection.State != ConnectionState.Open)
{
dbConnection.Open();
}
using (var transaction = dbConnection.BeginTransaction())
{
string sql = @"INSERT INTO [Sales].[CreditCard] (CardType,CardNumber,ExpMonth,ExpYear,ModifiedDate)
VALUES (@CardType,@CardNumber,@ExpMonth,@ExpYear,@ModifiedDate);";
var affected = dbConnection.Execute(sql, CreditCard, transaction: transaction);
sql = @"SELECT TOP(1) * FROM [Sales].[CreditCard] ORDER BY [CreditCardID] DESC";
CreditCard selectCreditCard = dbConnection.QueryFirst <CreditCard>(sql, transaction: transaction);
PersonCreditCard personCreditCard = new PersonCreditCard
{
CreditCardID = selectCreditCard.CreditCardID,
ModifiedDate = selectCreditCard.ModifiedDate,
BusinessEntityID = 1001
};
sql = @"INSERT INTO [Sales].[PersonCreditCard] (BusinessEntityID,CreditCardID,ModifiedDate) VALUES(@BusinessEntityID,@CreditCardID,@ModifiedDate)";
var affected2 = dbConnection.Execute(sql, personCreditCard, transaction: transaction);
transaction.Commit();
return(affected + affected2 > 0 ? (IActionResult)Ok() : NotFound());
}
}
}
public virtual PersonCreditCard MapBOToEF(
BOPersonCreditCard bo)
{
PersonCreditCard efPersonCreditCard = new PersonCreditCard();
efPersonCreditCard.SetProperties(
bo.BusinessEntityID,
bo.CreditCardID,
bo.ModifiedDate);
return(efPersonCreditCard);
}
public virtual BOPersonCreditCard MapEFToBO(
PersonCreditCard ef)
{
var bo = new BOPersonCreditCard();
bo.SetProperties(
ef.BusinessEntityID,
ef.CreditCardID,
ef.ModifiedDate);
return(bo);
}
// PUT api/awbuildversion/5
public void Put(PersonCreditCard value)
{
var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault();
if (GetActionType.Key != null)
{
if (GetActionType.Value.ToList()[0].Equals("DELETE"))
adventureWorks_BC.PersonCreditCardDelete(value);
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
adventureWorks_BC.PersonCreditCardUpdate(value);
}
}
public ActionResult Edit([Bind(Include = "BusinessEntityID,CreditCardID,ModifiedDate,isDeleted")] PersonCreditCard personCreditCard)
{
if (ModelState.IsValid)
{
db.Entry(personCreditCard).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BusinessEntityID = new SelectList(db.People, "BusinessEntityID", "PersonType", personCreditCard.BusinessEntityID);
ViewBag.CreditCardID = new SelectList(db.CreditCards, "CreditCardID", "CardType", personCreditCard.CreditCardID);
return(View(personCreditCard));
}
public void MapEFToBO()
{
var mapper = new DALPersonCreditCardMapper();
PersonCreditCard entity = new PersonCreditCard();
entity.SetProperties(1, 1, DateTime.Parse("1/1/1987 12:00:00 AM"));
BOPersonCreditCard response = mapper.MapEFToBO(entity);
response.BusinessEntityID.Should().Be(1);
response.CreditCardID.Should().Be(1);
response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
}
public void MapBOToEF()
{
var mapper = new DALPersonCreditCardMapper();
var bo = new BOPersonCreditCard();
bo.SetProperties(1, 1, DateTime.Parse("1/1/1987 12:00:00 AM"));
PersonCreditCard response = mapper.MapBOToEF(bo);
response.BusinessEntityID.Should().Be(1);
response.CreditCardID.Should().Be(1);
response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
}
// GET: PersonCreditCards/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PersonCreditCard personCreditCard = db.PersonCreditCards.Find(id);
if (personCreditCard == null)
{
return(HttpNotFound());
}
return(View(personCreditCard));
}
public bool PersonCreditCardDelete(PersonCreditCard personcreditcard)
{
return(Execute <bool>(dal =>
{
PersonCreditCard personcreditcardDelete = dal.PersonCreditCard.Where(x => x.BusinessEntityID == personcreditcard.BusinessEntityID).FirstOrDefault();
if (personcreditcardDelete != null)
{
dal.PersonCreditCard.DeleteOnSubmit(personcreditcardDelete);
dal.SubmitChanges();
return true;
}
return false;
}));
}
public void MapEFToBOList()
{
var mapper = new DALPersonCreditCardMapper();
PersonCreditCard entity = new PersonCreditCard();
entity.SetProperties(1, 1, DateTime.Parse("1/1/1987 12:00:00 AM"));
List <BOPersonCreditCard> response = mapper.MapEFToBO(new List <PersonCreditCard>()
{
entity
});
response.Count.Should().Be(1);
}
// GET: PersonCreditCards/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PersonCreditCard personCreditCard = db.PersonCreditCards.Find(id);
if (personCreditCard == null)
{
return(HttpNotFound());
}
ViewBag.BusinessEntityID = new SelectList(db.People, "BusinessEntityID", "PersonType", personCreditCard.BusinessEntityID);
ViewBag.CreditCardID = new SelectList(db.CreditCards, "CreditCardID", "CardType", personCreditCard.CreditCardID);
return(View(personCreditCard));
}
// PUT api/awbuildversion/5
public void Put(PersonCreditCard value)
{
var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault();
if (GetActionType.Key != null)
{
if (GetActionType.Value.ToList()[0].Equals("DELETE"))
{
adventureWorks_BC.PersonCreditCardDelete(value);
}
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
{
adventureWorks_BC.PersonCreditCardUpdate(value);
}
}
}
public bool PersonCreditCardUpdate(PersonCreditCard personcreditcard)
{
return(Execute <bool>(dal =>
{
PersonCreditCard personcreditcardUpdate = dal.PersonCreditCard.Where(x => x.BusinessEntityID == personcreditcard.BusinessEntityID).FirstOrDefault();
if (personcreditcardUpdate != null)
{
personcreditcardUpdate.BusinessEntityID = personcreditcard.BusinessEntityID;
personcreditcardUpdate.CreditCardID = personcreditcard.CreditCardID;
personcreditcardUpdate.ModifiedDate = personcreditcard.ModifiedDate;
dal.SubmitChanges();
return true;
}
return false;
}));
}
public async void Get()
{
var mock = new ServiceMockFacade <IPersonCreditCardRepository>();
var record = new PersonCreditCard();
mock.RepositoryMock.Setup(x => x.Get(It.IsAny <int>())).Returns(Task.FromResult(record));
var service = new PersonCreditCardService(mock.LoggerMock.Object,
mock.RepositoryMock.Object,
mock.ModelValidatorMockFactory.PersonCreditCardModelValidatorMock.Object,
mock.BOLMapperMockFactory.BOLPersonCreditCardMapperMock,
mock.DALMapperMockFactory.DALPersonCreditCardMapperMock);
ApiPersonCreditCardResponseModel response = await service.Get(default(int));
response.Should().NotBeNull();
mock.RepositoryMock.Verify(x => x.Get(It.IsAny <int>()));
}
public ActionResult DeleteConfirmed(int id)
{
var res = (from c in db.PersonCreditCards
where c.BusinessEntityID == id
select c).FirstOrDefault();
if (res != null)
{
res.isDeleted = true;
db.SaveChanges();
ViewBag.Message = string.Format("Congrats! Delete success");
}
PersonCreditCard personCreditCard = db.PersonCreditCards.Find(id);
return(View(personCreditCard));
}
// POST api/awbuildversion
public void Post(PersonCreditCard value)
{
adventureWorks_BC.PersonCreditCardAdd(value);
}
public override IndividualCustomer PopulateRecord(SqlDataReader reader)
{
AddressType addressType = new AddressType
{
Name = reader["AddressType"].ToString()
};
CountryRegion country = new CountryRegion
{
Name = reader["CountryRegionName"].ToString()
};
StateProvince state = new StateProvince
{
Name = reader["StateProvinceName"].ToString(),
CountryRegion = country
};
Address _address = new Address
{
AddressLine1 = reader["AddressLine1"].ToString(),
AddressLine2 = reader["AddressLine2"].ToString(),
City = reader["City"].ToString(),
PostalCode = reader["PostalCode"].ToString(),
StateProvince = state
};
BusinessEntityAddress entityAddress = new BusinessEntityAddress
{
Address = _address,
AddressType = addressType
};
EmailAddress emailAddress = new EmailAddress
{
EmailAddress1 = (string)reader["EmailAddress"]
};
PhoneNumberType numberType = new PhoneNumberType
{
Name = reader["PhoneType"].ToString()
};
PersonPhone phone = new PersonPhone
{
PhoneNumber = (string)reader["PhoneNumber"],
PhoneNumberType = numberType
};
CreditCard credit = new CreditCard
{
CreditCardID = Convert.ToInt32((int)reader["CreditCardID"]),
CardType = reader["CardType"].ToString(),
CardNumber = reader["CardNumber"].ToString(),
ExpMonth = Convert.ToByte((byte)reader["ExpMonth"]),
ExpYear = Convert.ToInt16((short)reader["ExpYear"]),
};
PersonCreditCard personCreditCard = new PersonCreditCard
{
CreditCardID = Convert.ToInt32((int)reader["CreditCardID"]),
CreditCard = credit
};
Customer customer = new Customer
{
AccountNumber = reader["AccountNumber"].ToString()
};
return(new IndividualCustomer
{
BusinessEntityID = Convert.ToInt32((int)reader["BusinessEntityID"]),
FirstName = reader["FirstName"].ToString(),
MiddleName = reader["MiddleName"].ToString(),
LastName = reader["LastName"].ToString(),
Suffix = reader["Suffix"].ToString(),
PersonType = reader["PersonType"].ToString(),
NameStyle = (bool)reader["NameStyle"],
Title = reader["Title"].ToString(),
EmailPromotion = Convert.ToInt32((int)reader["EmailPromotion"]),
ModifiedDate = (DateTime)reader["ModifiedDate"],
rowguid = (Guid)reader["rowguid"],
EmailAddress = emailAddress,
PersonPhone = phone,
BusinessEntityAddress = entityAddress,
Customer = customer,
PersonCreditCard = personCreditCard
});
}
// POST api/awbuildversion
public void Post(PersonCreditCard value)
{
adventureWorks_BC.PersonCreditCardAdd(value);
}
