/// <summary>
/// Inserts the specified ticket detail.
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="ticketDetail">The ticket detail.</param>
/// <returns>
/// Ticket Id.
/// </returns>
public int Insert(int? userId, string ticketDetail)
{
ObjectParameter ticketIdParameter = new ObjectParameter("TicketID", typeof(global::System.Int32));
ticketIdParameter.Value = DBNull.Value;
this.unitOfWork.Context.AddTicket(ticketDetail, userId, ticketIdParameter);
return Convert.ToInt32(ticketIdParameter.Value, CultureInfo.CurrentCulture);
}
public void RefreshListUsers(byte companyID, short userID, Controls.UserItemList userItemListCurrent)
{
Cursor.Current = Cursors.WaitCursor;
userItemListCurrent.SuspendLayout();
ObjectParameter currentReadDateTime = new System.Data.Entity.Core.Objects.ObjectParameter("CurrentReadDateTime", typeof(DateTime));
ObjectResult <CSMessenger.usp_User_ListByLastMessage_Result> result = mdbContext.usp_User_ListByLastMessage(companyID, userID, mPreviousRead, currentReadDateTime);
if (userItemListCurrent.Items.Count == 0)
{
// Load Users for the first time
foreach (CSMessenger.usp_User_ListByLastMessage_Result userCurrent in result)
{
if (userCurrent.LastMessageReceivedOn <= mPreviousRead)
{
// Old messages
userItemListCurrent.Add(userCurrent.CompanyID, userCurrent.UserID, userCurrent.UserName, false);
}
else
{
// New messages
userItemListCurrent.Add(userCurrent.CompanyID, userCurrent.UserID, userCurrent.UserName, true);
}
}
}
else
{
foreach (CSMessenger.usp_User_ListByLastMessage_Result userCurrent in result)
{
// TODO: Reorder user items
// Check if the User already exists in the List
if (userItemListCurrent.Items.ContainsKey(GetUserKey(companyID, userID)))
{
// Already exists, so reorder
}
else
{
// Doesn't exists, so add it
if (userCurrent.LastMessageReceivedOn <= mPreviousRead)
{
// Old messages
AddUserItemToList(userItemListCurrent, userCurrent.CompanyID, userCurrent.UserID, userCurrent.UserName, false);
}
else
{
// New messages
AddUserItemToList(userItemListCurrent, userCurrent.CompanyID, userCurrent.UserID, userCurrent.UserName, true);
}
}
}
}
userItemListCurrent.ResumeLayout();
mPreviousRead = Convert.ToDateTime(currentReadDateTime.Value);
Cursor.Current = Cursors.Default;
}
public virtual int SPCodeGlobalInsert(string permissionCode, string codeValue, string parentCodeValue, string codeName, string memId, string regIP, ObjectParameter returnValue)
{
var permissionCodeParameter = permissionCode != null ?
new ObjectParameter("permissionCode", permissionCode) :
new ObjectParameter("permissionCode", typeof(string));
var codeValueParameter = codeValue != null ?
new ObjectParameter("codeValue", codeValue) :
new ObjectParameter("codeValue", typeof(string));
var parentCodeValueParameter = parentCodeValue != null ?
new ObjectParameter("parentCodeValue", parentCodeValue) :
new ObjectParameter("parentCodeValue", typeof(string));
var codeNameParameter = codeName != null ?
new ObjectParameter("codeName", codeName) :
new ObjectParameter("codeName", typeof(string));
var memIdParameter = memId != null ?
new ObjectParameter("memId", memId) :
new ObjectParameter("memId", typeof(string));
var regIPParameter = regIP != null ?
new ObjectParameter("regIP", regIP) :
new ObjectParameter("regIP", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SPCodeGlobalInsert", permissionCodeParameter, codeValueParameter, parentCodeValueParameter, codeNameParameter, memIdParameter, regIPParameter, returnValue);
}
public virtual int NewEvent(string name, Nullable<int> typeId, Nullable<System.DateTime> date, Nullable<System.DateTime> closingDate, Nullable<int> capacity, string place, string imageUrl, ObjectParameter id)
{
var nameParameter = name != null ?
new ObjectParameter("Name", name) :
new ObjectParameter("Name", typeof(string));
var typeIdParameter = typeId.HasValue ?
new ObjectParameter("TypeId", typeId) :
new ObjectParameter("TypeId", typeof(int));
var dateParameter = date.HasValue ?
new ObjectParameter("Date", date) :
new ObjectParameter("Date", typeof(System.DateTime));
var closingDateParameter = closingDate.HasValue ?
new ObjectParameter("ClosingDate", closingDate) :
new ObjectParameter("ClosingDate", typeof(System.DateTime));
var capacityParameter = capacity.HasValue ?
new ObjectParameter("Capacity", capacity) :
new ObjectParameter("Capacity", typeof(int));
var placeParameter = place != null ?
new ObjectParameter("Place", place) :
new ObjectParameter("Place", typeof(string));
var imageUrlParameter = imageUrl != null ?
new ObjectParameter("ImageUrl", imageUrl) :
new ObjectParameter("ImageUrl", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("NewEvent", nameParameter, typeIdParameter, dateParameter, closingDateParameter, capacityParameter, placeParameter, imageUrlParameter, id);
}
/// <summary>
/// Posts the comment.
/// </summary>
/// <param name="commentDetail">The comment detail.</param>
/// <param name="userId">The user identifier.</param>
/// <returns>comment id</returns>
public int PostComment(string commentDetail, int userId)
{
ObjectParameter commentIdParameter = new ObjectParameter("CommentID", typeof(global::System.Int32));
commentIdParameter.Value = DBNull.Value;
this.unitOfWork.Context.AddTicketComment(commentDetail, userId, commentIdParameter);
return Convert.ToInt32(commentIdParameter.Value, CultureInfo.CurrentCulture);
}
private static void CallStoredProc() {
using (AutoLotEntities context = new AutoLotEntities()) {
ObjectParameter outParam = new ObjectParameter("petName", typeof(string));
context.GetPetName(83, outParam);
Console.WriteLine(outParam.Value);
}
}
public ActionResult Login(FormCollection formColl)
{
string usrName = formColl["UserName"];
string Pass = formColl["Password"];
if (ModelState.IsValid)
{
//System.Data.Objects.ObjectParameter flag = new System.Data.Objects.ObjectParameter("flag", typeof(bool));
System.Data.Entity.Core.Objects.ObjectParameter flag = new System.Data.Entity.Core.Objects.ObjectParameter("flag", typeof(bool));
db.check_login(usrName, Pass, flag);
var seller = (from m in db.Sellers
where (m.username == usrName)
select m).SingleOrDefault();
if (seller != null)
{
TemData.sellerID = seller.ID;
if (Convert.ToBoolean(flag.Value))
{
Session["username"] = seller.username;
return(RedirectToAction("Index", "Product"));
}
else
{
Session["username"] = "******";
}
}
}
return(View("Index"));
}
public ActionResult Register(FormCollection formColl)//TempSellerData data) //validations only on frontend,must add
{
if (ModelState.IsValid)
{
//Seller _seller = data.Seller;
//var Password = data.Login.password;
//System.Data.Objects.ObjectParameter flag = new System.Data.Objects.ObjectParameter("flag", typeof(bool));
System.Data.Entity.Core.Objects.ObjectParameter flag = new System.Data.Entity.Core.Objects.ObjectParameter("flag", typeof(bool));
db.sign_up(formColl["username"], formColl["password"], formColl["Fname"], formColl["Lname"], formColl["email"], formColl["phone"],
formColl["address"], "", "Seller", flag);//formColl["city"]
if (Convert.ToBoolean(flag.Value))
{
Session["username"] = formColl["username"];
TemData.sellerID = GetUser(formColl["username"]).ID;
return(RedirectToAction("Index", "Product"));
}
else
{
Session["username"] = "******";
TemData.sellerID = 0;//for now
}
}
return(RedirectToAction("SignUp", "admin_Login"));
}
/*
* Nombre : AddClient
* Descripción : Agregar un registro de cliente, tarjetas y cuentas.
* Parámetros : string numdoc, string name, string phone, string address
*/
public Response AddClient(string numdoc, string name, string phone, string address)
{
using (CardsEntities context = new CardsEntities())
{
string resCode = "1";
string resDetail = "Excepción: ";
string resSource = SERVICE_NAME + String.Format("AddClient(string numdoc={0}, string name={1}, string phone={2}, string address={3})", numdoc , name , phone , address);
ObjectParameter respuesta = new ObjectParameter("response", typeof(int));
if (numdoc != null && name != null && phone != null && address != null)
{
context.PLZ_ADD_CLIENTE(numdoc, name, phone, address, respuesta);
resCode = respuesta.Value.ToString();
}
resDetail = getExcepcionDetail(resCode);
return new Response() { excode = resCode, exdetail = resDetail, exsource = resSource };
}
}
public virtual int T_Alarms_ADD(ObjectParameter id, Nullable<int> statId, Nullable<int> devId, Nullable<short> dustType, Nullable<double> faultVal, Nullable<System.DateTime> updateTime, string country)
{
var statIdParameter = statId.HasValue ?
new ObjectParameter("StatId", statId) :
new ObjectParameter("StatId", typeof(int));
var devIdParameter = devId.HasValue ?
new ObjectParameter("DevId", devId) :
new ObjectParameter("DevId", typeof(int));
var dustTypeParameter = dustType.HasValue ?
new ObjectParameter("DustType", dustType) :
new ObjectParameter("DustType", typeof(short));
var faultValParameter = faultVal.HasValue ?
new ObjectParameter("FaultVal", faultVal) :
new ObjectParameter("FaultVal", typeof(double));
var updateTimeParameter = updateTime.HasValue ?
new ObjectParameter("UpdateTime", updateTime) :
new ObjectParameter("UpdateTime", typeof(System.DateTime));
var countryParameter = country != null ?
new ObjectParameter("Country", country) :
new ObjectParameter("Country", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("T_Alarms_ADD", id, statIdParameter, devIdParameter, dustTypeParameter, faultValParameter, updateTimeParameter, countryParameter);
}
public virtual int ParameterTest(byte[] binary, Nullable<bool> @bool, Nullable<System.DateTime> dateTime, Nullable<decimal> @decimal, Nullable<double> @float, Nullable<System.Guid> guid, ObjectParameter @int, ObjectParameter @string)
{
var binaryParameter = binary != null ?
new ObjectParameter("binary", binary) :
new ObjectParameter("binary", typeof(byte[]));
var boolParameter = @bool.HasValue ?
new ObjectParameter("bool", @bool) :
new ObjectParameter("bool", typeof(bool));
var dateTimeParameter = dateTime.HasValue ?
new ObjectParameter("dateTime", dateTime) :
new ObjectParameter("dateTime", typeof(System.DateTime));
var decimalParameter = @decimal.HasValue ?
new ObjectParameter("decimal", @decimal) :
new ObjectParameter("decimal", typeof(decimal));
var floatParameter = @float.HasValue ?
new ObjectParameter("float", @float) :
new ObjectParameter("float", typeof(double));
var guidParameter = guid.HasValue ?
new ObjectParameter("guid", guid) :
new ObjectParameter("guid", typeof(System.Guid));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("ParameterTest", binaryParameter, boolParameter, dateTimeParameter, decimalParameter, floatParameter, guidParameter, @int, @string);
}
public int BuscarTelefonia(Nullable <int> iVentaId)
{
using (OnyxEntities db = new OnyxEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter iDatosProductoId = new System.Data.Entity.Core.Objects.ObjectParameter("iDatosProductoId", typeof(Int32));
db.CRMCP_BuscarTelefonia(3, iVentaId, null, iDatosProductoId);
//int CodigoTelefonia = Convert.ToInt32(iDatosProductoId.Value);
try
{
int CodigoTelefonia = Convert.ToInt32(iDatosProductoId.Value);
return(CodigoTelefonia);
}
catch (Exception)
{
return(0);
}
//if (CodigoTelefonia != 0)
//{
// return CodigoTelefonia;
//}
//else
//{
// return 0;
//}
}
}
public virtual int InsertFlower(string maHoa, string tenHoa, Nullable<double> giaBan, Nullable<int> soLuong, string hinhAnh, string maChuDe, ObjectParameter error)
{
var maHoaParameter = maHoa != null ?
new ObjectParameter("MaHoa", maHoa) :
new ObjectParameter("MaHoa", typeof(string));
var tenHoaParameter = tenHoa != null ?
new ObjectParameter("TenHoa", tenHoa) :
new ObjectParameter("TenHoa", typeof(string));
var giaBanParameter = giaBan.HasValue ?
new ObjectParameter("GiaBan", giaBan) :
new ObjectParameter("GiaBan", typeof(double));
var soLuongParameter = soLuong.HasValue ?
new ObjectParameter("SoLuong", soLuong) :
new ObjectParameter("SoLuong", typeof(int));
var hinhAnhParameter = hinhAnh != null ?
new ObjectParameter("HinhAnh", hinhAnh) :
new ObjectParameter("HinhAnh", typeof(string));
var maChuDeParameter = maChuDe != null ?
new ObjectParameter("MaChuDe", maChuDe) :
new ObjectParameter("MaChuDe", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertFlower", maHoaParameter, tenHoaParameter, giaBanParameter, soLuongParameter, hinhAnhParameter, maChuDeParameter, error);
}
public virtual int aspnet_Applications_CreateApplication(string applicationName, ObjectParameter applicationId)
{
var applicationNameParameter = applicationName != null ?
new ObjectParameter("ApplicationName", applicationName) :
new ObjectParameter("ApplicationName", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("aspnet_Applications_CreateApplication", applicationNameParameter, applicationId);
}
public virtual int GetPetName(Nullable<int> carID, ObjectParameter petName)
{
var carIDParameter = carID.HasValue ?
new ObjectParameter("carID", carID) :
new ObjectParameter("carID", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetPetName", carIDParameter, petName);
}
public virtual int GetHashCode(string input, ObjectParameter hash)
{
var inputParameter = input != null ?
new ObjectParameter("input", input) :
new ObjectParameter("input", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetHashCode", inputParameter, hash);
}
public virtual int usp_AddEventFilter(string eventFilter, ObjectParameter guid)
{
var eventFilterParameter = eventFilter != null ?
new ObjectParameter("EventFilter", eventFilter) :
new ObjectParameter("EventFilter", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_AddEventFilter", eventFilterParameter, guid);
}
public virtual int sp_GenerateRandomString(Nullable<int> sLength, ObjectParameter randomString)
{
var sLengthParameter = sLength.HasValue ?
new ObjectParameter("sLength", sLength) :
new ObjectParameter("sLength", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_GenerateRandomString", sLengthParameter, randomString);
}
/// <summary>
/// Allow create a new agent
/// </summary>
/// <param name="model"> Objet type ModelAgent</param>
/// <param name="prmOutIdAgent">New id agent record</param>
/// <param name="prmOutResult">Result the process created</param>
public void addAgentController(AgentModel model, ref ObjectParameter prmOutIdAgent, ref ObjectParameter prmOutResult)
{
int res = 0;
Repository<AGENT> objInsert = new Repository<AGENT>();
//Repository<AgentInsert> objInsert = new Repository<AgentInsert>();
DGSDATAEntities entities = new DGSDATAEntities();
try
{
res = entities.Agent_Insert(
model.Enable,
model.DontXferPlayerActivity, //prmDontXfer
model.IsDistributor,
model.IdUser, // prmIdUser,
model.Distributor,
model.Makeup,
model.CommSports,
model.CommCasino,
model.CommHorses,
model.PerHeadSports,
model.PerHeadCasino,
model.PerHeadHorses,
model.IdAgentType,
model.IdCurrency,
model.IdBook,
model.IdGrouping,
model.Agent,
model.Name,
model.Password,
model.City,
model.State,
model.Country,
model.Address1,
model.Address2,
model.Email,
model.Phone,
model.Fax,
model.Zip,
model.OnlineAccess,
model.OnlineMessage,
model.IdLineType,
prmOutIdAgent,
prmOutResult);
//object obj = new object[] { prmOutIdAgent, prmOutResult };
//return obj;
}
catch
{
throw;
}
}
public string InsertFlower(Hoa hoa)
{
ObjectParameter err = new ObjectParameter("Error", typeof(string));
using (BanHoaEntityEntities banHoaEntity=new BanHoaEntityEntities())
{
banHoaEntity.InsertFlower(hoa.MaHoa, hoa.TenHoa, hoa.GiaBan, hoa.SoLuong, hoa.HinhAnh, hoa.MaChuDe, err);
}
return err.Value.ToString();
}
public JsonResult LockedDate(int locationID, DateTime lockedDate)
{
int x = locationID;
DateTime d = lockedDate;
ObjectParameter[] parameters = new ObjectParameter[] { new ObjectParameter("AspUserID", User.Identity.GetUserId()), new ObjectParameter("LocationID", locationID), new ObjectParameter("LockedDate", lockedDate) };
this.baseRepository.ExecuteFunction("UpdateLockedDate", parameters);
return Json(new { Success = true });
}
// ReSharper disable once MemberCanBePrivate.Global
public IQueryable<UserIdWrapper> GetUsersByNamePrefix(string name)
{
if (string.IsNullOrEmpty(name))
return db.Users.Select(u => new UserIdWrapper(u.Id)); ;
var splittedName = name.Split(new[] { ' ', '\t' }, StringSplitOptions.RemoveEmptyEntries);
var nameQuery = string.Join(" & ", splittedName.Select(s => "\"" + s.Trim().Replace("\"", "\\\"") + "*\""));
var nameParameter = new ObjectParameter("name", nameQuery);
return db.ObjectContext().CreateQuery<UserIdWrapper>($"[{nameof(GetUsersByNamePrefix)}](@name)", nameParameter);
}
private static decimal FindSupplierIncomesForPeriodOfTime(string name, DateTime startDate, DateTime endDate)
{
using (var northwindEntities = new NorthwindEntities())
{
var outputParameter = new ObjectParameter("result", typeof(decimal));
northwindEntities.FindSupplierIncome(name, startDate, endDate, outputParameter);
return decimal.Parse(outputParameter.Value.ToString());
}
}
public static void InsertNewUserToAspNetUserRoles(LmsUserViewModel reg, string id)
{
using (var db = new SWC_LMSEntities())
{
var output = new ObjectParameter("UserId", typeof(int));
db.InsertToAspNetUserRoles(reg.UserId.ToString(), reg.Roles.ToString());
}
}
public static void InsertNewUserToDb(RegisterViewModel reg, string id)
{
using (var db = new SWC_LMSEntities())
{
var output = new ObjectParameter("UserId", typeof(int));
db.LmsUserInsert(id, reg.Fname, reg.Lname, reg.Email,
reg.GradeLevelId, reg.SuggestedRole, output);
}
}
public void StoreProcedureWithOutParameterTest()
{
using (AdventureWorks adventureWorks = new AdventureWorks())
{
ObjectParameter errorLogId = new ObjectParameter("ErrorLogID", typeof(int)) { Value = 5 };
int? rows = adventureWorks.LogError(errorLogId);
Assert.AreEqual(0, errorLogId.Value);
Assert.AreEqual(typeof(int), errorLogId.ParameterType);
Assert.AreEqual(-1, rows);
}
}
public virtual int AccountExists(string login, Nullable<bool> isActive, ObjectParameter accExists)
{
var loginParameter = login != null ?
new ObjectParameter("Login", login) :
new ObjectParameter("Login", typeof(string));
var isActiveParameter = isActive.HasValue ?
new ObjectParameter("IsActive", isActive) :
new ObjectParameter("IsActive", typeof(bool));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("AccountExists", loginParameter, isActiveParameter, accExists);
}
public virtual int spInsertSale(Nullable<int> clientId, Nullable<System.DateTime> dateSale, ObjectParameter saleId)
{
var clientIdParameter = clientId.HasValue ?
new ObjectParameter("ClientId", clientId) :
new ObjectParameter("ClientId", typeof(int));
var dateSaleParameter = dateSale.HasValue ?
new ObjectParameter("DateSale", dateSale) :
new ObjectParameter("DateSale", typeof(System.DateTime));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("spInsertSale", clientIdParameter, dateSaleParameter, saleId);
}
public virtual ObjectResult<sp_ShowProductShoppingPage_Result> sp_ShowProductShoppingPage(ObjectParameter totalRow, Nullable<int> index, Nullable<int> rowNumber)
{
var indexParameter = index.HasValue ?
new ObjectParameter("index", index) :
new ObjectParameter("index", typeof(int));
var rowNumberParameter = rowNumber.HasValue ?
new ObjectParameter("rowNumber", rowNumber) :
new ObjectParameter("rowNumber", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_ShowProductShoppingPage_Result>("sp_ShowProductShoppingPage", totalRow, indexParameter, rowNumberParameter);
}
public void LogIn(LmsUserViewRegistration user)
{
byte? gradeLevelId = null;
if (user.GradeLevelId != null)
{
gradeLevelId = Convert.ToByte(user.GradeLevelId);
}
ObjectParameter userId = new ObjectParameter("userId", typeof (int));
db.LmsUserInsert(user.GuidId, user.FirstName, user.LastName, user.Email, gradeLevelId, user.SuggestedRole,
userId);
}
public virtual int Register_Complete(Nullable<int> userId, Nullable<int> roleId, ObjectParameter msgText, ObjectParameter msgType)
{
var userIdParameter = userId.HasValue ?
new ObjectParameter("UserId", userId) :
new ObjectParameter("UserId", typeof(int));
var roleIdParameter = roleId.HasValue ?
new ObjectParameter("RoleId", roleId) :
new ObjectParameter("RoleId", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Register_Complete", userIdParameter, roleIdParameter, msgText, msgType);
}
public virtual int spLogin(string user, string pwd, ObjectParameter outId)
{
var userParameter = user != null ?
new ObjectParameter("user", user) :
new ObjectParameter("user", typeof(string));
var pwdParameter = pwd != null ?
new ObjectParameter("pwd", pwd) :
new ObjectParameter("pwd", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("spLogin", userParameter, pwdParameter, outId);
}
public static int Get(string name)
{
using (var context = Connection.GetContext())
{
ObjectParameter parameter = new ObjectParameter("ID", typeof(int));
context.sp_GetProducerID(name, parameter);
context.SaveChanges();
return (int)parameter.Value;
}
}
/// <summary>
/// Applies the current filter settings to an esql object query dynamically.
/// </summary>
/// <param name="filters">The filters.</param>
/// <param name="baseQuery">The base object query.</param>
/// <returns>ObjectQuery{Ticket}.</returns>
public static ObjectQuery<Ticket> ApplyToQuery(this ICollection<UserTicketListFilterColumn> filters, ObjectQuery<Ticket> baseQuery)
{
var filterColumns = filters.ToList();
if (filterColumns.Count > 0)
{
var fkeys = new string[filterColumns.Count];
var fParams = new ObjectParameter[filterColumns.Count];
for (var i = 0; i < filterColumns.Count; i++)
{
string optr;
var filterColumn = filterColumns[i];
if (filterColumn.ColumnValue == DBNull.Value)
{
optr = (filterColumn.UseEqualityComparison.HasValue && !filterColumn.UseEqualityComparison.Value)
? "IS NOT"
: "IS";
}
else
{
optr = (filterColumn.UseEqualityComparison.HasValue && !filterColumn.UseEqualityComparison.Value)
? "!="
: "=";
}
fkeys[i] = string.Format("it.{0} {1} {2}", filterColumn.ColumnName, optr, "@" + filterColumn.ColumnName);
//most of the time esql works with whatever type of param value you pass in, but
// enums in our collection are serialized to/from json as integers.
// Check if enum, and explicitly convert int value to the correct enum value
if (filterColumn.ColumnValueType != null && filterColumn.ColumnValueType.IsEnum)
{
filterColumn.ColumnValue = Enum.Parse(filterColumn.ColumnValueType, filterColumn.ColumnValue.ToString());
}
//assigning the type in ctor, then value directly as a param works around issues when the colum val is null.
fParams[i] = new ObjectParameter(filterColumn.ColumnName, filterColumn.ColumnValueType)
{
Value = filterColumn.ColumnValue
};
}
var wString = string.Join(" and ", fkeys);
baseQuery = baseQuery.Where(wString, fParams);
}
return baseQuery;
}
public IHttpActionResult PostNewSpFee(SpFeeViewModel spfee)
{
ObjectParameter FEE1 = new System.Data.Entity.Core.Objects.ObjectParameter("FEE1", typeof(double));
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new EMSEntities())
{
ctx.spStudentCurrentFee(spfee.SPFEEDTLs[0].TRNNO, FEE1, spfee.CLASS_TRNNO);
var res = FEE1.Value;
if (res == null)
{
return(NotFound());
}
return(Ok(res));
}
}
public IHttpActionResult GetStudentClassByEmpId(int?id)
{
ObjectParameter CL_TRNNO = new System.Data.Entity.Core.Objects.ObjectParameter("CL_TRNNO", typeof(double));
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new EMSEntities())
{
ctx.spFindStudentClass(id, CL_TRNNO);
var res = CL_TRNNO.Value;
if (res == null)
{
return(NotFound());
}
return(Ok(res));
}
}
public IHttpActionResult getCurrentFee(FeeCollectViewModel fcCVm)
{
ObjectParameter FEE1 = new System.Data.Entity.Core.Objects.ObjectParameter("FEE1", typeof(double));
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new EMSEntities())
{
ctx.spStudentCurrentFee(fcCVm.EM_TRNNO, FEE1, fcCVm.CLASS_TRNNO);
var res = FEE1.Value;
if (res == null)
{
return(NotFound());
}
return(Ok(res));
}
}
private bool GetUserFromCompanyDatabase(short userID)
{
try
{
ObjectParameter companyUserName = new System.Data.Entity.Core.Objects.ObjectParameter("UserName", typeof(String));
mdbContext.usp_User_GetInfoFromCompanyDB(mCompany.CompanyID, userID, companyUserName);
if (companyUserName != null)
{
mUserNameOnCompanyDB = Convert.ToString(companyUserName.Value);
return(true);
}
else
{
MessageBox.Show("El Usuario especificado en la línea de comandos, no existe en la base de datos de la Compañía.", My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception e)
{
MessageBox.Show(string.Format("Error leyendo los datos del Usuario desde la base de datos de la Compañía.{0}{0}Error #{1}: {2}", System.Environment.NewLine, e.HResult, e.InnerException.Message), My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public bool SendMessage(Controls.MessageList messageListControl, string text)
{
try
{
// Add the message to the database, update the destination user semaphore and gets the new message ID (all in the stored procedure)
ObjectParameter outputMessageID = new System.Data.Entity.Core.Objects.ObjectParameter("MessageID", typeof(Int32));
mdbContext.usp_Message_Send(mUser.CompanyID, mUser.UserID, messageListControl.CompanyID, messageListControl.UserID, text, outputMessageID);
int messageID = Convert.ToInt32(outputMessageID.Value);
// Load current message from database
// TODO: Use the message from memory
Message messageSent = mdbContext.Message.Find(messageID);
// Show the sent message in the MessageList control
MessageListControlFunctions.AppendSentMessage(ref messageListControl, messageSent);
return(true);
}
catch (DbEntityValidationException e)
{
MessageBox.Show(string.Format("Error al enviar el Mensaje.{0}{0}Error #{1}: {2}", System.Environment.NewLine, e.HResult, e.Message), My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
/// <summary>
/// Change1:新增报表的total列的统计您信息。2014年2月10日10:46:43
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ChannelReportWithStatisModel GetSaleReprotByChannelList(ReportsModel model)
{
using (PermaisuriCMSEntities db = new PermaisuriCMSEntities())
{
var adapter = (IObjectContextAdapter)db;
var objectContext = adapter.ObjectContext;
objectContext.CommandTimeout = 3 * 60; // value in seconds
ChannelReportWithStatisModel reportModel = new ChannelReportWithStatisModel();
List <ChannelReportModel> list = new List <ChannelReportModel>();
String OrderType = "asc";
String OrderBy = "UnitsSold";
if (model.OrderType > 0)
{
OrderType = "desc";
}
if (model.OrderBy > 0)
{
switch (model.OrderBy)
{
case 1: //order by Channel
OrderBy = "ChannelName";
break;
case 2: //order by Sales Totals
OrderBy = "SalesTotal";
break;
case 3: // order by Units Sold
OrderBy = "UnitsSold";
break;
case 4: // order by Avg. Sale Amount
OrderBy = "AvgAmont";
break;
default:
OrderBy = "UnitsSold";
break;
}
}
var countParam = new System.Data.Entity.Core.Objects.ObjectParameter("count", typeof(int));//注意，第一个参数count名称必须与Store Procedure里面的输出参数的名称一一对应！不区分大小写
var SumSalesTotalParam = new ObjectParameter("SumSalesTotal", typeof(int));
var SumUnitsSoldParam = new ObjectParameter("SumUnitsSold", typeof(int));
var SumAvgAmontParam = new ObjectParameter("SumAvgAmont", typeof(int));
var res = db.Ecom_ReportByChannel_SP(model.page, model.rows, model.Channel, model.Brand, model.StartTime, model.EndTime,
OrderBy, OrderType, countParam, SumSalesTotalParam, SumUnitsSoldParam, SumAvgAmontParam).ToList();
//count = Convert.ToInt32(countParam.Value);
reportModel.Count = Convert.ToInt32(countParam.Value);
reportModel.SumSalesTotal = Convert.ToInt32(SumSalesTotalParam.Value).ToString("C", new CultureInfo("en-US"));
reportModel.SumUnitsSold = Convert.ToInt32(SumUnitsSoldParam.Value);
reportModel.SumAvgAmont = Convert.ToInt32(SumAvgAmontParam.Value).ToString("C", new CultureInfo("en-US"));
foreach (Ecom_ReportByChannel_SP_Result r in res)
{
list.Add(new ChannelReportModel
{
Channel = r.ChannelName,
ChannelID = r.ChannelID,
SalesTotal = r.SalesTotal.ConvertToNotNull().ToString("C", new CultureInfo("en-US")),
UnitsSold = r.UnitsSold.ConvertToNotNull(),
AvgAmont = r.AvgAmont.ConvertToNotNull().ToString("C", new CultureInfo("en-US"))
});
}
reportModel.ReportList = list;
return(reportModel);
}
}