public ReturnValues AddRemoveSellProductQty(AddRemoveQty pr)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("AddRemoveProductQty", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@productId", pr.productId);
cmd.Parameters.AddWithValue("@userid", pr.userId);
cmd.Parameters.AddWithValue("@businessid", pr.businessId);
cmd.Parameters.AddWithValue("@addRemove", pr.ActionType);
cmd.Parameters.AddWithValue("@Qty", pr.Qty);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
return(rv);
}
}
/// <summary>
/// 执行对具体设备的数据更新
/// </summary>
/// <param name="machine">设备的实例</param>
/// <returns></returns>
protected override async Task RunTask(IMachineProperty <string> machine)
{
try
{
var ans = await GetValue(machine);
ReturnValues?.Invoke(new TaskReturnDef
{
MachineId = machine.Id,
ReturnValues = ans
});
}
catch (Exception e)
{
if (!machine.IsConnected)
{
MoveMachineToUnlinked(machine.Id);
}
ReturnValues?.Invoke(new TaskReturnDef
{
MachineId = machine.Id,
ReturnValues = null
});
}
}
public IList <DistrictsDTO> GetDistricts(DistrictParametersGetAll districtParametersGetAll, out ReturnValues returnValues)
{
IList <DistrictsDTO> districtsDTO = null;
returnValues = new ReturnValues();
var CityID = String.IsNullOrEmpty(districtParametersGetAll.CityID) ? "" : districtParametersGetAll.CityID;
try
{
var query = _unitOfWork.DistrictRepository.QueryableObject();
if (!String.IsNullOrEmpty(CityID))
{
districtsDTO = query
.Where(row => row.CityID == CityID)
.Select(row => new DistrictsDTO()
{
ID = row.Id,
Name = row.Name,
}).ToList();
}
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(districtsDTO as IList <DistrictsDTO>);
}
public IList <CitysDTO> GetCitys(CityParametersGetAll cityParametersGetAll, out ReturnValues returnValues)
{
IList <CitysDTO> citysDTO = null;
returnValues = new ReturnValues();
var StateID = String.IsNullOrEmpty(cityParametersGetAll.StateID) ? "" : cityParametersGetAll.StateID;
try
{
var query = _unitOfWork.CityRepository.QueryableObject();
if (!String.IsNullOrEmpty(StateID))
{
citysDTO = query
.Where(row => row.StateID == StateID)
.Select(row => new CitysDTO()
{
ID = row.Id,
Name = row.Name,
}).ToList();
}
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(citysDTO as IList <CitysDTO>);
}
private static void FillValues(object obj, out SqlInt32 theValue, out SqlChars message)
{
ReturnValues returnValues = (ReturnValues)obj;
theValue = returnValues.Value;
message = new SqlChars(returnValues.Message);
}
public JsonObject ToJson()
{
var json = new JsonObject {
{ "TableName", TableName },
{ "Key", Key.ToJson() }
};
if (ConditionExpression != null)
{
json.Add("ConditionExpression", ConditionExpression);
}
if (ExpressionAttributeNames != null)
{
json.Add("ExpressionAttributeNames", ExpressionAttributeNames);
}
if (ExpressionAttributeValues != null)
{
json.Add("ExpressionAttributeValues", ExpressionAttributeValues.ToJson());
}
if (ReturnValues != ReturnValues.NONE)
{
json.Add("ReturnValues", ReturnValues.ToString());
}
return(json);
}
public void AddModifyRawMaterialDistributionItem(ItemQty itm)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("RawMaterialDistributionItemsLog", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ItemId", itm.ItemId);
cmd.Parameters.AddWithValue("@RawMaterialDisID", itm.RawMaterialDisId);
cmd.Parameters.AddWithValue("@rawMaterialId", itm.RawMaterialId);
cmd.Parameters.AddWithValue("@Qty", itm.Qty);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
// return rv;
}
public ReturnValues CalcDiscount(DateTime currentYear, decimal salary)
{
decimal percentageValue = 0m;
decimal calcValue = 0m;
decimal tetoDoze = 500.00m;
decimal tetoOnze = 405.86m;
if ((salary < tetoDoze && currentYear.Year == 2012))
{
var cl = Search(c => c.InitialValue >= salary && c.EndValues <= salary && c.Date.Year == currentYear.Year).FirstOrDefault();
calcValue = ((Decimal)cl.DiscountPercentage / 100) * salary;
if (calcValue >= tetoDoze)
{
calcValue = tetoDoze;
}
percentageValue = calcValue;
}
if ((salary < tetoOnze && currentYear.Year == 2011))
{
decimal teto = tetoOnze;
var cl = Search(c => c.InitialValue >= salary && c.EndValues <= salary && c.Date.Year == currentYear.Year).FirstOrDefault();
calcValue = ((Decimal)cl.DiscountPercentage / 100) * salary;
if (calcValue >= tetoOnze)
{
calcValue = tetoOnze;
}
percentageValue = calcValue;
}
var returnValues = new ReturnValues {
values = percentageValue
};
return(returnValues);
}
public Object GetJsonObject(Object _ReturnedData, ReturnValues rv)
{
var result = (Object)null;
result = new { StatusCode = rv.StatusCode, StatusMessage = rv.StatusMessage, ReturnedData = _ReturnedData };
return(result);
}
public static ReturnValues <Image> CreateThumbnail(string filePath, int width, int height)
{
var result = new ReturnValues <Image>();
try
{
FileInfo fi = new FileInfo(filePath);
if (fi.Exists)
{
using (FileStream fs = File.OpenRead(fi.FullName))
using (Image image = Image.FromStream(fs, false, false))
using (Image pThumbnail = image.GetThumbnailImage(width, height, delegate { return(false); }, IntPtr.Zero))
{
result.Success(fi.Length, pThumbnail);
}
}
else
{
result.Error("대상 파일이 존재하지 않습니다.");
}
}
catch (Exception ex)
{
result.Error(ex);
}
return(result);
}
public IHttpActionResult PostRawMaterialDisbursement([FromBody] RawDisbursement rd)
{
var result = (Object)null;
var ReturnedData = (Object)null;
if (rd.BusinessId > 0 && rd.UserId > 0 && rd.ProductManagerId > 0)
{
if (cuc.ConfirmRawMaterialIDAgainstBusinessID(rd.BusinessId, rd.ProductManagerId, 2) == 1)
{
rv = st.AddModifyRawMaterialDistribution(rd);
result = cuc.GetJsonObject(ReturnedData, rv);
}
else
{
rv.StatusCode = 7; rv.StatusMessage = "This product manager does not exist in your business";
result = cuc.GetJsonObject(ReturnedData, rv);
}
}
else
{
rv.StatusCode = 6; rv.StatusMessage = "you did not supply businessid or userid or productManagerId";
result = cuc.GetJsonObject(ReturnedData, rv);
}
return(Ok(result));
}
protected ResponseBase(NodeId id, BEncodedValue transactionId)
: base(_responseType)
{
Properties.Add(_returnValuesKey, new BEncodedDictionary());
ReturnValues.Add(IdKey, id.BencodedString());
TransactionId = transactionId;
}
public StarsDTO GetGasStationStarts(GasStationsParametersID gasStationsParametersID, out ReturnValues returnValues)
{
StarsDTO starsDTO = null;
returnValues = new ReturnValues();
int ID = Convert.ToInt32(gasStationsParametersID.ID);
var countTotal = _unitOfWork.AssessmentRepository.QueryableObject()
.Where(row => row.GasStaionID == ID)
.Count();
var countPositive = _unitOfWork.AssessmentRepository.QueryableObject()
.Where(row => row.GasStaionID == ID && row.Assessment1 == true)
.Count();
var countNegative = _unitOfWork.AssessmentRepository.QueryableObject()
.Where(row => row.GasStaionID == ID && row.Assessment1 == false)
.Count();
starsDTO = new StarsDTO
{
GasStaionID = ID.ToString(),
Total = countTotal.ToString(),
Positive = countPositive.ToString(),
Negative = countNegative.ToString()
};
return(starsDTO);
}
private ReturnValues posterise_5level_custom2(int[] notused)
{
// First row = Input
// Second row = Output
// e.g. Between 0 and 24, output 0
// Between 25 and 49, output 38
// Between 50 and 99, output 75
// etc.
string a = @"
0 75 150 200 228 255
0 113 175 214 255
";
var data = ParseString(a);
var rv = new ReturnValues();
int pos = 0;
for (int i = 0; i < 256; i++)
{
if ((pos < data.Length - 1) && // avoid array out-of-bounds
(i == data[pos + 1].InValue)) // check next value
{
pos++;
}
rv.AssignValue(i, data[pos].OutValue);
}
return(rv);
}
public IHttpActionResult Register([FromBody] BizRegModel bizRegModel)
{
var result = (Object)null;
var ReturnedData = (Object)null;
if (Request.Headers.Contains("API-KEY"))
{
string apikey = Request.Headers.GetValues("API-KEY").First();
if (apikey == CommonUtilityClass.apikey)
{
Authentication at = new Authentication();
rv = at.RegisterBusiness(bizRegModel);
result = cuc.GetJsonObject(ReturnedData, rv);
return(Ok(result));
}
else
{
return(Content(HttpStatusCode.Unauthorized, cuc.GetJsonObject(ReturnedData, cuc.Error(1))));
}
}
else
{
return(Content(HttpStatusCode.Forbidden, cuc.GetJsonObject(ReturnedData, cuc.Error(2))));
}
}
public ReturnValues ChangePassword(ChangePassword cp)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("ChangePassword", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", cp.businessid);
cmd.Parameters.AddWithValue("@userid", cp.UserID);
cmd.Parameters.AddWithValue("@oldpass", cp.OldPassword);
cmd.Parameters.AddWithValue("@newpass", cp.NewPassword);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public ReturnValues CreateEditStore(ShopModel sm)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("CreateNewStore", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StoreId", sm.StoreId);
cmd.Parameters.AddWithValue("@userId", sm.UserId);
cmd.Parameters.AddWithValue("@businessId", sm.BusinessId);
cmd.Parameters.AddWithValue("@StoreName", sm.StoreName);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 100);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
return(rv);
}
}
public ReturnValues ShopKeeperAcceptApproveSendToShop(AdminApprove adap)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("ShopKeeperAcceptsFinishProductToShop", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", adap.UserId);
cmd.Parameters.AddWithValue("@BusinessId", adap.BusinessId);
cmd.Parameters.AddWithValue("@ItemApprovalId", adap.ItemApprovalId);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 100);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
Console.WriteLine("We are catching an exception");
CommonUtilityClass.ExceptionLog(ex);
Console.WriteLine(ex.Message);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public ReturnValues RegisterBusiness(BizRegModel bzm)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("RegisterBusinessAccount", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessname", bzm.businessName);
cmd.Parameters.AddWithValue("@businessAddress", bzm.businessAddress);
cmd.Parameters.AddWithValue("@fullname", bzm.fullname);
cmd.Parameters.AddWithValue("@email", bzm.email);
cmd.Parameters.AddWithValue("@phone", bzm.phone);
cmd.Parameters.AddWithValue("@password", bzm.password);
cmd.Parameters.Add("@returnvalue", System.Data.SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public IList <StatesDTO> GetStates(StateParametersGetAll stateParametersGetAll, out ReturnValues returnValues)
{
IList <StatesDTO> statesDTO = null;
returnValues = new ReturnValues();
try
{
var query = _unitOfWork.StateRepository.QueryableObject();
statesDTO = query.Select(row => new StatesDTO()
{
ID = row.Id,
Name = row.Name
}).ToList();
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(statesDTO as IList <StatesDTO>);
}
public ReturnValue GetSampleMessage()
{
var temp = new ReturnValues <List <long> >();
var result = new ReturnValue();
if (MainActivity.MainActivityInstance != null)
{
try
{
temp = MainActivity.MainActivityInstance.ContentResolver.FindLastKey();
if (result.Check)
{
Coupon coupon = null;
foreach (long num in temp.Data)
{
coupon = MainActivity.MainActivityInstance.ContentResolver.GetMMS(num);
if (coupon != null)
{
string content = JsonConvert.SerializeObject(coupon);
string key = Repository.GetMyPhoneNumber(MainActivity.MainActivityInstance);
string url = "http:" + $"//giftipangpang.com/Api/External/Log";
var paramData = new FormUrlEncodedContent(new[]
{
new KeyValuePair <string, string>("key", key),
new KeyValuePair <string, string>("content", content)
});
ApiClient client = new ApiClient();
string tmp = client.PostRequest(url, paramData);
if (!string.IsNullOrWhiteSpace(tmp))
{
result = JsonConvert.DeserializeObject <ReturnValue>(tmp);
if (result.Check)
{
result.Message = "ok";
break;
}
}
else
{
result.Error("ReturnValue is Empty!!");
}
}
}
}
}
catch (Exception ex)
{
result.Error(ex);
}
}
else
{
result.Error("MainActivity is null.");
}
return(result);
}
static void AssemblyLoadHandler(object sender, AssemblyLoadEventArgs args)
{
AssemblyName aName = args.LoadedAssembly.GetName();
if (IsAssemblyNameSystemXml(aName))
{
retValue = ReturnValues.WRITERLOADED;
}
}
public IHttpActionResult ChangePassword([FromBody] ChangePassword cp)
{
var result = (Object)null;
var ReturnedData = (Object)null;
rv = at.ChangePassword(cp);
result = cuc.GetJsonObject(ReturnedData, rv);
return(Ok(result));
}
public Task <DeleteItemResult> DeleteAsync(Key <T> key, ReturnValues returnValues)
{
var request = new DeleteItemRequest(tableName, key)
{
ReturnValues = returnValues
};
return(InternalDelete(request));
}
public ReturnValues ChangePassword(ChangeUserPassword obj)
{
try
{
ReturnValues result = null;
if (obj != null)
{
using (RepsistoryEF <UserRegister> _o = new RepsistoryEF <UserRegister>())
{
var resultValue = _o.GetListBySelector(z => z.RegistrationID == obj.RegistrationID).FirstOrDefault();
if (resultValue != null)
{
if (resultValue.Password == obj.OldPassword)
{
resultValue.Password = obj.NewPassword;
_o.Update(resultValue);
result = new ReturnValues
{
Success = "Password Changed Successfully",
Source = resultValue.RegistrationID.ToString(),
};
}
else
{
result = new ReturnValues
{
Success = "Old password is not correct.<br/>Please try again.",
Source = resultValue.RegistrationID.ToString(),
};
}
}
else
{
result = new ReturnValues
{
Success = "Password could not be changed.",
Source = "0",
};
}
}
}
return(result);
}
catch (Exception ex)
{
ReturnValues objex = new ReturnValues
{
Failure = ex.Message,
};
throw ex;
}
finally
{
}
}
/// <summary>
/// ค้นหา SearchHistory
/// </summary>
public JsonDataTableResult SearchAsync(FormCollection formcollection)
{
ReturnValues <TransactionViewModels> returnData = new ReturnValues <TransactionViewModels>();
DataTableJSON <TransactionViewModels> dataTable = new DataTableJSON <TransactionViewModels>();
DataTableProperty dataTableProperty = DataTableProperty.Get(formcollection);
List <TransactionViewModels> data = new List <TransactionViewModels>();
try
{
int total = 0;
int skip = dataTableProperty.StartRecord;
int limit = dataTableProperty.EndRecord;
string type_transaction = formcollection["type_transaction"].ToString();
string keyword = formcollection["keyword"].ToString();
string path = "http://122.155.202.166/api/controller/transaction_controller.php?type=" + type_transaction;
if (!string.IsNullOrEmpty(keyword))
{
path = "http://122.155.202.166/api/controller/transaction_controller.php?keyword=" + keyword + "&type=" + type_transaction;
}
JObject result = Request(keyword, path);
if (result != null)
{
if (result["data"] != null)
{
data = JsonConvert.DeserializeObject <List <TransactionViewModels> >(result["data"].ToString());
total = data.Count;
data = data.Skip(dataTableProperty.StartRecord).Take(dataTableProperty.EndRecord).ToList();
}
}
returnData = new ReturnValues <TransactionViewModels>();
returnData.Data = data;
returnData.TotalRecord = total;
returnData.Size = total;
}
catch (Exception ex)
{
notifyMsg(NotifyMsgType.Error, ex.Message);
returnData = new ReturnValues <TransactionViewModels>();
returnData.Data = new List <TransactionViewModels>();
returnData.TotalRecord = 0;
returnData.Size = 0;
}
dataTable.Echo = dataTableProperty.Echo;
dataTable.TotalDisplayRecords = returnData.TotalRecord;
dataTable.TotalRecords = returnData.TotalRecord;
dataTable.Data = returnData.Data;
return(new JsonDataTableResult(dataTable, JsonRequestBehavior.AllowGet));
}
public ReturnValues <Papago> Translation(Papago data, IWebClient wc)
{
var result = new ReturnValues <Papago>();
if (string.IsNullOrWhiteSpace(data.text))
{
result.Error("번역 대상이 없습니다.");
}
else if (data.text.Trim().Length >= 5000)
{
result.Error("1회 번역 최대 문자열은 5000 글자 입니다.");
}
else
{
try
{
string tmp = wc.DownloadString(data.CreateURL());
if (!string.IsNullOrWhiteSpace(tmp))
{
HtmlAgilityPack.HtmlDocument document = new HtmlAgilityPack.HtmlDocument();
document.LoadHtml(tmp);
HtmlAgilityPack.HtmlNode targetObject = document.GetElementbyId("txtTarget");
if (targetObject != null)
{
data.Result = targetObject.InnerText.Trim();
result.Success(1, data);
}
else
{
var nodes = document.DocumentNode.SelectSingleNode("//div[@id='txtTarget']");
if (nodes != null)
{
data.Result = nodes.InnerText.Trim();
result.Success(1, data);
}
else
{
result.Error("Not Found Target!!!!");
result.Value = tmp;
}
}
}
}
catch (Exception ex)
{
result.Error(ex);
if (this.Logger != null)
{
this.Logger.Error(ex);
}
}
}
return(result);
}
//private void linear()
//{
// foreach (var array in new[] { _transformR, _transformG, _transformB })
// for (int i = 0; i < 256; i++)
// array[i] = i;
//}
//private void noise1()
//{
// for (int i = 0; i < 256; i++)
// foreach (var transform in new[] { _transformR, _transformG, _transformB })
// transform[i] = Clamp(i +
// (((i / 2) % 2 == 0) ? (int)slider1.Value : 0 - (int)slider1.Value));
//}
//private void noise2()
//{
// Random r = new Random();
// for (int i = 0; i < 256; i++)
// foreach (var transform in new[] { _transformR, _transformG, _transformB })
// transform[i] = Clamp(i + (0 - ((int)slider1.Value / 2)) + r.Next((int)slider1.Value));
//}
//private void noise3()
//{
// int step =(int)slider1.Value;
// for (int i = 0; i < 256; i++)
// foreach (var transform in new[] { _transformR, _transformG, _transformB })
// transform[i] = Clamp(i +
// (step - (i % step) - (i % step)));
//}
//private int Clamp(int val)
//{
// if (val < 0) return 0;
// if (val > 255) return 255;
// return val;
//}
//private void posterise1()
//{
// double posterise_multiplier = 255.0 / (int)slider1.Value;
// for (int i = 0; i < 256; i++)
// foreach (var transform in new[] { _transformR, _transformG, _transformB })
// transform[i] = (int)(Convert.ToInt32(i / posterise_multiplier) * posterise_multiplier);
//}
//private void posterise2()
//{
// int posterise_level = (int)slider1.Value;
// if (posterise_level <= 1)
// throw new Exception("Posterise level 1 or below not allowed");
// double multiplier = 255.0 / (posterise_level - 1.0);
// foreach (var transform in new[] { _transformR, _transformG, _transformB })
// {
// for (int i = 0; i < 256; i++)
// {
// int index = (int)Math.Floor(i * (posterise_level / 256.0));
// transform[i] = (int)Math.Round(index * multiplier);
// }
// }
//}
//private void posterise_3level_custom2()
//{
// int threshold1 = (int)slider1.Value;
// int threshold2 = (int)slider2.Value;
// int threshold3 = (int)slider3.Value;
// foreach (var transform in new[] { _transformR, _transformG, _transformB })
// {
// for (int i = 0; i < 256; i++)
// {
// if (transform == _transformG)
// // 3 bit
// transform[i] = i >= threshold2 ? 255
// : i >= threshold3 ? 170
// : i >= threshold1 ? 85
// : 0;
// else
// // 2 bit
// transform[i] = i >= threshold2 ? 255
// : i >= threshold1 ? 128
// : 0;
// }
// }
//}
private ReturnValues posterise_2level_custom(int[] sliderValues)
{
int threshold = sliderValues[0];
var rv = new ReturnValues();
for (int i = 0; i < 256; i++)
{
rv.AssignValue(i, i >= threshold ? 255 : 0);
}
return(rv);
}
public Document PartialUpdateCommand <T>(T tObject, ReturnValues returnValues = ReturnValues.AllNewAttributes)
{
var document = AWSDocumentConverter.ToDocument(tObject);
UpdateItemOperationConfig config = new UpdateItemOperationConfig
{
ReturnValues = returnValues
};
return(dynamoDBTable.UpdateItem(document, config));
}
public GasStationsDTO GetGasStationsByID(GasStationsParametersID gasStationsParametersID, out ReturnValues returnValues)
{
GasStation gasStation;
GasStationsDTO gasStationsDTO = null;
returnValues = new ReturnValues();
int ID = Convert.ToInt32(gasStationsParametersID.ID);
try
{
gasStation = _unitOfWork.GasStationRepository.Get(row => row.ID == ID);
if (gasStation == null)
{
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(gasStationsDTO);
}
gasStationsDTO = new GasStationsDTO
{
ID = gasStation.ID.ToString(),
Status = gasStation.Status.ToString(),
Name = gasStation.Name,
Phone = gasStation.Phone,
GasolinaComum = gasStation.GasolinaComum.ToString(),
GasolinaAditivada = gasStation.GasolinaAditivada.ToString(),
Disel = gasStation.Disel.ToString(),
Gas = gasStation.Gas.ToString(),
PriceGasolinaComum = gasStation.PriceGasolinaComum.ToString(),
PriceGasolinaAditivada = gasStation.PriceGasolinaAditivada.ToString(),
PriceDisel = gasStation.PriceDisel.ToString(),
PriceGas = gasStation.PriceGas.ToString(),
Latitude = gasStation.Latitude,
Longitude = gasStation.Longitude,
CEP = gasStation.CEP,
Address = gasStation.Address,
Number = gasStation.Number,
DistrictID = gasStation.DistrictID,
CityID = gasStation.CityID,
StateID = gasStation.StateID,
CreatedOn = gasStation.CreatedOn.ToString(),
UpdatedOn = gasStation.UpdatedOn.ToString()
};
gasStationsDTO.lastUpdatePrice = GetlastUpdatePrice(gasStationsDTO.ID);
gasStationsDTO.NamelastUpdatePrice = GetNamelastUpdatePrice(gasStationsDTO.ID);
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(gasStationsDTO);
}
public static IEnumerable GetNumbers(SqlInt32 MaxValue)
{
if (MaxValue.IsNull)
{ yield break; }
// we do not need the Generic List of <ReturnValues>
ReturnValues Vals = new ReturnValues(); // each row
for (int index = 1; index <= MaxValue.Value; index++)
{
Vals.Value = index;
yield return Vals; // return row per each itteration
}
// we do not need to return everything at once
}
public static string Convert(ReturnValues value)
{
switch (value)
{
case ReturnValues.None:
return "NONE";
case ReturnValues.AllOldAttributes:
return "ALL_OLD";
case ReturnValues.AllNewAttributes:
return "ALL_NEW";
case ReturnValues.UpdatedOldAttributes:
return "UPDATED_OLD";
case ReturnValues.UpdatedNewAttributes:
return "UPDATED_NEW";
default:
throw new ArgumentOutOfRangeException("Invalid ReturnValues value");
}
}
