public string Insert(int Supplier_ID, string Address, string ZP, string SP, string City, string Country)
{
Dispatch_Location _Dispatch_Location = new Dispatch_Location();
_Dispatch_Location.Supplier_ID = Supplier_ID;
_Dispatch_Location.Address = Address;
_Dispatch_Location.ZP = ZP;
_Dispatch_Location.SP = SP;
_Dispatch_Location.City = City;
_Dispatch_Location.Country = Country;
_Dispatch_Location.CreatedBy = Session["User"].ToString();
return(Dispatch_Location_DA.Insert(_Dispatch_Location));
}
public Dispatch_Location Get_Dispatch_Location_By_Id(int ID)
{
Dispatch_Location _Dispatch_Location = new Dispatch_Location();
DataTable dt = Dispatch_Location_DA.Get_Dispatch_Location_By_Id(ID);
foreach (DataRow row in dt.Rows)
{
ID = int.Parse(row["ID"].ToString());
_Dispatch_Location.Supplier_ID = int.Parse(row["Supplier_ID"].ToString());
_Dispatch_Location.Address = row["Address"].ToString();
_Dispatch_Location.ZP = row["Zip/Postal"].ToString();
_Dispatch_Location.SP = row["State/Province"].ToString();
_Dispatch_Location.City = row["City"].ToString();
_Dispatch_Location.Country = row["Country"].ToString();
}
return(_Dispatch_Location);
}
public static string Insert(Dispatch_Location _Dispatch_Location)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_insertDispatch_Location";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@Supplier_ID";
param.Value = _Dispatch_Location.Supplier_ID;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Address";
param.Value = _Dispatch_Location.Address;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@ZP";
param.Value = _Dispatch_Location.ZP;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@SP";
param.Value = _Dispatch_Location.SP;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@City";
param.Value = _Dispatch_Location.City;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Country";
param.Value = _Dispatch_Location.Country;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@CreatedBy";
param.Value = _Dispatch_Location.CreatedBy;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
string Return = command.Parameters["@Return"].Value.ToString();
return Return;
}
public Dispatch_Location Get_Dispatch_Location_By_Id(int ID)
{
Dispatch_Location _Dispatch_Location = new Dispatch_Location();
DataTable dt = Dispatch_Location_DA.Get_Dispatch_Location_By_Id(ID);
foreach (DataRow row in dt.Rows)
{
ID = int.Parse(row["ID"].ToString());
_Dispatch_Location.Supplier_ID = int.Parse(row["Supplier_ID"].ToString());
_Dispatch_Location.Address = row["Address"].ToString();
_Dispatch_Location.ZP = row["Zip/Postal"].ToString();
_Dispatch_Location.SP = row["State/Province"].ToString();
_Dispatch_Location.City = row["City"].ToString();
_Dispatch_Location.Country = row["Country"].ToString();
}
return _Dispatch_Location;
}
public string Update(int ID, int Supplier_ID, string Address, string ZP, string SP, string City, string Country)
{
Dispatch_Location _Dispatch_Location = new Dispatch_Location();
_Dispatch_Location.ID = ID;
_Dispatch_Location.Supplier_ID = Supplier_ID;
_Dispatch_Location.Address = Address;
_Dispatch_Location.ZP = ZP;
_Dispatch_Location.SP = SP;
_Dispatch_Location.City = City;
_Dispatch_Location.Country = Country;
_Dispatch_Location.UpdatedBy = Session["User"].ToString();
return Dispatch_Location_DA.Update(_Dispatch_Location);
}
