/// <summary>
/// Creates a new instance of the ViewAuditoriaListaVerificacionDetalleCross class and populates it with data from the specified SqlDataReader.
/// </summary>
private static ViewAuditoriaListaVerificacionDetalleCrossInfo MakeViewAuditoriaListaVerificacionDetalleCross(SqlDataReader dataReader)
{
ViewAuditoriaListaVerificacionDetalleCrossInfo viewAuditoriaListaVerificacionDetalleCross = new ViewAuditoriaListaVerificacionDetalleCrossInfo();
if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleCargoId) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionDetalleCargoId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleCargoId);
if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId);
if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId);
if (dataReader.IsDBNull(CargoId) == false)
viewAuditoriaListaVerificacionDetalleCross.CargoId = dataReader.GetInt32(CargoId);
if (dataReader.IsDBNull(Cargo) == false)
viewAuditoriaListaVerificacionDetalleCross.Cargo = dataReader.GetString(Cargo);
if (dataReader.IsDBNull(Activo) == false)
viewAuditoriaListaVerificacionDetalleCross.Activo = dataReader.GetBoolean(Activo);
if (dataReader.IsDBNull(AuditoriaPunto) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaPunto = dataReader.GetString(AuditoriaPunto);
if (dataReader.IsDBNull(AuditoriaControl) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaControl = dataReader.GetString(AuditoriaControl);
if (dataReader.IsDBNull(PuntajeRequerido) == false)
viewAuditoriaListaVerificacionDetalleCross.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido);
if (dataReader.IsDBNull(Empresa) == false)
viewAuditoriaListaVerificacionDetalleCross.Empresa = dataReader.GetString(Empresa);
if (dataReader.IsDBNull(Orden) == false)
viewAuditoriaListaVerificacionDetalleCross.Orden = dataReader.GetByte(Orden);
return viewAuditoriaListaVerificacionDetalleCross;
}
/// <summary>
/// Creates a new instance of the ViewSeguridadUsuario class and populates it with data from the specified SqlDataReader.
/// </summary>
private static ViewSeguridadUsuarioInfo MakeViewSeguridadUsuario(SqlDataReader dataReader)
{
ViewSeguridadUsuarioInfo viewSeguridadUsuario = new ViewSeguridadUsuarioInfo();
if (dataReader.IsDBNull(SeguridadUsuarioId) == false)
viewSeguridadUsuario.SeguridadUsuarioId = dataReader.GetInt32(SeguridadUsuarioId);
if (dataReader.IsDBNull(SeguridadRolId) == false)
viewSeguridadUsuario.SeguridadRolId = dataReader.GetInt32(SeguridadRolId);
if (dataReader.IsDBNull(Rol) == false)
viewSeguridadUsuario.Rol = dataReader.GetString(Rol);
if (dataReader.IsDBNull(NombreUsuario) == false)
viewSeguridadUsuario.NombreUsuario = dataReader.GetString(NombreUsuario);
if (dataReader.IsDBNull(Nombres) == false)
viewSeguridadUsuario.Nombres = dataReader.GetString(Nombres);
if (dataReader.IsDBNull(Apellidos) == false)
viewSeguridadUsuario.Apellidos = dataReader.GetString(Apellidos);
if (dataReader.IsDBNull(PaswordHash) == false)
viewSeguridadUsuario.PaswordHash = dataReader.GetString(PaswordHash);
if (dataReader.IsDBNull(Salt) == false)
viewSeguridadUsuario.salt = dataReader.GetString(Salt);
if (dataReader.IsDBNull(Activo) == false)
viewSeguridadUsuario.Activo = dataReader.GetBoolean(Activo);
if (dataReader.IsDBNull(NombreCompleto) == false)
viewSeguridadUsuario.NombreCompleto = dataReader.GetString(NombreCompleto);
return viewSeguridadUsuario;
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT ServiceID, sUrl, sNamespace, sClassname, APName, sDescription, sStatus, sCreateDatetime, ENCRYPTED FROM WebserviceData WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_serviceID = reader.GetString(0);
_sUrl = reader.GetString(1);
_sNamespace = reader.GetString(2);
_sClassname = reader.GetString(3);
_aPName = reader.GetString(4);
_sDescription = reader.GetString(5);
_sStatus = reader.GetBoolean(6);
_sCreateDatetime = reader.GetDateTime(7);
_eNCRYPTED = reader.GetBoolean(8);
}
reader.Close();
}
}
public void FillWorkplace(QC.SqlConnection connection, Workplaces workplace)
{
using (var command = new QC.SqlCommand())
{
command.Connection = connection;
command.CommandType = DT.CommandType.Text;
command.CommandText = @"
SELECT *
FROM Workplaces
WHERE workplace_id = " + workplace.workplace_id + ";";
QC.SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
workplace.workplace_name = reader.SafeGetString(1);
workplace.active_operator = reader.SafeGetInt(2);
workplace.active_maintenance = reader.SafeGetInt(3);
workplace.active_engineer = reader.SafeGetInt(4);
workplace.active_reference = reader.SafeGetString(5);
workplace.sibling_workplace = reader.SafeGetInt(6);
workplace.sibling_workplace_name = reader.SafeGetString(7);
workplace.workplace_unique = reader.GetBoolean(8);
workplace.workplace_exclusive = reader.GetBoolean(9);
}
reader.Close();
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT GroupID, AccountID, Name, Description, Password, Startup, PWLastUpdateTime, PWType, CreateTime, dModifyTime, iFailTimes, dLockTime, cRoleID, AD_CheckFlag, cCallID, cPWD FROM SecurityUserAccount WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_groupID = reader.GetString(0);
_accountID = reader.GetString(1);
_name = reader.GetString(2);
_description = reader.GetString(3);
//_password = reader.GetString(4);
_password = (byte[])reader[4];
_startup = reader.GetBoolean(5);
_pWLastUpdateTime = reader.GetDateTime(6);
_pWType = reader.GetInt16(7);
_createTime = reader.GetDateTime(8);
_dModifyTime = reader.GetDateTime(9);
_iFailTimes = reader.GetInt16(10);
_dLockTime = reader.GetDateTime(11);
_cRoleID = reader.GetInt16(12);
_aD_CheckFlag = reader.GetBoolean(13);
_cCallID = reader.GetString(14);
_cPWD = reader.GetString(15);
}
reader.Close();
}
}
/// <summary>
/// 根据sqldatareader进行获取模型
/// </summary>
/// <param name="sdr"></param>
/// <returns></returns>
public T_Member GetModelBySDR(SqlDataReader sdr)
{
T_Member t_m = null;
if (sdr.Read())
{
t_m = new T_Member();
t_m.F_Id = sdr.GetInt32(0);
t_m.F_Email = sdr.GetString(1);
t_m.F_Password = sdr.GetString(2);
t_m.F_Sex = sdr.GetBoolean(3);
t_m.F_NickName = sdr.GetString(4);
t_m.F_Headpic = sdr.GetString(5);
t_m.F_SecurityPassWord = sdr.GetString(6);
t_m.F_Alipay = sdr.GetString(7);
t_m.F_Issues = sdr.GetString(8);
t_m.F_Answer = sdr.GetString(9);
t_m.F_InitPassWord = sdr.GetString(10);
t_m.F_Mobile = sdr.GetString(11);
t_m.F_QQ = sdr.GetString(12);
t_m.F_Level = sdr.GetInt32(13);
t_m.F_Gold = sdr.GetInt32(14);
t_m.F_Diamond = sdr.GetInt32(15);
t_m.F_VIP = sdr.GetBoolean(16);
t_m.F_KEY = sdr.GetString(17);
t_m.F_Status = sdr.GetInt32(18);
t_m.F_CreateDate = sdr.GetDateTime(19);
}
return t_m;
}
///<summary></summary>
protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr)
{
if (dr != null && !dr.IsClosed)
{
#region Read Each Field
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
m_Current.Id = dr.GetInt32(dr.GetOrdinal("Id"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Title")))
{
m_Current.Title = dr.GetString(dr.GetOrdinal("Title"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Body")))
{
m_Current.Body = dr.GetString(dr.GetOrdinal("Body"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ShortDesc")))
{
m_Current.ShortDesc = dr.GetString(dr.GetOrdinal("ShortDesc"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Description")))
{
m_Current.Description = dr.GetString(dr.GetOrdinal("Description"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Meta")))
{
m_Current.Meta = dr.GetString(dr.GetOrdinal("Meta"));
}
if (!dr.IsDBNull(dr.GetOrdinal("UrlSlug")))
{
m_Current.UrlSlug = dr.GetString(dr.GetOrdinal("UrlSlug"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Published")))
{
m_Current.Published = dr.GetBoolean(dr.GetOrdinal("Published"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PostedOn")))
{
m_Current.PostedOn = dr.GetDateTime(dr.GetOrdinal("PostedOn"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Modified")))
{
m_Current.Modified = dr.GetDateTime(dr.GetOrdinal("Modified"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Category")))
{
m_Current.Category = dr.GetString(dr.GetOrdinal("Category"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Enabled")))
{
m_Current.Enabled = dr.GetBoolean(dr.GetOrdinal("Enabled"));
}
#endregion
ExistsInDB = true;
Mode = EditMode.None;
SetOriginalValues();
}
}
// CHECK IF SALES PERSON EXIST IN DATBASE
public static string CheckSalesPersonLogIn(SqlDataReader dr)
{
bool noExist = true;
bool isActive = true;
string clear = null;
while (dr.Read())
{
clear = dr.GetString(0);
isActive = dr.GetBoolean(5);
noExist = false;
}
if (!isActive)
{
MessageBox.Show("Sorry, you are fired!", "LOL", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
else if (noExist)
{
MessageBox.Show("Not in the register.", "Unregistered Sales Person", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
else
{
return clear;
}
}
public List <Employee> GetEmployeeList()
{
List <Employee> employeeList = new List <Employee>();
Dao dao = new Dao();
string sqlStatement = "SELECT EmployeeID, EmployeeName, Gender, Position, StartDate, Address, PhoneNumber FROM Employee";
System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement);
if (reader == null)
{
return(null);
}
while (reader.Read())
{
int id = reader.GetInt32(0);
string name = reader.GetString(1);
bool gender = reader.GetBoolean(2);
string position = reader.GetString(3);
DateTime date = reader.GetDateTime(4);
string address = reader.GetString(5);
string phone = reader.GetString(6);
employeeList.Add(new Employee(id, name, gender, position, date, address, phone));
}
dao.Con.Close();
return(employeeList);
}
///<summary></summary>
protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr)
{
if (dr != null && !dr.IsClosed)
{
#region Read Each Field
if (!dr.IsDBNull(dr.GetOrdinal("ImageId")))
{
m_Current.ImageId = dr.GetInt32(dr.GetOrdinal("ImageId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("FileName")))
{
m_Current.FileName = dr.GetString(dr.GetOrdinal("FileName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Extension")))
{
m_Current.Extension = dr.GetString(dr.GetOrdinal("Extension"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ProjectFileDirectory")))
{
m_Current.ProjectFileDirectory = dr.GetString(dr.GetOrdinal("ProjectFileDirectory"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Description")))
{
m_Current.Description = dr.GetString(dr.GetOrdinal("Description"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Enabled")))
{
m_Current.Enabled = dr.GetBoolean(dr.GetOrdinal("Enabled"));
}
#endregion
ExistsInDB = true;
Mode = EditMode.None;
SetOriginalValues();
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT appname, AccountID, deviceid, pushid, phonetype, status, createdatetime, PHONE_OS, PHONE_NAME, PHONE_MODEL, updatedatetime FROM MobileDeviceData WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_appname = reader.GetString(0);
_accountID = reader.GetString(1);
_deviceid = reader.GetString(2);
_pushid = reader.GetString(3);
_phonetype = reader.GetString(4);
_status = reader.GetBoolean(5);
_createdatetime = reader.GetDateTime(6);
_pHONE_OS = reader.GetString(7);
_pHONE_NAME = reader.GetString(8);
_pHONE_MODEL = reader.GetString(9);
_updatedatetime = reader.GetDateTime(10);
}
reader.Close();
}
}
public void PopulateCategory(SqlDataReader _dtr, Category obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_DESCRIPTION);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Description = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_TYPE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.CategoryType)_dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ATTRIBUTES);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Attributes = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ISDELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_XSL_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.XslID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_image);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Image = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_LANGUAGE_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.LanguageID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_HASH);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Hash = _dtr.GetString((columnIndex));
}
}
public bool GetBoolean(System.Data.SqlClient.SqlDataReader r, int i)
{
bool rv = true;
if (!r.IsDBNull(i))
{
rv = r.GetBoolean(i);
}
return(rv);
}
protected override Exception ProcessSqlResult(SqlDataReader reader)
{
Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader);
if ((nextResultSet == null) && (!reader.GetBoolean(1) || (base.ProcessSqlResult(reader) != null)))
{
base.Store.UpdateEventStatus(false, InstancePersistenceEvent<HasRunnableWorkflowEvent>.Value);
base.StoreLock.InstanceDetectionTask.ResetTimer(false);
}
return nextResultSet;
}
private string GetObjectValue(System.Data.SqlClient.SqlDataReader reader, int i)
{
string fieldType = reader.GetFieldType(i).ToString();
object FieldValue = null;;
if (fieldType.Contains("Int32"))
{
FieldValue = reader.GetInt32(i);
}
else if (fieldType.Contains("Int64"))
{
FieldValue = reader.GetInt64(i);
}
else if (fieldType.Contains("Decimal"))
{
FieldValue = reader.GetDecimal(i);
}
else if (fieldType.Contains("Double"))
{
FieldValue = reader.GetDouble(i);
}
else if (fieldType.Contains("DateTime"))
{
FieldValue = reader.GetDateTime(i);
}
else if (fieldType.Contains("String"))
{
FieldValue = reader.GetString(i);
}
else if (fieldType.Contains("Boolean"))
{
FieldValue = reader.GetBoolean(i);
}
else if (fieldType.Contains("Byte"))
{
FieldValue = reader.GetByte(i);
}
else if (fieldType.Contains("Guid"))
{
FieldValue = reader.GetGuid(i);
}
else
{
FieldValue = reader.GetString(i);
}
if (FieldValue != null)
{
return(FieldValue.ToString());
}
else
{
return("");
}
}
private bool GetDBBool(SqlDataReader reader, string columnName)
{
try
{
int ordinal = reader.GetOrdinal(columnName);
return reader.IsDBNull(ordinal) ? false : reader.GetBoolean(ordinal);
}
catch (IndexOutOfRangeException)
{
return false;
}
}
private Author FillAuthor(SqlDataReader reader)
{
var author = new Author();
author.Id = reader.GetInt32(0);
author.Name = reader.GetString(1);
author.Email = reader.GetString(2);
author.Password = reader.GetString(3);
author.IsActive = reader.GetBoolean(4);
author.DateCreated = reader.GetDateTime(5);
return author;
}
private Notification CreateNotification(SqlDataReader reader)
{
return new Notification
{
ID = reader.GetGuid(reader.GetOrdinal("NotificationID")),
LanguageCode = GetString(reader, "LanguageCode"),
Subject = GetString(reader, "Subject"),
TypeKey = GetString(reader, "TypeKey"),
Dispatched = reader.GetBoolean(reader.GetOrdinal("Dispatched")),
Parameter = new JavaScriptSerializer().Deserialize<Dictionary<string, string>>(
GetString(reader, "Parameter")
)
};
}
private Post FillPost(SqlDataReader reader)
{
var post = new Post();
post.Id = reader.GetInt32(0);
post.Author = new Author();
post.Author.Id = reader.GetInt32(1);
post.Title = reader.GetValueOrDefault<string>(2);
post.Body = reader.GetValueOrDefault<string>(3);
post.IsPublished = reader.GetBoolean(4);
post.DateCreated = reader.GetDateTime(5);
return post;
}
protected override DomainObject LoadEntity(int Id, SqlDataReader res)
{
if (res.Read())
{
bool userIsAdmin = res.GetBoolean(2);
if (userIsAdmin)
return _adminMapper.LoadUser(Id, res.GetString(1),res.GetString(3));
else
return _nUserMapper.LoadUser(Id, res.GetString(1));
}
else
return null;
}
private static void FillModelFrom(SqlDataReader reader, UserInfoModel obj)
{
#region
if (reader != null && !reader.IsClosed)
{
obj.UserID = reader.IsDBNull(reader.GetOrdinal("UserID")) ? 0 : reader.GetInt64(reader.GetOrdinal("UserID"));
obj.Email = reader.IsDBNull(reader.GetOrdinal("Email")) ? String.Empty : reader.GetString(reader.GetOrdinal("Email"));
obj.LoginName = reader.IsDBNull(reader.GetOrdinal("LoginName")) ? String.Empty : reader.GetString(reader.GetOrdinal("LoginName"));
obj.Password = reader.IsDBNull(reader.GetOrdinal("Password")) ? String.Empty : reader.GetString(reader.GetOrdinal("Password"));
obj.Sex = reader.IsDBNull(reader.GetOrdinal("Sex")) ? false : reader.GetBoolean(reader.GetOrdinal("Sex"));
obj.Mobile = reader.IsDBNull(reader.GetOrdinal("Mobile")) ? String.Empty : reader.GetString(reader.GetOrdinal("Mobile"));
obj.RealName = reader.IsDBNull(reader.GetOrdinal("RealName")) ? String.Empty : reader.GetString(reader.GetOrdinal("RealName"));
}
#endregion
}
public static bool CheckAdmin(SqlDataReader dr)
{
bool isAdmin = true;
while (dr.Read())
{
isAdmin = dr.GetBoolean(4);
}
if (isAdmin)
{
return true;
}
else
{
return false;
}
}
protected override Exception ProcessSqlResult(SqlDataReader reader)
{
Exception exception = StoreUtilities.GetNextResultSet(this.InstancePersistenceCommand.Name, reader);
if (exception == null)
{
bool runnableInstanceFound = reader.GetBoolean(1);
if (!runnableInstanceFound || base.ProcessSqlResult(reader) != null)
{
base.Store.UpdateEventStatus(false, HasRunnableWorkflowEvent.Value);
base.StoreLock.InstanceDetectionTask.ResetTimer(false);
}
}
return exception;
}
/// <summary>
/// Creates a new instance of the ViewAuditoriaListaVerificacionDetalleCargo class and populates it with data from the specified SqlDataReader.
/// </summary>
private static ViewAuditoriaListaVerificacionDetalleCargoInfo MakeViewAuditoriaListaVerificacionDetalleCargo(SqlDataReader dataReader)
{
ViewAuditoriaListaVerificacionDetalleCargoInfo viewAuditoriaListaVerificacionDetalleCargo = new ViewAuditoriaListaVerificacionDetalleCargoInfo();
if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleCargoId) == false)
viewAuditoriaListaVerificacionDetalleCargo.AuditoriaListaVerificacionDetalleCargoId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleCargoId);
if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false)
viewAuditoriaListaVerificacionDetalleCargo.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId);
if (dataReader.IsDBNull(CargoId) == false)
viewAuditoriaListaVerificacionDetalleCargo.CargoId = dataReader.GetInt32(CargoId);
if (dataReader.IsDBNull(Cargo) == false)
viewAuditoriaListaVerificacionDetalleCargo.Cargo = dataReader.GetString(Cargo);
if (dataReader.IsDBNull(Activo) == false)
viewAuditoriaListaVerificacionDetalleCargo.Activo = dataReader.GetBoolean(Activo);
return viewAuditoriaListaVerificacionDetalleCargo;
}
/// <summary>
/// Creates a new instance of the ViewAuditoriaAuditor class and populates it with data from the specified SqlDataReader.
/// </summary>
private static ViewAuditoriaAuditorInfo MakeViewAuditoriaAuditor(SqlDataReader dataReader)
{
ViewAuditoriaAuditorInfo viewAuditoriaAuditor = new ViewAuditoriaAuditorInfo();
if (dataReader.IsDBNull(AuditoriaAuditorId) == false)
viewAuditoriaAuditor.AuditoriaAuditorId = dataReader.GetInt32(AuditoriaAuditorId);
if (dataReader.IsDBNull(AuditoriaId) == false)
viewAuditoriaAuditor.AuditoriaId = dataReader.GetInt32(AuditoriaId);
if (dataReader.IsDBNull(AuditorId) == false)
viewAuditoriaAuditor.AuditorId = dataReader.GetInt32(AuditorId);
if (dataReader.IsDBNull(NombreAuditor) == false)
viewAuditoriaAuditor.NombreAuditor = dataReader.GetString(NombreAuditor);
if (dataReader.IsDBNull(EsLider) == false)
viewAuditoriaAuditor.EsLider = dataReader.GetBoolean(EsLider);
return viewAuditoriaAuditor;
}
private static void FillModelFrom(SqlDataReader reader, DeliveryAddressModel obj)
{
#region
if (reader != null && !reader.IsClosed)
{
obj.DeliveryAddressID = reader.IsDBNull(reader.GetOrdinal("DeliveryAddressID")) ? 0 : reader.GetInt64(reader.GetOrdinal("DeliveryAddressID"));
obj.UserID = reader.IsDBNull(reader.GetOrdinal("UserID")) ? 0 : reader.GetInt64(reader.GetOrdinal("UserID"));
obj.Consignee = reader.IsDBNull(reader.GetOrdinal("Consignee")) ? String.Empty : reader.GetString(reader.GetOrdinal("Consignee"));
obj.AreaID = reader.IsDBNull(reader.GetOrdinal("AreaID")) ? 0 : reader.GetInt32(reader.GetOrdinal("AreaID"));
obj.CityID = reader.IsDBNull(reader.GetOrdinal("CityID")) ? 0 : reader.GetInt32(reader.GetOrdinal("CityID"));
obj.Address = reader.IsDBNull(reader.GetOrdinal("Address")) ? String.Empty : reader.GetString(reader.GetOrdinal("Address"));
obj.Postcode = reader.IsDBNull(reader.GetOrdinal("Postcode")) ? String.Empty : reader.GetString(reader.GetOrdinal("Postcode"));
obj.Phone = reader.IsDBNull(reader.GetOrdinal("Phone")) ? String.Empty : reader.GetString(reader.GetOrdinal("Phone"));
obj.Mobile = reader.IsDBNull(reader.GetOrdinal("Mobile")) ? String.Empty : reader.GetString(reader.GetOrdinal("Mobile"));
obj.IsDefault = reader.IsDBNull(reader.GetOrdinal("IsDefault")) ? false : reader.GetBoolean(reader.GetOrdinal("IsDefault"));
}
#endregion
}
public Employee GetEmployeeByID(int id)
{
Employee employee = null;
Dao dao = new Dao();
string sqlStatement = "SELECT EmployeeName, Gender, Position, StartDate, Address, PhoneNumber FROM Employee WHERE EmployeeID='" + id + "'";
System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement);
if (reader.Read())
{
string name = reader.GetString(0);
bool gender = reader.GetBoolean(1);
string position = reader.GetString(2);
DateTime date = reader.GetDateTime(3);
string address = reader.GetString(4);
string phone = reader.GetString(5);
employee = new Employee(id, name, gender, position, date, address, phone);
}
dao.Con.Close();
return(employee);
}
public List <Employee> SearchEmployeeByName(string name)
{
List <Employee> employeeList = new List <Employee>();
Dao dao = new Dao();
string sqlStatement = "SELECT EmployeeID, Gender, Position, StartDate, Address, PhoneNumber,EmployeeName From Employee WHERE EmployeeName LIKE N'%" + name + "%'";
System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement);
while (reader.Read())
{
int id = reader.GetInt32(0);
bool gender = reader.GetBoolean(1);
string position = reader.GetString(2);
DateTime date = reader.GetDateTime(3);
string address = reader.GetString(4);
string phone = reader.GetString(5);
string Name = reader.GetString(6);
employeeList.Add(new Employee(id, Name, gender, position, date, address, phone));
}
dao.Con.Close();
return(employeeList);
}
public static string CreateObject(SqlDataReader sdr, string objectName, bool camelCase)
{
if (sdr == null || !sdr.HasRows) return string.Empty;
System.Text.StringBuilder js = new System.Text.StringBuilder("var " + objectName + " = [");
string[] names = JSOMembers(sdr, camelCase);
while (sdr.Read())
{
js.Append("\n{");
for (int i = 0; i < sdr.FieldCount; i++)
{
// Response.Write(sdr.GetFieldType(i).Name.ToLower() + "\n");
switch (sdr.GetFieldType(i).Name.ToLower())
{
case "int":
case "byte":
case "long":
case "short":
case "decimal":
case "double":
js.Append(names[i] + ": " + sdr[i].ToString());
break;
case "boolean":
js.Append(names[i] + ": " + sdr.GetBoolean(i).ToString().ToLower());
break;
default:
js.Append(names[i] + ": '" + sdr[i].ToString() + "'");
break;
}
if ((i + 1) < sdr.FieldCount)
js.Append(',');
}
js.Append("},");
}
js[js.Length - 1] = ']';
js.Append(';');
return js.ToString();
}
public void FillWorker(QC.SqlConnection connection, Workers worker)
{
using (var command = new QC.SqlCommand())
{
command.Connection = connection;
command.CommandType = DT.CommandType.Text;
command.CommandText = @"
SELECT *
FROM Workers
WHERE worker_id = " + worker.worker_id + ";";
QC.SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
worker.worker_clearance = reader.SafeGetInt(1);
worker.workplace_id = reader.SafeGetInt(2);
worker.workplace_name = reader.SafeGetString(3);
worker.secondary_workplace_id = reader.SafeGetInt(4);
worker.secondary_workplace_name = reader.SafeGetString(5);
worker.login_status = reader.GetBoolean(6);
}
reader.Close();
}
}
Patient getNextPatient(SqlDataReader reader)
{
Patient p = new Patient();
p.LocalSiteId = (reader.GetInt16(reader.GetOrdinal("sitecode"))).ToString();
Decimal d = Convert.ToDecimal(reader.GetDecimal(reader.GetOrdinal("localPid")));
if ((d - Math.Floor(d)) > 0)
{
p.LocalPid = (d).ToString();
}
else
{
p.LocalPid = (Convert.ToInt64(d)).ToString();
}
p.Name = new PersonName(reader.GetString(reader.GetOrdinal("name")));
p.SSN = new SocSecNum(reader.GetString(reader.GetOrdinal("ssn")));
if (!reader.IsDBNull(reader.GetOrdinal("gender")))
{
p.Gender = reader.GetBoolean(reader.GetOrdinal("gender")) ? "M" : "F"; // 1 or true == male, 0 or false == female
}
else
{
p.Gender = "";
}
if (!reader.IsDBNull(reader.GetOrdinal("vistaDOB")))
{
p.DOB = reader.GetString(reader.GetOrdinal("vistaDOB"));
}
p.MpiPid = (reader.GetInt32(reader.GetOrdinal("icn"))).ToString();
p.MpiChecksum = (reader.GetInt32(reader.GetOrdinal("icnx"))).ToString();
p.Demographics = new Dictionary<string, DemographicSet>();
DemographicSet demogs = new DemographicSet();
demogs.PhoneNumbers = new List<PhoneNum>();
demogs.EmailAddresses = new List<EmailAddress>();
demogs.StreetAddresses = new List<Address>();
if (!reader.IsDBNull(reader.GetOrdinal("homePhone")))
{
demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("homePhone"))));
}
if (!reader.IsDBNull(reader.GetOrdinal("workPhone")))
{
demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("workPhone"))));
}
if (!reader.IsDBNull(reader.GetOrdinal("cellPhone")))
{
demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("cellPhone"))));
}
if (!reader.IsDBNull(reader.GetOrdinal("emailAddress")))
{
demogs.EmailAddresses.Add(new EmailAddress(reader.GetString(reader.GetOrdinal("emailAddress"))));
}
Address address = new Address();
if (!reader.IsDBNull(reader.GetOrdinal("addressLine1")))
{
address.Street1 = reader.GetString(reader.GetOrdinal("addressLine1"));
}
if (!reader.IsDBNull(reader.GetOrdinal("addressLine2")))
{
address.Street2 = reader.GetString(reader.GetOrdinal("addressLine2"));
}
if (!reader.IsDBNull(reader.GetOrdinal("addressLine3")))
{
address.Street3 = reader.GetString(reader.GetOrdinal("addressLine3"));
}
if (!reader.IsDBNull(reader.GetOrdinal("city")))
{
address.City = reader.GetString(reader.GetOrdinal("city"));
}
if (!reader.IsDBNull(reader.GetOrdinal("county")))
{
address.County = reader.GetString(reader.GetOrdinal("county"));
}
if (!reader.IsDBNull(reader.GetOrdinal("state")))
{
address.State = reader.GetString(reader.GetOrdinal("state"));
}
if (!reader.IsDBNull(reader.GetOrdinal("zipcode")))
{
address.Zipcode = reader.GetString(reader.GetOrdinal("zipcode"));
}
demogs.StreetAddresses.Add(address);
p.Demographics.Add(p.LocalSiteId, demogs);
return p;
}
internal static void FillFromReader(Article article, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_ARTICLE_CATEGORY_ID);
if (!reader.IsDBNull(colIndex))
article.CategoryID = reader.GetInt32(colIndex);
int days = 0, seconds = 0;
colIndex = reader.GetOrdinal(CN_ARTICLE_CREATION_DAY);
if (!reader.IsDBNull(colIndex))
days = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_CREATION_SEC);
if (!reader.IsDBNull(colIndex))
seconds = reader.GetInt32(colIndex);
article.CreationDate = CMSCoreHelper.GetDateTime(days, seconds);
colIndex = reader.GetOrdinal(CN_ARTICLE_DESCRIPTION);
if (!reader.IsDBNull(colIndex))
article.Description = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_DETAILS);
if (!reader.IsDBNull(colIndex))
article.Details = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_ID);
if (!reader.IsDBNull(colIndex))
article.ID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_IMAGE);
if (!reader.IsDBNull(colIndex))
article.Image = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_IS_DELETED);
if (!reader.IsDBNull(colIndex))
article.IsDeleted = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_KEYWORDS);
if (!reader.IsDBNull(colIndex))
article.KeyWords = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_LANGUAGE_ID);
if (!reader.IsDBNull(colIndex))
article.LanguageID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_NAME);
if (!reader.IsDBNull(colIndex))
article.Name = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_SUMMARY);
if (!reader.IsDBNull(colIndex))
article.Summary = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_PORTAL_ID);
if (!reader.IsDBNull(colIndex))
article.PortalID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_SEO_NAME);
if (!reader.IsDBNull(colIndex))
article.SEOName = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_URL);
if (!reader.IsDBNull(colIndex))
article.URL = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_TYPE);
if (!reader.IsDBNull(colIndex))
article.ArticleType = (CMSEnums.ArticleType)reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_ORDER);
if (!reader.IsDBNull(colIndex))
article.Order = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_CREATED_BY);
if (!reader.IsDBNull(colIndex))
article.CreatedBy = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_PARENT_OBJ_ID);
if (!reader.IsDBNull(colIndex))
article.ParentObjectID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_VIEW_COUNT);
if (!reader.IsDBNull(colIndex))
article.ViewCount = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(PublishDataMapper.CN_PUBLISH_TYPE_ID);
if (!reader.IsDBNull(colIndex))
article.IsPublished = reader.GetInt32(colIndex) == (int)CMSEnums.PublishType.PublishNow;
}
/// <summary>
/// Gets the user from data reader.
/// </summary>
/// <param name="user_list">The user_list.</param>
/// <returns>User from database</returns>
private static User GetUserFromDataReader( SqlDataReader user_list )
{
return new User(
user_list.GetString( 0 ),
user_list.GetString( 1 ),
user_list.GetInt32( 2 ),
user_list.GetInt32( 3 ),
user_list.GetString( 4 ),
user_list.GetBoolean( 5 ),
user_list.GetDateTime( 6 ),
user_list.GetString( 7 ),
user_list.GetBoolean( 8 ),
user_list.GetBoolean( 9 ),
user_list.GetDateTime( 10 ),
user_list.GetGuid( 11 ),
user_list.GetBoolean( 12 ),
user_list.GetBoolean( 13 ),
user_list.GetInt32( 14 ),
user_list.GetDecimal( 15 ),
user_list.GetBoolean( 16 ),
user_list.GetString( 17 ),
user_list.GetDecimal( 18 ),
user_list.GetString( 19 ),
user_list.GetString( 20 ),
user_list.GetString( 21 ),
user_list.GetString( 22 ),
user_list.GetString( 23 ),
user_list.GetString( 24 ),
user_list.GetString( 25 ),
user_list.GetString( 26 ),
user_list.GetString( 27 ),
user_list.GetString( 28 ),
user_list.GetString( 39 ),
user_list.GetString( 30 ),
user_list.GetString( 31 ),
user_list.GetInt32( 32 ),
user_list.GetBoolean( 33 ),
user_list.GetInt32( 34 ),
user_list.GetString( 35 ),
user_list.GetBoolean( 36 ),
user_list.GetBoolean( 37 ),
user_list.GetString( 38 ),
user_list.GetString( 39 ),
user_list.GetString( 40 ),
user_list.GetString( 41 ),
user_list.GetString( 42 ),
user_list.GetInt32( 43 ),
user_list.GetString( 44 ),
user_list.GetBoolean( 45 ),
user_list.GetBoolean( 46 ),
user_list.GetInt32( 47 ),
user_list.GetInt32( 48 ),
user_list.GetString( 49 ),
user_list.GetInt32( 50 ),
user_list.GetString( 51 )
);
}
public static void ReportBuilder(SqlDataReader dr, int cropYear, DateTime letterDate, DateTime deadlineDate, string logoUrl, System.IO.FileStream fs)
{
const string METHOD_NAME = "ReportBuilder";
const float primaryLeading = 13.5F;
const float primaryLeftIndent = 20F;
string strLetterDate = letterDate.ToString("MMMM dd, yyyy");
string strDeadlineDate = deadlineDate.ToString("MMMM dd, yyyy");
string LdoBusinessName = "";
string tmpStr = "";
string tmpStr2 = "";
Document document = null;
PdfWriter writer = null;
LandownerLetterEvent pgEvent = null;
ColumnText ct = null;
iTextSharp.text.Image imgLogo = null;
try {
while (dr.Read()) {
LdoBusinessName = dr["LdoBusinessName"].ToString();
string LdoAddressLine1 = dr["LdoAddressLine1"].ToString();
string LdoAddressLine2 = dr["LdoAddressLine2"].ToString();
string LdoCityStateZip = dr["LdoCityStateZip"].ToString();
if (document == null) {
// IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!!
// *** US LETTER: 612 X 792 ***
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin, PortraitPageSize.PgBottomMargin);
imgLogo = PdfReports.GetImage(logoUrl, 127, 50, iTextSharp.text.Element.ALIGN_CENTER);
// we create a writer that listens to the document
// and directs a PDF-stream to a file
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new LandownerLetterEvent();
pgEvent.FillEvent(imgLogo, strLetterDate, LdoBusinessName, LdoAddressLine1, LdoAddressLine2, LdoCityStateZip);
writer.PageEvent = pgEvent;
// Open the document
document.Open();
} else {
pgEvent.FillEvent(imgLogo, strLetterDate, LdoBusinessName, LdoAddressLine1, LdoAddressLine2, LdoCityStateZip);
document.NewPage();
}
ct = pgEvent.GetColumnObject();
Paragraph p = new Paragraph(primaryLeading, "Your tenant, " + dr["GroBusinessName"].ToString() +
", has indicated that the proceeds for sugar beets grown on your land in\n" +
cropYear.ToString() + " are to be split and you will be receiving " + dr.GetDecimal(dr.GetOrdinal("LdoSplitPercent")).ToString("##.0##") +
"% of the proceeds. Since Western Sugar Cooperative no\n" +
"longer requires signatures for the second payees, this letter has been sent for your verification.\n\n", _normalFont);
ct.AddElement(p);
p = new Paragraph(new Phrase(primaryLeading, "Your check will be made payable as follows:", _normalFont));
ct.AddElement(p);
p = new Paragraph(primaryLeading, dr["ldoPayeeDescription"].ToString(), _normalFont);
p.IndentationLeft = primaryLeftIndent;
ct.AddElement(p);
p = new Paragraph(primaryLeading, "If you have a lien on the beets, the lien holder’s name should be included above.\n\n" +
"In addition, the following options were selected by your tenant.", _normalFont);
ct.AddElement(p);
decimal ldoChemPct = dr.GetDecimal(dr.GetOrdinal("LdoChemicalSplitPct"));
if (dr.GetBoolean(dr.GetOrdinal("IsSplitChemical")) && ldoChemPct != 0) {
tmpStr = ldoChemPct.ToString("##.0##") + "%";
} else {
tmpStr = "No";
}
decimal ldoRetainPct = dr.GetDecimal(dr.GetOrdinal("LdoSplitPercent"));
if (dr.GetBoolean(dr.GetOrdinal("IsSplitRetain")) && ldoRetainPct != 0) {
tmpStr2 = ldoRetainPct.ToString("##.0##") + "% of the";
} else {
tmpStr2 = "No";
}
p = new Paragraph(primaryLeading, tmpStr2 + " Unit Retains on this contract will be deducted from your proceeds.\n" +
tmpStr + " seed & chemical receivables charged to this contract will be deducted from your proceeds.", _normalFont);
p.IndentationLeft = primaryLeftIndent;
ct.AddElement(p);
p = new Paragraph(primaryLeading, "If the above information is correct, no response is needed.\n\n", _normalFont);
ct.AddElement(p);
p = new Paragraph(primaryLeading, "If any of the above information is not correct, please contact your tenant’s agriculturist, " +
dr["AgriculturistName"].ToString() +
" at\n" + WSCIEMP.Common.CodeLib.FormatPhoneNumber2Display(dr["AgriculturistPhone"].ToString()) +
" by " + strDeadlineDate + ", or mail the corrections to:\n\n", _normalFont);
ct.AddElement(p);
p = new Paragraph(12F, "Western Sugar Cooperative\n" +
"Attn: Marty Smith\n" +
"1221 8th Avenue Unit E\n" +
"Greeley, CO 80631\n\n", _normalFont);
p.IndentationLeft = primaryLeftIndent;
ct.AddElement(p);
p = new Paragraph(primaryLeading, "Sincerely,\n\n" +
"Marty Smith\n" +
"Beet Accounting Manager\n\n" +
"Ref: " + dr["ContractNo"].ToString(), _normalFont);
ct.AddElement(p);
ct.Go(false);
}
// ======================================================
// Close document
// ======================================================
if (document != null) {
pgEvent.IsDocumentClosing = true;
document.Close();
document = null;
}
if (writer == null || String.IsNullOrEmpty(LdoBusinessName)) {
// Warn that we have no data.
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("No records matched your report criteria.");
throw (warn);
}
}
catch (Exception ex) {
string errMsg = "document is null: " + (document == null).ToString() + "; " +
"writer is null: " + (writer == null).ToString();
WSCIEMP.Common.CException wscex = new WSCIEMP.Common.CException(MOD_NAME + METHOD_NAME + errMsg, ex);
throw (wscex);
}
finally {
if (document != null) {
pgEvent.IsDocumentClosing = true;
document.Close();
}
if (writer != null) {
writer.Close();
}
}
}
protected static void PopulateEntity(SqlDataReader reader, ServerEntity entity, Dictionary<string, PropertyInfo> propMap)
{
for (int i = 0; i < reader.FieldCount; i++)
{
String columnName = reader.GetName(i);
// Special case for when we select a range of values with an EntityBroker, just ignore
if (columnName.Equals("RowNum"))
continue;
if (columnName.Equals("GUID"))
{
Guid uid = reader.GetGuid(i);
entity.SetKey(new ServerEntityKey(entity.Name, uid));
continue;
}
if (columnName.Equals(entity.Name) && columnName.Contains("Enum"))
columnName = "Enum";
PropertyInfo prop;
if (!propMap.TryGetValue(columnName, out prop))
throw new EntityNotFoundException("Unable to match column to property: " + columnName, null);
if (columnName.Contains("GUID"))
columnName = columnName.Replace("GUID", "Key");
if (reader.IsDBNull(i))
{
prop.SetValue(entity, null, null);
continue;
}
Type propType = prop.PropertyType;
if (propType == typeof(String))
prop.SetValue(entity, reader.GetString(i), null);
else if (propType == typeof(ServerEntityKey))
{
Guid uid = reader.GetGuid(i);
prop.SetValue(entity, new ServerEntityKey(columnName.Replace("Key", String.Empty), uid), null);
}
else if (propType == typeof(DateTime))
prop.SetValue(entity, reader.GetDateTime(i), null);
else if (propType == typeof(DateTime?))
{
if (reader.IsDBNull(i))
{
prop.SetValue(entity, null, null);
}
else
{
prop.SetValue(entity, reader.GetDateTime(i), null);
}
}
else if (propType == typeof(bool))
prop.SetValue(entity, reader.GetBoolean(i), null);
else if (propType == typeof(Int32))
prop.SetValue(entity, reader.GetInt32(i), null);
else if (propType == typeof(Int16))
prop.SetValue(entity, reader.GetInt16(i), null);
else if (propType == typeof(double))
prop.SetValue(entity, reader.GetDouble(i), null);
else if (propType == typeof(Decimal))
prop.SetValue(entity, reader.GetDecimal(i), null);
else if (propType == typeof(float))
prop.SetValue(entity, reader.GetFloat(i), null);
else if (propType == typeof(XmlDocument))
{
SqlXml xml = reader.GetSqlXml(i);
if (xml!=null && !xml.IsNull)
{
XmlReader xmlReader = xml.CreateReader();
if (xmlReader != null)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(xmlReader);
prop.SetValue(entity, xmlDoc, null);
}
else
prop.SetValue(entity, null, null);
}
else
{
prop.SetValue(entity, null, null);
}
}
else if (typeof(ServerEnum).IsAssignableFrom(propType))
{
short enumVal = reader.GetInt16(i);
ConstructorInfo construct = prop.PropertyType.GetConstructor(new Type[0]);
ServerEnum val = (ServerEnum)construct.Invoke(null);
val.SetEnum(enumVal);
prop.SetValue(entity, val, null);
}
else
throw new EntityNotFoundException("Unsupported property type: " + propType, null);
}
}
private Jedi SqlDataReaderToJedi(SqlDataReader sqlDataReader)
{
return new Jedi(sqlDataReader.GetInt32(JEDI_ID), sqlDataReader.GetString(JEDI_NOM), sqlDataReader.GetBoolean(JEDI_IS_SITH));
}
/// <summary>
/// Creates a new instance of the ViewAuditoriaListaVerificacion class and populates it with data from the specified SqlDataReader.
/// </summary>
private static ViewAuditoriaListaVerificacionInfo MakeViewAuditoriaListaVerificacion(SqlDataReader dataReader)
{
ViewAuditoriaListaVerificacionInfo viewAuditoriaListaVerificacion = new ViewAuditoriaListaVerificacionInfo();
if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false)
viewAuditoriaListaVerificacion.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId);
if (dataReader.IsDBNull(Descripcion) == false)
viewAuditoriaListaVerificacion.Descripcion = dataReader.GetString(Descripcion);
if (dataReader.IsDBNull(FechaCreacion) == false)
viewAuditoriaListaVerificacion.FechaCreacion = dataReader.GetDateTime(FechaCreacion);
if (dataReader.IsDBNull(CreadaPor) == false)
viewAuditoriaListaVerificacion.CreadaPor = dataReader.GetInt32(CreadaPor);
if (dataReader.IsDBNull(Version) == false)
viewAuditoriaListaVerificacion.Version = dataReader.GetString(Version);
if (dataReader.IsDBNull(AuditoriaTipoId) == false)
viewAuditoriaListaVerificacion.AuditoriaTipoId = dataReader.GetInt32(AuditoriaTipoId);
if (dataReader.IsDBNull(TipoAuditoria) == false)
viewAuditoriaListaVerificacion.TipoAuditoria = dataReader.GetString(TipoAuditoria);
if (dataReader.IsDBNull(Activa) == false)
viewAuditoriaListaVerificacion.Activa = dataReader.GetBoolean(Activa);
if (dataReader.IsDBNull(NombreCompleto) == false)
viewAuditoriaListaVerificacion.NombreCompleto = dataReader.GetString(NombreCompleto);
return viewAuditoriaListaVerificacion;
}
// Copy multiple fields from reader to ITypedSettersV3
// Assumes caller enforces that reader and setter metadata are compatible
internal static void FillCompatibleITypedSettersFromReader( SmiEventSink_Default sink, ITypedSettersV3 setters, SmiMetaData[] metaData, SqlDataReader reader ) {
for ( int i = 0; i < metaData.Length; i++ ) {
if ( reader.IsDBNull(i) ) {
ValueUtilsSmi.SetDBNull_Unchecked( sink, setters, i );
}
else {
switch ( metaData[i].SqlDbType ) {
case SqlDbType.BigInt:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int64 ) );
ValueUtilsSmi.SetInt64_Unchecked( sink, setters, i, reader.GetInt64(i) );
break;
case SqlDbType.Binary:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) );
ValueUtilsSmi.SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 );
break;
case SqlDbType.Bit:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Boolean ) );
SetBoolean_Unchecked( sink, setters, i, reader.GetBoolean(i) );
break;
case SqlDbType.Char:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) );
SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 );
break;
case SqlDbType.DateTime:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.DateTime ) );
SetDateTime_Checked( sink, setters, i, metaData[i], reader.GetDateTime(i) );
break;
case SqlDbType.Decimal:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlDecimal ) );
SetSqlDecimal_Unchecked( sink, setters, i, reader.GetSqlDecimal(i) );
break;
case SqlDbType.Float:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Double ) );
SetDouble_Unchecked( sink, setters, i, reader.GetDouble(i) );
break;
case SqlDbType.Image:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) );
SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 );
break;
case SqlDbType.Int:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int32 ) );
SetInt32_Unchecked( sink, setters, i, reader.GetInt32(i) );
break;
case SqlDbType.Money:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlMoney ) );
SetSqlMoney_Unchecked( sink, setters, i, metaData[i], reader.GetSqlMoney(i) );
break;
case SqlDbType.NChar:
case SqlDbType.NText:
case SqlDbType.NVarChar:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) );
SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 );
break;
case SqlDbType.Real:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Single ) );
SetSingle_Unchecked( sink, setters, i, reader.GetFloat(i) );
break;
case SqlDbType.UniqueIdentifier:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Guid ) );
SetGuid_Unchecked( sink, setters, i, reader.GetGuid(i) );
break;
case SqlDbType.SmallDateTime:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.DateTime ) );
SetDateTime_Checked( sink, setters, i, metaData[i], reader.GetDateTime(i) );
break;
case SqlDbType.SmallInt:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int16 ) );
SetInt16_Unchecked( sink, setters, i, reader.GetInt16(i) );
break;
case SqlDbType.SmallMoney:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlMoney ) );
SetSqlMoney_Checked( sink, setters, i, metaData[i], reader.GetSqlMoney(i) );
break;
case SqlDbType.Text:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) );
SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 );
break;
case SqlDbType.Timestamp:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) );
SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 );
break;
case SqlDbType.TinyInt:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Byte ) );
SetByte_Unchecked( sink, setters, i, reader.GetByte(i) );
break;
case SqlDbType.VarBinary:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) );
SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 );
break;
case SqlDbType.VarChar:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.String ) );
SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 );
break;
case SqlDbType.Xml:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlXml ) );
SetSqlXml_Unchecked( sink, setters, i, reader.GetSqlXml(i) );
break;
case SqlDbType.Variant:
object o = reader.GetSqlValue(i);
ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCode( o );
SetCompatibleValue( sink, setters, i, metaData[i], o, typeCode, 0 );
break;
case SqlDbType.Udt:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) );
SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 );
break;
default:
// In order for us to get here we would have to have an
// invalid instance of SqlDbType, or one would have to add
// new member to SqlDbType without adding a case in this
// switch, hence the assert - it must be
Debug.Assert( false, "unsupported DbType:" + metaData[i].SqlDbType.ToString() );
throw ADP.NotSupported();
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
if (habitaciones == "" || cant == 0)
{
MessageBox.Show("Debe seleccionar por lo menos una habitacion");
return;
}
if (string.IsNullOrEmpty(textBox2.Text))
{
MessageBox.Show("Debe seleccionar 1 cliente");
return;
}
bool estado = false;
resultado = Home.BD.comando("select habilitado from GESTION_DE_GATOS.Cliente where idCli =" + textBox2.Text);
if (resultado.Read())
{
estado = resultado.GetBoolean(0);
}
resultado.Close();
if (estado == false)
{
MessageBox.Show("Cliente Inhabilitado para realizar reservas");
return;
}
//AHORA LOS INSERTS
string insert = "EXEC GESTION_DE_GATOS.InsertarReserva ";
insert = insert + "'" + dateTimePicker1.Value.Date.ToString("yyyyMMdd HH:mm:ss") + "',";
insert = insert + "'" + comboBox3.Text + "',";
insert = insert + "'" + dateTimePicker2.Value.Date.ToString("yyyyMMdd HH:mm:ss") + "',";
insert = insert + "'" + Home.fecha.Date.ToString("yyyyMMdd HH:mm:ss") + "',";
insert = insert + Login.HomeLogin.idUsuario + ",";
insert = insert + textBox2.Text + ",";
double ab = (dateTimePicker2.Value.Date - dateTimePicker1.Value.Date).TotalDays;
insert = insert + ab.ToString() + ",";
insert = insert + Convert.ToInt32(total).ToString();
decimal id = 0;
resultado = Home.BD.comando(insert);
if (resultado.Read() == true)
{
id = resultado.GetDecimal(0);
}
resultado.Close();
if (id == 0)
{
MessageBox.Show("No se pudo generar la reserva");
button1_Click(null, null);
return;
}
string comand = "EXEC GESTION_DE_GATOS.InsertarReservaXHabitacion " + id.ToString() + ",";
string[] strArr = null;
int count = 0;
char[] splitchar = { ',' };
comand = "EXEC GESTION_DE_GATOS.InsertarReservaXHabitacion " + id.ToString() + ",";
if (cant > 1)
{
strArr = null;
count = 0;
strArr = habitaciones.Split(splitchar);
for (count = 0; count <= strArr.Length - 1; count++)
{
resultado = Home.BD.comando(comand + strArr[count]);
if (!resultado.Read())
{
MessageBox.Show("No se pudo insertar la habitacion a la reserva,error en el read");
resultado.Close();
return;
}
decimal a = resultado.GetDecimal(0);
if (a == 0)
{
MessageBox.Show("No se pudo insertar la habitacion a la reserva, no cumplio el unique");
resultado.Close();
return;
}
resultado.Close();
}
}
else
{
resultado = Home.BD.comando(comand + habitaciones);
if (!resultado.Read())
{
MessageBox.Show("No se pudo insertar la habitacion a la reserva,error en el read");
resultado.Close();
return;
}
decimal b = resultado.GetDecimal(0);
if (b == 0)
{
MessageBox.Show("No se pudo insertar la habitacion a la reserva, no cumplio el unique");
resultado.Close();
return;
}
resultado.Close();
}
MessageBox.Show("Reserva generada correctamente, su numero de reserva es: "+id.ToString());
this.Close();
}
private static Registration MakeRegistration(SqlDataReader dataReader)
{
Registration registration = new Registration();
if (dataReader.IsDBNull(0) == false) {
registration.StudentID = dataReader.GetInt32(0);
}
if (dataReader.IsDBNull(1) == false) {
registration.Name = dataReader.GetString(1);
}
if (dataReader.IsDBNull(2) == false) {
registration.DateOfBirth = dataReader.GetDateTime(2);
}
if (dataReader.IsDBNull(3) == false) {
registration.GradePointAvg = dataReader.GetDecimal(3);
}
if (dataReader.IsDBNull(4) == false) {
registration.Active = dataReader.GetBoolean(4);
}
return registration;
}
public static bool GetIsActive(SqlDataReader dr)
{
bool result = true;
while (dr.Read())
{
result = dr.GetBoolean(0);
}
return result;
}
/// <summary>
/// Creates a new instance of the Delegaciones class and populates it with data from the specified SqlDataReader.
/// </summary>
private static DelegacionesInfo MakeDelegaciones(SqlDataReader dataReader)
{
DelegacionesInfo delegaciones = new DelegacionesInfo();
if (dataReader.IsDBNull(Cod_Regional) == false)
delegaciones.Cod_Regional = dataReader.GetInt32(Cod_Regional);
if (dataReader.IsDBNull(Cod_Delegacion) == false)
delegaciones.Cod_Delegacion = dataReader.GetInt32(Cod_Delegacion);
if (dataReader.IsDBNull(Delegacion) == false)
delegaciones.Delegacion = dataReader.GetString(Delegacion);
if (dataReader.IsDBNull(Numero) == false)
delegaciones.Numero = dataReader.GetString(Numero);
if (dataReader.IsDBNull(Cod_Jefe) == false)
delegaciones.Cod_Jefe = dataReader.GetInt32(Cod_Jefe);
if (dataReader.IsDBNull(Email) == false)
delegaciones.Email = dataReader.GetString(Email);
if (dataReader.IsDBNull(LastProcess) == false)
delegaciones.LastProcess = new Byte[Convert.ToInt32(dataReader.GetBytes(0, 0, null, 0, Int32.MaxValue))];
dataReader.GetBytes(0, 0, delegaciones.LastProcess, 0, delegaciones.LastProcess.Length);
if (dataReader.IsDBNull(ActualProcess) == false)
delegaciones.ActualProcess = new Byte[Convert.ToInt32(dataReader.GetBytes(0, 0, null, 0, Int32.MaxValue))];
dataReader.GetBytes(0, 0, delegaciones.ActualProcess, 0, delegaciones.ActualProcess.Length);
if (dataReader.IsDBNull(TempTime) == false)
delegaciones.TempTime = new Byte[Convert.ToInt32(dataReader.GetBytes(0, 0, null, 0, Int32.MaxValue))];
dataReader.GetBytes(0, 0, delegaciones.TempTime, 0, delegaciones.TempTime.Length);
if (dataReader.IsDBNull(Proc_ID) == false)
delegaciones.Proc_ID = dataReader.GetInt32(Proc_ID);
if (dataReader.IsDBNull(Skip) == false)
delegaciones.Skip = dataReader.GetBoolean(Skip);
if (dataReader.IsDBNull(SyncID) == false)
delegaciones.SyncID = dataReader.GetGuid(SyncID);
if (dataReader.IsDBNull(SyncTimeStamp) == false)
delegaciones.SyncTimeStamp = DateTime.MinValue;
return delegaciones;
}
