public static string UpdateCustomer(int ID, string FirstName, string LastName, string Phone, string City)
{
try
{
DataGateWay access = new DataGateWay(connectionName);
string sql = @"use InlandMarina
UPDATE Customer
SET FirstName = @FirstName,
LastName = @LastName,
Phone = @Phone,
City = @City
WHERE ID = @Id";
IDataParameter IdPar = access.CreateParameter;
IdPar.ParameterName = "@Id";
IdPar.DbType = DbType.Int32;
IdPar.Value = ID;
IDataParameter firstnamePar = access.CreateParameter;
firstnamePar.ParameterName = "@FirstName";
firstnamePar.DbType = DbType.String;
firstnamePar.Value = FirstName;
IDataParameter lastnamePar = access.CreateParameter;
lastnamePar.ParameterName = "@LastName";
lastnamePar.DbType = DbType.String;
lastnamePar.Value = LastName;
IDataParameter PhonePar = access.CreateParameter;
PhonePar.ParameterName = "@Phone";
PhonePar.DbType = DbType.String;
PhonePar.Value = Phone;
IDataParameter CityPar = access.CreateParameter;
CityPar.ParameterName = "@City";
CityPar.DbType = DbType.String;
CityPar.Value = City;
IDataParameter[] pars =
new IDataParameter[] { IdPar, firstnamePar, lastnamePar, PhonePar, CityPar };
access.ExecuteNonQuery(sql, pars, CommandType.Text);
return("Success");
}
catch
{
return("Update failed ! Please contact Administrator !");
}
}
public static string UpdateBoat(int ID, string RegistrationNumber, string Manufacturer, int ModelYear, int Length)
{
try
{
DataGateWay access = new DataGateWay(connectionName);
string sql = @"use InlandMarina
UPDATE Boat
SET RegistrationNumber = @RegistrationNumber,
Manufacturer = @LastName,
ModelYear = @Phone,
Length = @City
WHERE ID = @ID";
IDataParameter RegisterNoPar = access.CreateParameter;
RegisterNoPar.ParameterName = "@RegistrationNumber";
RegisterNoPar.DbType = DbType.String;
RegisterNoPar.Value = RegistrationNumber;
IDataParameter ManufacturerPar = access.CreateParameter;
ManufacturerPar.ParameterName = "@Manufacturer";
ManufacturerPar.DbType = DbType.String;
ManufacturerPar.Value = Manufacturer;
IDataParameter YearPar = access.CreateParameter;
YearPar.ParameterName = "@ModelYear";
YearPar.DbType = DbType.Int32;
YearPar.Value = ModelYear;
IDataParameter LengthPar = access.CreateParameter;
LengthPar.ParameterName = "@Length";
LengthPar.DbType = DbType.Int32;
LengthPar.Value = Length;
IDataParameter CustIDPar = access.CreateParameter;
CustIDPar.ParameterName = "@ID";
CustIDPar.DbType = DbType.Int32;
CustIDPar.Value = ID;
IDataParameter[] pars =
new IDataParameter[] { RegisterNoPar, ManufacturerPar, YearPar, LengthPar, CustIDPar };
access.ExecuteNonQuery(sql, pars, CommandType.Text);
return("Success");
}
catch
{
return("Failed to update record ! Please contact Administrator !");
}
}
public static string AddLease(DateTime startDate, DateTime endDate, int slipID, int customerID, int leaseTypeID)
{
try
{
DataGateWay access = new DataGateWay(connectionName);
string sql = @"use InlandMarina
INSERT INTO Lease(StartDate,EndDate,SlipID,CustomerID,LeaseTypeID)
VALUES(@StartDate,@EndDate,@SlipID,@CustomerID,@LeaseTypeID)";
IDataParameter StartDatePar = access.CreateParameter;
StartDatePar.ParameterName = "@StartDate";
StartDatePar.DbType = DbType.DateTime;
StartDatePar.Value = startDate;
IDataParameter EndDatePar = access.CreateParameter;
EndDatePar.ParameterName = "@EndDate";
EndDatePar.DbType = DbType.DateTime;
EndDatePar.Value = endDate;
IDataParameter SlipPar = access.CreateParameter;
SlipPar.ParameterName = "@SlipID";
SlipPar.DbType = DbType.Int32;
SlipPar.Value = slipID;
IDataParameter CustomerIDPar = access.CreateParameter;
CustomerIDPar.ParameterName = "@CustomerID";
CustomerIDPar.DbType = DbType.Int32;
CustomerIDPar.Value = customerID;
IDataParameter LeaseTypePar = access.CreateParameter;
LeaseTypePar.ParameterName = "@LeaseTypeID";
LeaseTypePar.DbType = DbType.Int32;
LeaseTypePar.Value = leaseTypeID;
IDataParameter[] pars =
new IDataParameter[] { StartDatePar, EndDatePar, SlipPar, CustomerIDPar, LeaseTypePar };
access.ExecuteNonQuery(sql, pars, CommandType.Text);
return("Success");
}
catch
{
return("Failed to add record ! Please contact Administrator !");
}
}
public static string AddBoat(string registerNumber, string manufacturer, int modelYear, int length, int customerID)
{
try
{
DataGateWay access = new DataGateWay(connectionName);
string sql = @"use InlandMarina
INSERT INTO Boat(RegistrationNumber,Manufacturer,ModelYear,Length,CustomerID)
VALUES(@RegistrationNumber,@Manufacturer,@ModelYear,@Length,@CustomerID)";
IDataParameter RegisterNoPar = access.CreateParameter;
RegisterNoPar.ParameterName = "@RegistrationNumber";
RegisterNoPar.DbType = DbType.String;
RegisterNoPar.Value = registerNumber;
IDataParameter ManufacturerPar = access.CreateParameter;
ManufacturerPar.ParameterName = "@Manufacturer";
ManufacturerPar.DbType = DbType.String;
ManufacturerPar.Value = manufacturer;
IDataParameter YearPar = access.CreateParameter;
YearPar.ParameterName = "@ModelYear";
YearPar.DbType = DbType.Int32;
YearPar.Value = modelYear;
IDataParameter LengthPar = access.CreateParameter;
LengthPar.ParameterName = "@Length";
LengthPar.DbType = DbType.Int32;
LengthPar.Value = length;
IDataParameter CustIDPar = access.CreateParameter;
CustIDPar.ParameterName = "@CustomerID";
CustIDPar.DbType = DbType.Int32;
CustIDPar.Value = customerID;
IDataParameter[] pars =
new IDataParameter[] { RegisterNoPar, ManufacturerPar, YearPar, LengthPar, CustIDPar };
access.ExecuteNonQuery(sql, pars, CommandType.Text);
return("Success");
}
catch
{
return("Failed to add record ! Please contact Administrator !");
}
}
public static string UpdateAuthorize(string username, string password, int CustomerID)
{
try
{
DataGateWay access = new DataGateWay(connectionName);
string sql = @"use InlandMarina
UPDATE Authorize
SET UserName = @UserName,
Password = @Password
WHERE CustomerID = @CustomerID";
IDataParameter UserNamePar = access.CreateParameter;
UserNamePar.ParameterName = "@UserName";
UserNamePar.DbType = DbType.String;
UserNamePar.Value = username;
IDataParameter PasswordPar = access.CreateParameter;
PasswordPar.ParameterName = "@Password";
PasswordPar.DbType = DbType.String;
PasswordPar.Value = password;
IDataParameter CustomerPar = access.CreateParameter;
CustomerPar.ParameterName = "@CustomerID";
CustomerPar.DbType = DbType.Int32;
CustomerPar.Value = CustomerID;
IDataParameter[] pars =
new IDataParameter[] { UserNamePar, PasswordPar, CustomerPar };
access.ExecuteNonQuery(sql, pars, CommandType.Text);
return("Success");
}
catch
{
return("Failed to update record ! Please contact Administrator !");
}
}