public static WMSUserObject SelectWMSUserObjectByEmailAddressAndShopID(SqlConnection connection, string emailAddress, int shopID)
{
WMSUserObject wmsUser = null;
var parameters = new[]
{
new SqlParameter("@EmailAddress", emailAddress),
new SqlParameter("@ShopID", shopID)
};
using (var dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "WMSUserObject_SelectWMSUserObjectByEmailAddressAndShopID", parameters))
{
if (dataReader.Read())
{
wmsUser = new WMSUserObject()
{
PKID = dataReader.GetTuhuValue <int>(0),
EmailAddress = dataReader.GetTuhuString(1),
ShopID = dataReader.GetTuhuValue <int>(2),
IsActive = dataReader.GetTuhuValue <bool>(3),
LastUpdate = dataReader.GetTuhuValue <DateTime>(4)
};
}
}
return(wmsUser);
}
public static List <WMSUserObject> SelectShopsEmployeeByEmailAddress(SqlConnection connection, string emailAddress)
{
var wmsUsers = new List <WMSUserObject>();
var parameters = new[]
{
new SqlParameter("@EmailAddress", emailAddress)
};
using (var dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "WMSUserObject_SelectShopsEmployeeByEmailAddress", parameters))
{
while (dataReader.Read())
{
var employee = new WMSUserObject()
{
ShopID = dataReader.GetTuhuValue <int>(0),
ShopsNo = dataReader.GetTuhuValue <int>(1),
ShopsName = dataReader.GetTuhuString(2)
};
wmsUsers.Add(employee);
}
}
return(wmsUsers);
}
public static void AddWMSUserObject(SqlConnection con, WMSUserObject wmsUser)
{
var sqlParamters = new[]
{
new SqlParameter("@EmailAddress", wmsUser.EmailAddress),
new SqlParameter("@ShopID", wmsUser.ShopID)
};
SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "WMSUserObject_InsertWMSUserObject", sqlParamters);
}
