public override void Save()
{
DriverList driverList = DriverList.getInstance();
string dateBirthSql = string.Empty;
if (DateBirth != string.Empty)
{
dateBirthSql = string.Concat(_dateBirth.Year.ToString(), "-", _dateBirth.Month.ToString(), "-",
_dateBirth.Day.ToString());
}
string dateStopNotificationSql = string.Empty;
if (DateStopNotification.Year != 1)
{
dateStopNotificationSql = string.Concat(DateStopNotification.Year.ToString(), "-",
DateStopNotification.Month.ToString(), "-", DateStopNotification.Day.ToString());
}
int id;
int.TryParse(Provider.Insert("Driver", Id, GetName(NameType.Full), Region.Id, dateBirthSql, _mobile, email,
_fired, _expSince, PositionID,
DeptID, Login, OwnerID, suppyAddress, SexIndex, _decret,
dateStopNotificationSql, _number, _isDriver, _from1C), out id);
Id = id;
driverList.Add(this);
}
/// <summary>
/// This method provides List of Drivers available in Database.
/// </summary>
/// <param name="strWhere">Specifies condition for retrieving records.</param>
/// <returns>Collection of Driver Objects.</returns>
public static DriverList GetList(string strWhere)
{
DriverList objList = null;
string strSql = "SELECT * FROM DRIVERMASTER";
if (strWhere != string.Empty)
{
strSql = strSql + " WHERE " + strWhere;
}
strSql += " ORDER BY NAME";
using (SqlConnection Conn = new SqlConnection(General.GetSQLConnectionString()))
{
using (SqlCommand objCmd = new SqlCommand())
{
objCmd.Connection = Conn;
objCmd.CommandType = CommandType.Text;
objCmd.CommandText = strSql;
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
using (SqlDataReader oReader = objCmd.ExecuteReader())
{
if (oReader.HasRows)
{
objList = new DriverList();
while (oReader.Read())
{
objList.Add(FillDataRecord(oReader));
}
}
oReader.Close();
oReader.Dispose();
}
}
}
return(objList);
}