public IPeople GetByLoginDetails(string emailId, string password)
{
IPeople user = new MyDiary.Domain.Domains.People();
user.UserRoles = new List <IRole>()
{
new Role()
};
user.UserImages = new List <IImage>()
{
new Image()
};
SqlConnection conn = SQLDbConnection.GetNewSqlConnectionObject();
conn.Open();
SqlCommand cmd = SQLDbConnection.GetNewSqlCommandObject(conn, Constants.StoredProcedures.People.USERLOGIN_SELECT);
cmd.Parameters.AddWithValue(Constants.StoredProcedures.People.Parameters.EmailId, emailId);
cmd.Parameters.AddWithValue(Constants.StoredProcedures.People.Parameters.Password, password);
DataTable dtUser = SQLDbConnection.FillDataSetFromDataAdapter(SQLDbConnection.GetNewSqlDataAdapterObject(cmd));
if (dtUser != null && dtUser.Rows.Count > 0)
{
user = Map_PeopleDataRow_To_PeopleDomain(dtUser.Rows[0]);
}
return(user);
}
public IPeople GetByOpenSiteDetails(int siteId, string siteUserId)
{
IPeople user = new MyDiary.Domain.Domains.People();
user.UserRoles = new List <IRole>()
{
new Role()
};
user.UserImages = new List <IImage>()
{
new Image()
};
try
{
SqlConnection conn = SQLDbConnection.GetNewSqlConnectionObject();
conn.Open();
SqlCommand cmd = SQLDbConnection.GetNewSqlCommandObject(conn, Constants.StoredProcedures.People.DRY_USER_GET_BYOPENSITEDETAILS);
cmd.Parameters.AddWithValue(Constants.StoredProcedures.People.Parameters.SiteId, siteId);
cmd.Parameters.AddWithValue(Constants.StoredProcedures.People.Parameters.SiteUserId, siteUserId);
DataTable dtUser = SQLDbConnection.FillDataSetFromDataAdapter(SQLDbConnection.GetNewSqlDataAdapterObject(cmd));
if (dtUser != null && dtUser.Rows.Count > 0)
{
user = Map_PeopleDataRow_To_PeopleDomain(dtUser.Rows[0]);
}
return(user);
}
catch (Exception)
{
return(user);
}
}
private IPeople Map_PeopleDataRow_To_PeopleDomain(DataRow drPeople)
{
IPeople people = new MyDiary.Domain.Domains.People();
List <IRole> userRoles = new List <IRole>()
{
new Role()
};
List <IImage> userImages = new List <IImage>()
{
new Image()
};
foreach (DataColumn dc in drPeople.Table.Columns)
{
switch (dc.ColumnName)
{
case Constants.StoredProcedures.People.Fields.UserId:
people.UserId = (string.IsNullOrEmpty(drPeople[dc.ColumnName].ToString()) ? 0 : Convert.ToInt32(drPeople[dc.ColumnName].ToString()));
break;
case Constants.StoredProcedures.People.Fields.FirstName:
people.FirstName = Convert.ToString(drPeople[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.People.Fields.MiddleName:
people.MiddleName = Convert.ToString(drPeople[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.People.Fields.LastName:
people.LastName = Convert.ToString(drPeople[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.People.Fields.EmailId:
people.EmailId = Convert.ToString(drPeople[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.People.Fields.RoleId:
userRoles.FirstOrDefault().RoleId = (string.IsNullOrEmpty(drPeople[dc.ColumnName].ToString()) ? 0 : Convert.ToInt32(drPeople[dc.ColumnName].ToString()));
break;
case Constants.StoredProcedures.People.Fields.RoleName:
userRoles.FirstOrDefault().RoleCode = (drPeople[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.People.Fields.ImageId:
userImages.FirstOrDefault().ImageId = (string.IsNullOrEmpty(drPeople[dc.ColumnName].ToString()) ? 0 : Convert.ToInt32(drPeople[dc.ColumnName].ToString()));
break;
case Constants.StoredProcedures.People.Fields.SiteId:
people.SiteId = (string.IsNullOrEmpty(drPeople[dc.ColumnName].ToString()) ? 0 : Convert.ToInt32(drPeople[dc.ColumnName].ToString()));
break;
case Constants.StoredProcedures.People.Fields.SiteUserId:
people.SiteUserId = drPeople[dc.ColumnName].ToString();
break;
}
}
people.UserImages = userImages;
people.UserRoles = userRoles;
return(people);
}
private IExpense GetExpenseFromDataRow(DataRow dr)
{
IExpense expense = new MyDiary.Domain.Domains.Expense();
IExpenseType expenseType = new MyDiary.Domain.Domains.ExpenseType();
IPeople currentUser = new MyDiary.Domain.Domains.People();
foreach (DataColumn dc in dr.Table.Columns)
{
switch (dc.ColumnName)
{
case Constants.StoredProcedures.Expenses.Parameters.ExpenseId:
expense.Id = Convert.ToInt32(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.ExpenseType:
expenseType.Type = Convert.ToString(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.ExpenseTypeId:
expenseType.TypeId = Convert.ToInt32(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.ExpenseDate:
expense.ExpenseDate = Convert.ToDateTime(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.Description:
expense.Description = Convert.ToString(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.Comments:
expense.Comments = Convert.ToString(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.Amount:
expense.Amount = float.Parse(dr[dc.ColumnName].ToString(), System.Globalization.CultureInfo.InvariantCulture);
break;
case Constants.StoredProcedures.ExpenseTypes.Parameters.UserId:
currentUser.UserId = Convert.ToInt32(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.CREATEDBY:
expense.CreatedBy = Convert.ToInt32(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.CREATEDDATE:
expense.CreatedDate = Convert.ToDateTime(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.MODIFIEDBY:
expense.ModifiedBy = (dr[dc.ColumnName]) == DBNull.Value ? (int?)null : Convert.ToInt32(dr[dc.ColumnName].ToString());
break;
case Constants.StoredProcedures.Expenses.Parameters.MODIFIEDDATE:
expense.ModifiedDate = (dr[dc.ColumnName]) == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(dr[dc.ColumnName].ToString());
break;
}
}
expense.ExpenseType = expenseType;
expense.CurrentUser = currentUser;
return(expense);
}