public string Delete(string token)
{
//int Id, int userId, bool final
string message = "";
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int Id = 0;
int userId = 0;
bool final = false;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "Id")
{
Id = int.Parse(c.Value);
}
else if (c.Type == "userId")
{
userId = int.Parse(c.Value);
}
else if (c.Type == "final")
{
final = bool.Parse(c.Value);
}
}
if (final)
{
try
{
using (incposdbEntities entity = new incposdbEntities())
{
groupObject Deleterow = entity.groupObject.Find(Id);
entity.groupObject.Remove(Deleterow);
message = entity.SaveChanges().ToString();
// return Ok("OK");
return(TokenManager.GenerateToken(message));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
else
{
try
{
using (incposdbEntities entity = new incposdbEntities())
{
groupObject Obj = entity.groupObject.Find(Id);
Obj.isActive = 0;
Obj.updateUserId = userId;
Obj.updateDate = DateTime.Now;
message = entity.SaveChanges().ToString();
// return Ok("OK");
return(TokenManager.GenerateToken(message));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
}
//var re = Request;
//var headers = re.Headers;
//string token = "";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid)
//{
// if (final)
// {
// try
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// groupObject Deleterow = entity.groupObject.Find(Id);
// entity.groupObject.Remove(Deleterow);
// entity.SaveChanges();
// return Ok("OK");
// }
// }
// catch
// {
// return NotFound();
// }
// }
// else
// {
// try
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// groupObject Obj = entity.groupObject.Find(Id);
// Obj.isActive = 0;
// Obj.updateUserId = userId;
// Obj.updateDate = DateTime.Now;
// entity.SaveChanges();
// return Ok("Ok");
// }
// }
// catch
// {
// return NotFound();
// }
// }
//}
//else
// return NotFound();
}
public string addObjects(int groupId)
{
string message = "";
List <objects> ListObjects = new List <objects>();
try
{
using (incposdbEntities entity = new incposdbEntities())
{
List <objects> Listtmp = entity.objects.ToList();
ListObjects = Listtmp.Select(c => new objects
{
objectId = c.objectId,
name = c.name,
note = c.note,
createDate = c.createDate,
updateDate = c.updateDate,
createUserId = c.createUserId,
updateUserId = c.updateUserId,
parentObjectId = c.parentObjectId,
objectType = c.objectType,
})
.ToList();
}
}
catch
{
message = "0";
return(message);
//return ex.ToString();
}
groupObject groupObjectitem = new groupObject();
List <groupObject> groupObjectsList = new List <groupObject>();
foreach (var item in ListObjects)
{
groupObjectitem = new groupObject();
groupObjectitem.groupId = groupId;
groupObjectitem.objectId = item.objectId;
if (item.objectType == "one" || item.objectType == "alert")
{
groupObjectitem.showOb = 0;
groupObjectitem.addOb = 2;
groupObjectitem.updateOb = 2;
groupObjectitem.deleteOb = 2;
groupObjectitem.reportOb = 2;
}
else
{
groupObjectitem.showOb = 0;
groupObjectitem.addOb = 0;
groupObjectitem.updateOb = 0;
groupObjectitem.deleteOb = 0;
groupObjectitem.reportOb = 0;
}
groupObjectitem.levelOb = 0;
groupObjectitem.notes = "";
// groupObjectitem.createUserId = MainWindow.userID;
// groupObjectitem.updateUserId = MainWindow.userID;
groupObjectitem.isActive = 1;
groupObjectsList.Add(groupObjectitem);
}
using (incposdbEntities entity = new incposdbEntities())
{
if (groupObjectsList.Count > 0)
{
for (int i = 0; i < groupObjectsList.Count; i++)
{
groupObjectsList[i].createDate = DateTime.Now;
groupObjectsList[i].updateDate = DateTime.Now;
entity.groupObject.Add(groupObjectsList[i]);
try
{
message = entity.SaveChanges().ToString();
}
catch
{
message = "0";
return(message);
//return ex.ToString();
}
}
}
}
return(message);
}
public String Save(string token)
{
//string Object
string message = "";
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string Object = "";
groupObject newObject = null;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "Object")
{
Object = c.Value.Replace("\\", string.Empty);
Object = Object.Trim('"');
newObject = JsonConvert.DeserializeObject <groupObject>(Object, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
break;
}
}
if (newObject != null)
{
// bondes tmpObject = null;
try
{
if (newObject.groupId == 0 || newObject.groupId == null)
{
Nullable <int> id = null;
newObject.groupId = id;
}
if (newObject.objectId == 0 || newObject.objectId == null)
{
Nullable <int> id = null;
newObject.objectId = id;
}
if (newObject.updateUserId == 0 || newObject.updateUserId == null)
{
Nullable <int> id = null;
newObject.updateUserId = id;
}
if (newObject.createUserId == 0 || newObject.createUserId == null)
{
Nullable <int> id = null;
newObject.createUserId = id;
}
using (incposdbEntities entity = new incposdbEntities())
{
var sEntity = entity.Set <groupObject>();
if (newObject.id == 0)
{
newObject.createDate = DateTime.Now;
newObject.updateDate = DateTime.Now;
newObject.updateUserId = newObject.createUserId;
sEntity.Add(newObject);
message = newObject.groupId.ToString();
entity.SaveChanges();
}
else
{
var tmps = entity.groupObject.Where(p => p.id == newObject.id).FirstOrDefault();
tmps.id = newObject.id;
tmps.groupId = newObject.groupId;
tmps.objectId = newObject.objectId;
tmps.notes = newObject.notes;
tmps.addOb = newObject.addOb;
tmps.updateOb = newObject.updateOb;
tmps.deleteOb = newObject.deleteOb;
tmps.showOb = newObject.showOb;
//tmps.isActive = newObject.isActive;
tmps.reportOb = newObject.reportOb;
tmps.levelOb = newObject.levelOb;
tmps.createDate = newObject.createDate;
tmps.updateDate = DateTime.Now;// server current date
tmps.updateUserId = newObject.updateUserId;
entity.SaveChanges();
message = tmps.id.ToString();
}
}
//return message;
return(TokenManager.GenerateToken(message));
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
}
}
return(TokenManager.GenerateToken(message));
}
//var re = Request;
//var headers = re.Headers;
//string token = "";
//string message ="";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid)
//{
// newObject = newObject.Replace("\\", string.Empty);
// newObject = newObject.Trim('"');
// groupObject Object = JsonConvert.DeserializeObject<groupObject>(newObject, new JsonSerializerSettings { DateParseHandling = DateParseHandling.None });
// try
// {
// if (Object.groupId == 0 || Object.groupId == null)
// {
// Nullable<int> id = null;
// Object.groupId = id;
// }
// if (Object.objectId == 0 || Object.objectId == null)
// {
// Nullable<int> id = null;
// Object.objectId = id;
// }
// if (Object.updateUserId == 0 || Object.updateUserId == null)
// {
// Nullable<int> id = null;
// Object.updateUserId = id;
// }
// if (Object.createUserId == 0 || Object.createUserId == null)
// {
// Nullable<int> id = null;
// Object.createUserId = id;
// }
// using (incposdbEntities entity = new incposdbEntities())
// {
// var sEntity = entity.Set<groupObject>();
// if (Object.id == 0)
// {
// Object.createDate = DateTime.Now;
// Object.updateDate = DateTime.Now;
// Object.updateUserId = Object.createUserId;
// sEntity.Add(Object);
// message = Object.groupId.ToString();
// entity.SaveChanges();
// }
// else
// {
// var tmps = entity.groupObject.Where(p => p.id == Object.id).FirstOrDefault();
// tmps.id = Object.id;
// tmps.groupId = Object.groupId;
// tmps.objectId = Object.objectId;
// tmps.notes = Object.notes;
// tmps.addOb = Object.addOb;
// tmps.updateOb = Object.updateOb;
// tmps.deleteOb = Object.deleteOb;
// tmps.showOb = Object.showOb;
// //tmps.isActive = Object.isActive;
// tmps.reportOb = Object.reportOb;
// tmps.levelOb = Object.levelOb;
// tmps.createDate=Object.createDate;
// tmps.updateDate = DateTime.Now;// server current date
// tmps.updateUserId = Object.updateUserId;
// entity.SaveChanges();
// message = tmps.id.ToString();
// }
// }
// return message; ;
// }
// catch
// {
// return "-1";
// }
//}
//else
// return "-1";
}
