/// <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)));
}
