public static Common.Models.Office.Office GetOffice(DataRow row)
{
Common.Models.Office.Office office = new Common.Models.Office.Office();
office.OfficeId = Conversion.TryCastInteger(ConversionHelper.GetColumnValue(row, "office_id"));
office.OfficeCode = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "office_code"));
office.OfficeName = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "office_name"));
office.Nickname = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "nick_name"));
office.RegistrationDate = Conversion.TryCastDate(ConversionHelper.GetColumnValue(row, "registration_date"));
office.CurrencyCode = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "currency_code"));
office.AddressLine1 = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "address_line_1"));
office.AddressLine2 = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "address_line_2"));
office.Street = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "street"));
office.City = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "city"));
office.State = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "state"));
office.ZipCode = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "zip_code"));
office.Country = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "country"));
office.Phone = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "phone"));
office.Fax = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "fax"));
office.Email = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "email"));
office.Url = new Uri(Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "url")), UriKind.RelativeOrAbsolute);
office.RegistrationNumber = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "registration_number"));
office.PanNumber = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "pan_number"));
office.ParentOfficeId = Conversion.TryCastInteger(ConversionHelper.GetColumnValue(row, "parent_office_id"));
office.ParentOffice = GetOffice(office.ParentOfficeId);
return office;
}
public static Common.Models.Office.Office GetOffice(int? officeId)
{
Common.Models.Office.Office office = new Common.Models.Office.Office();
if (officeId != null && officeId != 0)
{
const string sql = "SELECT * FROM office.offices WHERE office_id=@OfficeId;";
using (NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.AddWithValue("@OfficeId", officeId);
using (DataTable table = DbOperations.GetDataTable(command))
{
if (table != null)
{
if (table.Rows.Count.Equals(1))
{
office = GetOffice(table.Rows[0]);
}
}
}
}
}
return office;
}
public static MixERP.Net.Common.Models.Office.Office GetOffice(int? officeId)
{
MixERP.Net.Common.Models.Office.Office office = new Common.Models.Office.Office();
if (officeId != null || officeId != 0)
{
string sql = "SELECT * FROM office.offices WHERE office_id=@OfficeId;";
using (NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.Add("@OfficeId", officeId);
using (DataTable table = MixERP.Net.DBFactory.DBOperations.GetDataTable(command))
{
if (table != null)
{
if (table.Rows.Count.Equals(1))
{
office = GetOffice(table.Rows[0]);
}
}
}
}
}
return office;
}
private static Common.Models.Office.Office GetOffice(DataRow row)
{
Common.Models.Office.Office office = new Common.Models.Office.Office();
office.OfficeId = Conversion.TryCastInteger(DataRowHelper.GetColumnValue(row, "office_id"));
office.OfficeCode = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "office_code"));
office.OfficeName = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "office_name"));
office.Nickname = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "nick_name"));
office.RegistrationDate = Conversion.TryCastDate(DataRowHelper.GetColumnValue(row, "registration_date"));
office.CurrencyCode = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "currency_code"));
office.AddressLine1 = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "address_line_1"));
office.AddressLine2 = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "address_line_2"));
office.Street = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "street"));
office.City = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "city"));
office.State = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "state"));
office.ZipCode = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "zip_code"));
office.Country = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "country"));
office.Phone = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "phone"));
office.Fax = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "fax"));
office.Email = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "email"));
office.Url = new Uri(Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "url")),
UriKind.RelativeOrAbsolute);
office.RegistrationNumber =
Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "registration_number"));
office.PanNumber = Conversion.TryCastString(DataRowHelper.GetColumnValue(row, "pan_number"));
office.ParentOfficeId = Conversion.TryCastInteger(DataRowHelper.GetColumnValue(row, "parent_office_id"));
office.ParentOffice = GetOffice(office.ParentOfficeId);
return(office);
}
private static Common.Models.Office.Office GetOffice(int?officeId)
{
Common.Models.Office.Office office = new Common.Models.Office.Office();
if (officeId != null && officeId != 0)
{
const string sql = "SELECT * FROM office.offices WHERE office_id=@OfficeId;";
using (NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.AddWithValue("@OfficeId", officeId);
using (DataTable table = DbOperations.GetDataTable(command))
{
if (table != null)
{
if (table.Rows.Count.Equals(1))
{
office = GetOffice(table.Rows[0]);
}
}
}
}
}
return(office);
}
private static Collection <Common.Models.Office.Office> GetOffices(DataTable table)
{
Collection <Common.Models.Office.Office> officeCollection = new Collection <Common.Models.Office.Office>();
if (table == null || table.Rows.Count.Equals(0))
{
return(officeCollection);
}
foreach (DataRow row in table.Rows)
{
if (row != null)
{
Common.Models.Office.Office office = GetOffice(row);
officeCollection.Add(office);
}
}
return(officeCollection);
}
