public void DeleteTermsAndCondition(TermsAndCondition termsAndConditionToBeDeleted)
{
//Validate Input
if (termsAndConditionToBeDeleted == null)
{
throw (new ArgumentNullException("termsAndConditionToBeDeleted"));
}
// Validate Primary key value
if (termsAndConditionToBeDeleted.TermsAndConditionsID.IsInvalidKey())
{
BusinessLayerHelper.ThrowErrorForInvalidDataKey("TermsAndConditionsID");
}
OnTermsAndConditionSaving(termsAndConditionToBeDeleted);
OnTermsAndConditionDeleting(termsAndConditionToBeDeleted);
if (termsAndConditionToBeDeleted.EntityState == EntityState.Detached)
{
_DatabaseContext.TermsAndConditions.Attach(termsAndConditionToBeDeleted);
}
_DatabaseContext.TermsAndConditions.DeleteObject(termsAndConditionToBeDeleted);
int numberOfAffectedRows = _DatabaseContext.SaveChanges();
if (numberOfAffectedRows == 0)
{
throw new DataNotUpdatedException("No TermsAndCondition deleted!");
}
OnTermsAndConditionDeleted(termsAndConditionToBeDeleted);
OnTermsAndConditionSaved(termsAndConditionToBeDeleted);
}
public void DeleteTermsAndConditions(List <int> termsAndConditionsIDsToDelete)
{
//Validate Input
foreach (int termsAndConditionsID in termsAndConditionsIDsToDelete)
{
if (termsAndConditionsID.IsInvalidKey())
{
BusinessLayerHelper.ThrowErrorForInvalidDataKey("TermsAndConditionsID");
}
}
List <TermsAndCondition> termsAndConditionsToBeDeleted = new List <TermsAndCondition>();
foreach (int termsAndConditionsID in termsAndConditionsIDsToDelete)
{
TermsAndCondition termsAndCondition = new TermsAndCondition {
TermsAndConditionsID = termsAndConditionsID
};
_DatabaseContext.TermsAndConditions.Attach(termsAndCondition);
_DatabaseContext.TermsAndConditions.DeleteObject(termsAndCondition);
termsAndConditionsToBeDeleted.Add(termsAndCondition);
OnTermsAndConditionDeleting(termsAndCondition);
}
int numberOfAffectedRows = _DatabaseContext.SaveChanges();
if (numberOfAffectedRows != termsAndConditionsIDsToDelete.Count)
{
throw new DataNotUpdatedException("One or more termsAndCondition records have not been deleted.");
}
foreach (TermsAndCondition termsAndConditionToBeDeleted in termsAndConditionsToBeDeleted)
{
OnTermsAndConditionDeleted(termsAndConditionToBeDeleted);
}
}
public void UpdateTermsAndCondition(TermsAndCondition updatedTermsAndCondition)
{
// Validate Parameters
if (updatedTermsAndCondition == null)
{
throw (new ArgumentNullException("updatedTermsAndCondition"));
}
// Validate Primary key value
if (updatedTermsAndCondition.TermsAndConditionsID.IsInvalidKey())
{
BusinessLayerHelper.ThrowErrorForInvalidDataKey("TermsAndConditionsID");
}
// Apply business rules
OnTermsAndConditionSaving(updatedTermsAndCondition);
OnTermsAndConditionUpdating(updatedTermsAndCondition);
//attaching and making ready for parsistance
if (updatedTermsAndCondition.EntityState == EntityState.Detached)
{
_DatabaseContext.TermsAndConditions.Attach(updatedTermsAndCondition);
}
_DatabaseContext.ObjectStateManager.ChangeObjectState(updatedTermsAndCondition, System.Data.EntityState.Modified); //this line makes the code un-testable!
int numberOfAffectedRows = _DatabaseContext.SaveChanges();
if (numberOfAffectedRows == 0)
{
throw new DataNotUpdatedException("No termsAndCondition updated!");
}
//Apply business workflow
OnTermsAndConditionUpdated(updatedTermsAndCondition);
OnTermsAndConditionSaved(updatedTermsAndCondition);
}
public virtual int CreateNewTermsAndCondition(TermsAndCondition newTermsAndCondition)
{
// Validate Parameters
if (newTermsAndCondition == null)
{
throw (new ArgumentNullException("newTermsAndCondition"));
}
// Apply business rules
OnTermsAndConditionSaving(newTermsAndCondition);
OnTermsAndConditionCreating(newTermsAndCondition);
_DatabaseContext.TermsAndConditions.AddObject(newTermsAndCondition);
int numberOfAffectedRows = _DatabaseContext.SaveChanges();
if (numberOfAffectedRows == 0)
{
throw new DataNotUpdatedException("No termsAndCondition created!");
}
// Apply business workflow
OnTermsAndConditionCreated(newTermsAndCondition);
OnTermsAndConditionSaved(newTermsAndCondition);
return(newTermsAndCondition.TermsAndConditionsID);
}
public List <TermsAndCondition> GetTermsAndCondition()
{
List <TermsAndCondition> termsAndConditions = new List <TermsAndCondition>();
TermsAndCondition objTermsAndConditions;
string vComTxt = @"SELECT ConditionCode,ConditionValue,Condition,ValueType,(case when ValueType=1 then 'Fixed' else 'Percentage' end)valuetypenm
FROM PMS_TermsAndCondition";
SqlConnection connection = _supplierDbContext.GetConn();
connection.Open();
SqlDataReader dr;
SqlCommand objDbCommand = new SqlCommand(vComTxt, connection);
dr = objDbCommand.ExecuteReader();
while (dr.Read())
{
objTermsAndConditions = new TermsAndCondition();
objTermsAndConditions.ConditionCode_PK = dr["ConditionCode"].ToString();
objTermsAndConditions.ConditionValue = Convert.ToDecimal(dr["ConditionValue"].ToString());
objTermsAndConditions.Condition = dr["Condition"].ToString();
objTermsAndConditions.ValueType = Convert.ToInt16(dr["ValueType"].ToString());
objTermsAndConditions.ValueTypeName_VW = dr["valuetypenm"].ToString();
termsAndConditions.Add(objTermsAndConditions);
}
return(termsAndConditions);
}
bool AreFieldsValid()
{
bool isFirstNameValid = FirstName.Validate();
bool isLastNameValid = LastName.Validate();
bool isEmailValid = Email.Validate();
bool isPasswordValid = Password.Validate();
bool isTermsAndConditionValid = TermsAndCondition.Validate();
return(isFirstNameValid && isLastNameValid && isEmailValid && isPasswordValid && isTermsAndConditionValid);
}
private bool AreFieldsValid()
{
bool isFirstNameValid = FirstName.Validate();
bool isLastNameValid = LastName.Validate();
bool isBirthDayValid = BirthDay.Validate();
bool isPhoneNumberValid = PhoneNumber.Validate();
bool isEmailValid = Email.Validate();
bool isPasswordValid = Password.Validate();
bool isTermsAndConditionValid = TermsAndCondition.Validate();
return(isFirstNameValid && isLastNameValid && isBirthDayValid &&
isPhoneNumberValid && isEmailValid && isPasswordValid &&
isTermsAndConditionValid);
}
/// <summary>
/// Deprecated Method for adding a new object to the TermsAndConditions EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToTermsAndConditions(TermsAndCondition termsAndCondition)
{
base.AddObject("TermsAndConditions", termsAndCondition);
}
partial void OnTermsAndConditionDeleted(TermsAndCondition termsAndCondition);
partial void OnTermsAndConditionSaved(TermsAndCondition termsAndCondition);
partial void OnTermsAndConditionUpdated(TermsAndCondition termsAndCondition);
partial void OnTermsAndConditionCreated(TermsAndCondition termsAndCondition);
