/// <summary> /// Updates the record Resource TMS custom return int. /// </summary> /// <param name="_objTMSResource">The object TMS resource.</param> /// <returns>System.Int32.</returns> public int UpdateRecordResourceTMSCustomReturnInt(TMSResource _objTMSResource) { try { SqlConnection con = new SqlConnection(DBHelper.ConnectionString); SqlCommand cmd = new SqlCommand("TMS_Admin_UpdateResourceDataDual", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@P_ResourceId", _objTMSResource.P_Resourceid); cmd.Parameters.AddWithValue("@S_ResourceId", _objTMSResource.S_Resourceid); cmd.Parameters.AddWithValue("@P_Value", _objTMSResource.P_Value); cmd.Parameters.AddWithValue("@S_Value", _objTMSResource.S_Value); cmd.Parameters.AddWithValue("@UpdatedBy", _objTMSResource.UpdatedBy); cmd.Parameters.AddWithValue("@organizationID", _objTMSResource.OrganizationID); cmd.Parameters.AddWithValue("@result", SqlDbType.Int); cmd.Parameters["@result"].Direction = ParameterDirection.Output; con.Open(); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); //read the return value (i.e status) from the stored procedure return(Convert.ToInt32(cmd.Parameters["@result"].Value)); } catch (Exception) { return(-1); } }
/// <summary> /// Inserts the record resources TMS custom return object. /// </summary> /// <param name="_objTMSResource">The object TMS resource.</param> /// <returns>ResourceCreationDual.</returns> /// public ResourceCreationDual InsertRecordResourceOrg(TMSResource _objTMSResource) { ResourceCreationDual _Response = new ResourceCreationDual(); try { SqlConnection con = new SqlConnection(DBHelper.ConnectionString); SqlCommand cmd = new SqlCommand("TMS_Admin_InsertResourceDataOrganization", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrganizationID", _objTMSResource.OrganizationID); cmd.Parameters.Add("@CreatedBy", _objTMSResource.CreatedBy); //SqlParameter parameter = new SqlParameter(); //parameter.Direction = ParameterDirection.Output; //parameter.ParameterName = "@DeliveryCharges"; //parameter.SqlDbType = SqlDbType.Decimal; //parameter.Precision = 18; //parameter.Scale = 3; //cmd.Parameters.Add(parameter); con.Open(); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); //read the return value (i.e status) from the stored procedure } catch (Exception Ex) { return(null); } return(_Response); }
/** * Discover the list of services your account is provisioned for. * * Use this as an entry point to use the services so that you * don't have to code in the URIs for each service. * */ public TMSResource GetServices() { TMSResource resource = new TMSResource(); resource._links["self"] = "/"; return(Get <TMSResource>(resource._links["self"])); }
public void TestGetServices() { TMSResource services = api.GetServices(); Assert.IsNotNull(services._links["self"]); Assert.AreEqual("/", services._links["self"]); // If you are provisioned for email, this will be there Assert.IsNotNull(services._links["email_messages"]); }
/** * Give me the list of messages I have sent from my account. * * Use the GetServices() entry point to get the email messages * relation. * */ public List <TMSEmailMessage> GetEmailMessages() { TMSResource services = GetServices(); var request = new RestRequest(); request.Resource = services._links["email_messages"]; request.Method = Method.GET; return(Execute <List <TMSEmailMessage> >(request)); }
/** * Send an SMS message */ public TMSSMSMessage SendSMSMessage(TMSSMSMessage messageIn) { TMSResource services = GetServices(); var request = new RestRequest(); request.Resource = services._links["sms_messages"]; request.Method = Method.POST; request.JsonSerializer = new TMSJsonSerializer(); // anytime you want to send a POST you need to make sure // you tell the request object you want to send JSON // so that it can serialize correctly request.RequestFormat = DataFormat.Json; request.AddBody(messageIn); return(Execute <TMSSMSMessage>(request)); }
// <summary> /// Resources the exist count bal. /// </summary> /// <param name="Name">The name.</param> /// <returns>System.Int32.</returns> public ResourceCreationDual InsertOrgResourceBAL(TMSResource _obj) { return(DAL.InsertOrgResourceDAL(_obj)); }
/// <summary> /// Resources the exist count bal. /// </summary> /// <param name="Name">The name.</param> /// <returns>System.Int32.</returns> //public int ResourceExistCountBAL(string Name) //{ // return DAL.ResourceExistCountDAL(Name); //} /// <summary> /// Updates the dual TMS resource bal. /// </summary> /// <param name="_obj">The object.</param> /// <returns>System.Int32.</returns> public int UpdateDualTMSResourceBAL(TMSResource _obj) { return(DAL.UpdateDualTMSResourceDAL(_obj)); }
/// <summary> /// Updates the dual TMS resource dal. /// </summary> /// <param name="_obj">The object.</param> /// <returns>System.Int32.</returns> public int UpdateDualTMSResourceDAL(TMSResource _obj) { DbCustomAdminGenerics db = new DbCustomAdminGenerics(); return(db.UpdateRecordResourceTMSCustomReturnInt(_obj)); }
/// <summary> /// Updates the dual TMS resource dal. /// </summary> /// <param name="_obj">The object.</param> /// <returns>System.Int32.</returns> public ResourceCreationDual InsertOrgResourceDAL(TMSResource _obj) { DbCustomAdminGenerics db = new DbCustomAdminGenerics(); return(db.InsertRecordResourceOrg(_obj)); }
/// <summary> /// Inserts the dual TMS resource dal. /// </summary> /// <param name="_obj">The object.</param> /// <returns>ResourceCreationDual.</returns> public ResourceCreationDual InsertDualTMSResourceDAL(TMSResource _obj) { DbCustomAdminGenerics db = new DbCustomAdminGenerics(); return(db.InsertRecordResourceTMSCustomReturnObject(_obj)); }
public ActionResult Resource_Update([DataSourceRequest] DataSourceRequest request, TMSResource Resources) { Resources.UpdatedBy = Convert.ToInt64(CurrentUser.NameIdentifier); Resources.Name = Resources.Name.RemoveWhitespace(); //Removeany uunwanted Space Resources.Name = Resources.Name.RemoveUnWantedCharacter(); //to make this Proper Variblename var Resp = _objeResources.UpdateDualTMSResourceBAL(Resources); if (Resp != 2) { ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError); } var resultData = new[] { Resources }; return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState))); }
public ActionResult Resource_Create([DataSourceRequest] DataSourceRequest request, TMSResource Resources) { // ITMSResourcesBAL _objeResources = new TMSResourcesBAL(); if (_objeResources.ResourceExistCountBAL(Resources.Name) > 0) { ModelState.AddModelError(lr.ResourceName, lr.ResourceValidationName); } if (ModelState.IsValid) { Resources.OrganizationID = CurrentUser.CompanyID; Resources.CreatedBy = Convert.ToInt64(CurrentUser.NameIdentifier); Resources.Name = Resources.Name.RemoveWhitespace(); //Remove any unwanted Space Resources.Name = Resources.Name.RemoveUnWantedCharacter(); //to make this Proper Variblename var Resp = _objeResources.InsertDualTMSResourceBAL(Resources); Resources.CreatedDate = DateTime.Now; Resources.P_Resourceid = Resp.P_Resourceid; Resources.S_Resourceid = Resp.S_Resourceid; //return Json(new[] { Resources }.ToDataSourceResult(request, ModelState)); } var resultData = new[] { Resources }; return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState))); }
public ActionResult Resource_CreateOrganization([DataSourceRequest] DataSourceRequest request, TMSResource Resources, long oid) { // ITMSResourcesBAL _objeResources = new TMSResourcesBAL(); if (_objeResources.LanguageExistCountBAL(oid) <= 0) { return(Json("Please Enter Language!", JsonRequestBehavior.AllowGet)); } if (ModelState.IsValid) { Resources.OrganizationID = oid; Resources.CreatedBy = Convert.ToInt64(CurrentUser.NameIdentifier); //Resources.Name = Resources.Name.RemoveWhitespace();//Remove any unwanted Space // Resources.Name = Resources.Name.RemoveUnWantedCharacter();//to make this Proper Variblename var Resp = _objeResources.InsertOrgResourceBAL(Resources); Resources.CreatedDate = DateTime.Now; // Resources.P_Resourceid = Resp.P_Resourceid; // Resources.S_Resourceid = Resp.S_Resourceid; //return Json(new[] { Resources }.ToDataSourceResult(request, ModelState)); } var resultData = new[] { Resources }; return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState))); }