public setValues GetRowBySettingName(string settingName)
{
setValues sv = new setValues();
List <setValues> svl = new List <setValues>();
// DateTime cmpdate = DateTime.Now.AddDays(newdays);
try
{
using (incposdbEntities entity = new incposdbEntities())
{
setting sett = entity.setting.Where(s => s.name == settingName).FirstOrDefault();
var svlv = entity.setValues.ToList();
svl = svlv.Where(x => sett.settingId == x.settingId)
.Select(X => new setValues
{
valId = X.valId,
value = X.value,
isDefault = X.isDefault,
isSystem = X.isSystem,
settingId = X.settingId,
notes = X.notes,
}).ToList();
sv = svl.FirstOrDefault();
return(sv);
}
}
catch
{
sv = new setValues();
// return ex.ToString();
return(sv);
}
}
public string Delete(string token)
{
// public ResponseVM Delete(string token)int Id, int userId
//int Id, int userId
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;
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);
}
}
try
{
using (incposdbEntities entity = new incposdbEntities())
{
setValues sObj = entity.setValues.Find(Id);
entity.setValues.Remove(sObj);
message = entity.SaveChanges().ToString();
}
return(TokenManager.GenerateToken(message));
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
//var re = Request;
//
//string token = "";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid)
//{
// try
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// setValues sObj = entity.setValues.Find(Id);
// entity.setValues.Remove(sObj);
// entity.SaveChanges();
// return Ok("medal is Deleted Successfully");
// }
// }
// catch
// {
// return NotFound();
// }
//}
//else
// return NotFound();
}
public string SaveValueByNotes(string token)
{
//string Object string newObject
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 = "";
setValues 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 <setValues>(Object, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
break;
}
}
if (newObject != null)
{
setValues tmpObject = null;
try
{
if (newObject.settingId == 0 || newObject.settingId == null)
{
Nullable <int> id = null;
newObject.settingId = id;
}
using (incposdbEntities entity = new incposdbEntities())
{
setValues defItem = new setValues();
var sEntity = entity.Set <setValues>();
defItem = entity.setValues.Where(p => p.settingId == newObject.settingId).FirstOrDefault();
if (newObject.valId == 0)
{
if (newObject.isDefault == 1)
{
// get the row with same settingId of newObject
if (defItem != null)
{
defItem.isDefault = 0;
entity.SaveChanges();
}
}
else //newObject.isDefault ==0
{
if (defItem == null)//other values isDefault not 1
{
newObject.isDefault = 1;
}
}
sEntity.Add(newObject);
message = newObject.valId.ToString();
entity.SaveChanges();
}
else
{
if (newObject.isDefault == 1)
{
defItem.isDefault = 0;//reset the other default to 0 if exist
}
var tmps1 = sEntity.ToList();
tmpObject = tmps1.Where(p => p.notes == newObject.notes && p.settingId == newObject.settingId && p.valId == newObject.valId).FirstOrDefault();
// tmpObject.valId = newObject.valId;
// tmpObject.notes = newObject.notes;
tmpObject.value = newObject.value;
tmpObject.isDefault = newObject.isDefault;
tmpObject.isSystem = newObject.isSystem;
tmpObject.settingId = newObject.settingId;
entity.SaveChanges();
message = tmpObject.valId.ToString();
}
}
return(TokenManager.GenerateToken(message));
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
}
}
return(TokenManager.GenerateToken(message));
}
//var re = Request;
//
//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('"');
// setValues Object = JsonConvert.DeserializeObject<setValues>(newObject, new JsonSerializerSettings { DateParseHandling = DateParseHandling.None });
// try
// {
// if (Object.settingId == 0 || Object.settingId == null)
// {
// Nullable<int> id = null;
// Object.settingId = id;
// }
// using (incposdbEntities entity = new incposdbEntities())
// {
// setValues defItem = new setValues();
// var sEntity = entity.Set<setValues>();
// defItem = entity.setValues.Where(p => p.settingId == Object.settingId ).FirstOrDefault();
// if (Object.valId == 0)
// {
// if (Object.isDefault == 1)
// {
// // get the row with same settingId of newObject
// if (defItem != null)
// {
// defItem.isDefault = 0;
// entity.SaveChanges();
// }
// }
// else //Object.isDefault ==0
// {
// if (defItem == null)//other values isDefault not 1
// {
// Object.isDefault = 1;
// }
// }
// sEntity.Add(Object);
// message = Object.valId.ToString();
// entity.SaveChanges();
// }
// else
// {
// if (Object.isDefault == 1)
// {
// defItem.isDefault = 0;//reset the other default to 0 if exist
// }
// var tmps1 = sEntity.ToList();
// var tmps = tmps1.Where(p => p.notes == Object.notes && p.settingId == Object.settingId && p.valId == Object.valId).FirstOrDefault();
// // tmps.valId = Object.valId;
// // tmps.notes = Object.notes;
// tmps.value = Object.value;
// tmps.isDefault = Object.isDefault;
// tmps.isSystem = Object.isSystem;
// tmps.settingId = Object.settingId;
// entity.SaveChanges();
// message = tmps.valId.ToString();
// }
// }
// return message; ;
// }
// catch (Exception ex)
// {
// return ex.ToString();
// }
//}
//else
// return "-2";
}
public int Save(setValues newObject)
{
//string Object string newObject
string message = "";
int res = 0;
if (newObject != null)
{
setValues tmpObject = null;
try
{
if (newObject.settingId == 0 || newObject.settingId == null)
{
Nullable <int> id = null;
newObject.settingId = id;
}
using (incposdbEntities entity = new incposdbEntities())
{
var sEntity = entity.Set <setValues>();
setValues defItem = entity.setValues.Where(p => p.settingId == newObject.settingId && p.isDefault == 1).FirstOrDefault();
if (newObject.valId == 0)
{
if (newObject.isDefault == 1)
{ // get the row with same settingId of newObject
if (defItem != null)
{
defItem.isDefault = 0;
entity.SaveChanges();
}
}
else //Object.isDefault ==0
{
if (defItem == null)//other values isDefault not 1
{
newObject.isDefault = 1;
}
}
sEntity.Add(newObject);
res = newObject.valId;
message = res.ToString();
entity.SaveChanges();
}
else
{
//update
if (newObject.isDefault == 1)
{
defItem.isDefault = 0;//reset the other default to 0 if exist
}
tmpObject = entity.setValues.Where(p => p.valId == newObject.valId).FirstOrDefault();
tmpObject.valId = newObject.valId;
tmpObject.notes = newObject.notes;
tmpObject.value = newObject.value;
tmpObject.isDefault = newObject.isDefault;
tmpObject.isSystem = newObject.isSystem;
tmpObject.settingId = newObject.settingId;
entity.SaveChanges();
res = tmpObject.valId;
message = res.ToString();
}
}
return(res);
}
catch
{
message = "0";
return(0);
}
}
return(res);
}
public string UpdateImage(string token)
{
//SetValuesObject
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 = "";
setValues 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 <setValues>(Object, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
}
}
if (newObject != null)
{
try
{
setValues Setvalue;
using (incposdbEntities entity = new incposdbEntities())
{
var Entity = entity.Set <setValues>();
Setvalue = entity.setValues.Where(p => p.valId == newObject.valId).First();
Setvalue.value = newObject.value;
entity.SaveChanges();
}
// return Setvalue.valId;
return(TokenManager.GenerateToken(Setvalue.valId.ToString()));
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
}
}
else
{
return(TokenManager.GenerateToken(message));
}
}
//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);
//SetValuesObject = SetValuesObject.Replace("\\", string.Empty);
//SetValuesObject = SetValuesObject.Trim('"');
//setValues setvalObj = JsonConvert.DeserializeObject<setValues>(SetValuesObject, new JsonSerializerSettings { DateParseHandling = DateParseHandling.None });
///*
//if (userObj.updateUserId == 0 || userObj.updateUserId == null)
//{
// Nullable<int> id = null;
// userObj.updateUserId = id;
//}
//if (userObj.createUserId == 0 || userObj.createUserId == null)
//{
// Nullable<int> id = null;
// userObj.createUserId = id;
//}
//*/
//if (valid)
//{
// try
// {
// setValues Setvalue;
// using (incposdbEntities entity = new incposdbEntities())
// {
// var Entity = entity.Set<setValues>();
// Setvalue = entity.setValues.Where(p => p.valId == setvalObj.valId).First();
// Setvalue.value = setvalObj.value;
// entity.SaveChanges();
// }
// return Setvalue.valId;
// }
// catch
// {
// return 0;
// }
//}
//else
// return 0;
}
