public static void Update(PersonModel personModel)
{
//todo
}
public static void Update(PersonModel personModel)
{
using (var connection = SqlHelper.GetConnection())
{
var sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandText = @"UPDATE People
SET FirstName = @FirstName, LastName = @LastName,Phone = @Phone, Email = @Email,Created = @Created, Updated = @Updated
WHERE ID = @ID" ;
var sqlFirstNameParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.FirstName,
ParameterName = "@FirstName"
};
var sqlLastNameParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.LastName,
ParameterName = "@LastName"
};
var sqlPhoneParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.Phone,
ParameterName = "@Phone"
};
var sqlEmailParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.Email,
ParameterName = "@Email"
};
var sqlCreatedDateParam = new SqlParameter
{
DbType = System.Data.DbType.DateTime,
Value = personModel.Created,
ParameterName = "@Created"
};
var sqlUpdatedDateParam = new SqlParameter
{
DbType = System.Data.DbType.DateTime,
Value = DateTime.Now,
ParameterName = "@Updated"
};
var sqlIDParam = new SqlParameter
{
DbType = System.Data.DbType.Int32,
Value = personModel.ID,
ParameterName = "@ID"
};
sqlCommand.Parameters.Add(sqlFirstNameParam);
sqlCommand.Parameters.Add(sqlLastNameParam);
sqlCommand.Parameters.Add(sqlPhoneParam);
sqlCommand.Parameters.Add(sqlEmailParam);
sqlCommand.Parameters.Add(sqlCreatedDateParam);
sqlCommand.Parameters.Add(sqlUpdatedDateParam);
sqlCommand.Parameters.Add(sqlIDParam);
sqlCommand.ExecuteScalar();
}
return;
}
public static int Update(PersonModel personModel)
{
using (var connection = SqlHelper.GetConnection())
{
var sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandText = @"Update People set
FirstName = @FirstName,
LastName = @LastName,
Phone = @Phone,
Email = @Email,
Updated = @Updated
WHERE ID = @id;" ;
var sqlIDParam = new SqlParameter
{
DbType = System.Data.DbType.Int32,
Value = personModel.ID,
ParameterName = "@id"
};
var sqlFirstNameParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.FirstName,
ParameterName = "@FirstName"
};
var sqlLastNameParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.LastName,
ParameterName = "@LastName"
};
var sqlPhoneParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.Phone,
ParameterName = "@Phone"
};
var sqlEmailParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.Email,
ParameterName = "@Email"
};
var sqlUpdatedDateParam = new SqlParameter
{
DbType = System.Data.DbType.DateTime,
Value = DateTime.Now,
ParameterName = "@Updated"
};
sqlCommand.Parameters.Add(sqlIDParam);
sqlCommand.Parameters.Add(sqlFirstNameParam);
sqlCommand.Parameters.Add(sqlLastNameParam);
sqlCommand.Parameters.Add(sqlPhoneParam);
sqlCommand.Parameters.Add(sqlEmailParam);
sqlCommand.Parameters.Add(sqlUpdatedDateParam);
int id = (int)sqlCommand.ExecuteNonQuery();
return(id);
}
}
public static void Add(PersonModel personModel)
{
using (var connection = SqlHelper.GetConnection())
{
var sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
if (personModel.Email != null)
{
sqlCommand.CommandText = @"Insert INTO People (FirstName, LastName, Phone, Email, Created, Updated)
VALUES (@FirstName, @LastName, @Phone, @Email, @Created, @Updated);" ;
var sqlEmailParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.Email,
ParameterName = "@Email"
};
sqlCommand.Parameters.Add(sqlEmailParam);
}
sqlCommand.CommandText = @"Insert INTO People (FirstName, LastName, Phone, Created, Updated)
VALUES (@FirstName, @LastName, @Phone,@Created, @Updated);" ;
var sqlFirstNameParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.FirstName,
ParameterName = "@FirstName"
};
var sqlLastNameParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.LastName,
ParameterName = "@LastName"
};
var sqlPhoneParam = new SqlParameter
{
DbType = System.Data.DbType.AnsiString,
Value = personModel.Phone,
ParameterName = "@Phone"
};
var sqlCreatedDateParam = new SqlParameter
{
DbType = System.Data.DbType.DateTime,
Value = personModel.Created,
ParameterName = "@Created"
};
var sqlUpdatedDateParam = new SqlParameter
{
DbType = System.Data.DbType.DateTime,
Value = personModel.Updated,
ParameterName = "@Updated"
};
sqlCommand.Parameters.Add(sqlFirstNameParam);
sqlCommand.Parameters.Add(sqlLastNameParam);
sqlCommand.Parameters.Add(sqlPhoneParam);
sqlCommand.Parameters.Add(sqlCreatedDateParam);
sqlCommand.Parameters.Add(sqlUpdatedDateParam);
sqlCommand.ExecuteNonQuery();
}
}
