public ResponseForm <int> DeleteListId(string LIST_ID, string USER_ID)
{
if (!string.IsNullOrWhiteSpace(LIST_ID))
{
LIST_ID = LIST_ID.Replace(",", "','");
try
{
DynamicParameters param = new DynamicParameters();
string sql = @"update DO_NOT_CALL_LIST set DELETED = 1, MODIFIED_USER_ID = @MODIFIED_USER_ID, DATE_MODIFIED = @DATE_MODIFIED where ID in ('" + LIST_ID + "')";
param.Add("@DATE_MODIFIED", DateTime.Now);
param.Add("@MODIFIED_USER_ID", USER_ID);
DapperORM.ExcecuteNonReturn(sql, param);
sql = @"update DNC_CAMPAIGN_CATEGORY set DELETED = 1 where ID_DNC in ('" + LIST_ID + "')";
DapperORM.ExcecuteNonReturn(sql);
ResponseForm <int> response = new ResponseForm <int>(1, "ok", 200);
return(response);
}
catch (Exception e)
{
ResponseForm <int> response = new ResponseForm <int>(-1, e.Message, 600);
return(response);
}
}
else
{
ResponseForm <int> response = new ResponseForm <int>(-1, "Tùy", 400);
return(response);
}
}
public override void responseReceived(SerialComm.Packet_t p)
{
if (form == null || formWasClosed == true)
{
formWasClosed = false;
form = new ResponseForm(this);
form.FormClosing += new FormClosingEventHandler(form_FormClosing);
if (showResponseForm == true)
{
form.WindowState = FormWindowState.Normal;
form.Show();
}
}
if (showResponseForm == true)
{
//form.WindowState = FormWindowState.Normal;
//form.TopMost = true;
form.Show();
counter++;
}
lastResponse = form.updateStatus(p);
form.updateStatus(p);
if (StatusReceivedEvent != null)
{
StatusReceivedEvent(this, new StatusEventArgs(lastResponse));
}
}
public ResponseForm <int> CheckNameBranch(string ID, string NAME, string REGION_ID)
{
try
{
DynamicParameters param = new DynamicParameters();
string query = "Select count(*) from vwBRANCHS where 1 = 1 ";
if (!string.IsNullOrWhiteSpace(ID))
{
param.Add("@ID", new Guid(ID));
query += "and ID != @ID ";
}
if (!string.IsNullOrWhiteSpace(REGION_ID))
{
query += "and REGION_ID = @REGION_ID ";
param.Add("@REGION_ID", REGION_ID);
}
if (!string.IsNullOrWhiteSpace(NAME))
{
query += "and NAME like @NAME";
param.Add("@NAME", Security.Encode(NAME));
}
var branch = DapperORM.Count(query, param);
ResponseForm <int> response = new ResponseForm <int>(branch, "ok", 200);
return(response);
}
catch (Exception e)
{
ResponseForm <int> response = new ResponseForm <int>(-1, e.Message, 600);
return(response);
}
}
public void ShowResponse()
{
if (IsItemSelected && SelectedItem.Info.Result != null)
{
ResponseForm.ShowInstance(SelectedItem.Info.Result);
}
}
public IActionResult Update(string NAME, string SHORT_NAME, int RANK, string REGION_ID, string PROVINE_NAME, string BANK_STRUCT, string REGION_GROUP_C, string LOCAL_GROUP_C, string ID)
{
branchRepository.Update(NAME, SHORT_NAME, RANK, REGION_ID, PROVINE_NAME, BANK_STRUCT, REGION_GROUP_C, LOCAL_GROUP_C, ID);
ResponseForm <bool> response = new ResponseForm <bool>(true, "ok", 200);
var json = JsonConvert.SerializeObject(response);
return(Content(json, "application/json"));
}
public void ShowResponse()
{
if (IsItemSelected && SelectedItem.Info.Result != null && !string.IsNullOrEmpty(SelectedItem.Info.Result.Response))
{
using (ResponseForm form = new ResponseForm(SelectedItem.Info.Result.Response))
{
form.ShowDialog();
}
}
}
public async Task <HttpResponseMessage> UpdateResponseAsAccepted(ResponseForm responseForm)
{
var formValidation = responseForm.Validate(this.AccountSession, ValidationMode.Accept, responseForm);
if (formValidation.IsValid)
{
try
{
// get the current response
var response = this.Uow.Responses.FindById(responseForm.Id);
// create the payment processor
var paymentProcessor = new PaymentProcessor()
{
AccountSession = this.AccountSession, Logger = this.Logger
};
// wait until the payment is processed
var result = await paymentProcessor.ProcessPaymentAsync(response, responseForm.Payment);
if (result.IsSuccess())
{
// log invalid transaction
this.Logger.Warn("Payment transaction succeeded for Id {0} via user {1}", responseForm.Id, this.AccountSession.MemberId);
// extract payment transaction data
var payment = paymentProcessor.CreatePaymentTransaction(result.Target);
// handle the submission to the pending state
var results = this.Uow.Responses.UpdateResponseAsAccepted(responseForm.Id, payment);
// return the updated results
return(CreateSuccessResponse(new { success = true, results = results }, HttpStatusCode.OK));
}
else
{
// log invalid transaction
this.Logger.Warn("Payment transaction failed for Id {0} via user {1}: {2}", responseForm.Id, this.AccountSession.MemberId, result.Message);
// generate an invalid payment validation response
return(CreateInvalidResponse(BraintreeValidator.AsInvalidPayment(result)));
}
}
catch (Exception ex)
{
// log exception
Logger.Error(string.Format("Exception detected attempting to set state to accepted for Id {0} via user {1}", responseForm.Id, this.AccountSession.MemberId), ex);
return(CreateErrorResponse(ex));
}
}
// invalid parameters, generate response
return(CreateInvalidResponse(formValidation));
}
public ResponseForm <vwContact> GetDetailContact(string ID)
{
string query = "select ID,CUSTOMER_ID_C,TEN_KH_C,CMND_C,PHONE_NUMBER from vwCONTACTS where ID = @id";
DynamicParameters param = new DynamicParameters();
param.Add("@id", new Guid(ID));
var data = DapperORM.ExcecuteReturnScalar <vwContact>(query, param);
ResponseForm <vwContact> response = new ResponseForm <vwContact>(data);
return(response);
}
public IActionResult Index(ResponseForm responseForm)
{
if (ModelState.IsValid)
{
return(View("Details", responseForm));
}
else
{
return(View());
}
}
//public ResponseListForm<TemplateListDto> GetCache(string LIST_NAME, string LANG)
//{
// try
// {
// DynamicParameters param = new DynamicParameters();
// String sql = "SELECT NAME,DISPLAY_NAME,LIST_ORDER FROM vwTERMINOLOGY_List ";
// if (!string.IsNullOrEmpty(LIST_NAME))
// {
// sql += "where LIST_NAME = @LIST_NAME ";
// param.Add("@LIST_NAME", LIST_NAME);
// }
// if (!string.IsNullOrEmpty(LANG))
// {
// sql += "where LANG = @LANG ";
// param.Add("@LANG", LANG);
// }
// sql += "order by STT asc";
// var data = DapperORM.ExcecuteReturnList<TemplateListDto>(sql, param);
// return new ResponseListForm<TemplateListDto>(data, new Pagination());
// }
// catch (Exception e)
// {
// return new ResponseListForm<TemplateListDto>(null, new Pagination(), e.Message, 600);
// }
//}
public ResponseForm <int> CheckCampaignProgress(string ID)
{
try
{
string query = "Select count(*) from vwCAMPAIGNS where STATUS = 'Active' and CALLMODE_C = 'Progressive' and CAMPAIGN_CATEGORY_ID_C = '" + ID + "'";
//Console.WriteLine(NAME + " " + ID + " " + REGION_ID);
int branch = DapperORM.Count(query);
ResponseForm <int> response = new ResponseForm <int>(branch, "ok", 200);
return(response);
}
catch (Exception e)
{
ResponseForm <int> response = new ResponseForm <int>(-1, e.Message, 600);
return(response);
}
}
public IActionResult CreateCategoryCampaign([FromBody] CreateCategoryCampaignDTO createCategoryCampaign)
{
try
{
//ValidateResultDto check = validate.CreateNewCampaignCategory(createCategoryCampaign);
//if (check.code != 0) return StatusCode(check.code, new { message = check.message });
string newCatCampaign = _campaignCategoryRepository.CreateCategoryCampaign(createCategoryCampaign, User.FindFirst(ClaimTypes.NameIdentifier).Value);
ResponseForm <string> res = new ResponseForm <string>(newCatCampaign, "Record has been created successfully", 200);
var json = JsonConvert.SerializeObject(res);
return(Content(json, "application/json"));
}
catch (Exception e)
{
return(StatusCode(400, new { message = e.Message }));
}
}
public ActionResult GetResponse(FormModel model)
{
ResponseForm responseForm = new ResponseForm();
Session["FormId"] = responseForm.FormId.ToString();
responseForm.FormId = model.FormId;
responseForm.FormName = model.FormName;
responseForm.Name = model.FirstName + " " + model.LastName;
responseForm.UserEmail = model.Email;
db.ResponseForms.Add(responseForm);
db.SaveChanges();
Response data = new Response();
data.UserEmail = model.Email;
foreach (var fields in model.formField.OrderBy(x => x.SortIndex))
{
data.Id = fields.Id;
data.FormId = model.FormId;
data.FormName = model.FormName;
data.FieldType = fields.FieldType;
data.FieldName = fields.FieldName;
var NameData = model.FirstName + " " + model.LastName;
var Emaildata = model.Email;
if (fields.FieldType == "Name")
{
data.FieldResponse = NameData;
}
else if (fields.FieldType == "Email")
{
data.FieldResponse = Emaildata;
}
else if (fields.FieldType == "Address")
{
var value = string.Format(fields.StreetAdress + ", " + fields.Adressline2 + ", " + fields.City + "-" + fields.PinCode + ", " + model.state + ", " + model.country);
data.FieldResponse = value;
}
else
{
data.FieldResponse = fields.FieldResponse;
}
db.Responses.Add(data);
db.SaveChanges();
}
return(RedirectToAction("Thanks"));
}
public void HandleFileInternal(object param)
{
string filePath = (string)param;
try
{
var request = GetRequest(filePath);
var response = request.GetResponse();
FileUploadResponse rspObject = GetObjectResponse(response);
if (rspObject.success)
{
if (string.IsNullOrWhiteSpace(rspObject.redirectTo))
{
MessageBox.Show("Something wrong espUrl is empty.", "espUrl is empty");
}
else
{
Clipboard.SetDataObject(rspObject.redirectTo, true);
var form = new ResponseForm(rspObject);
form.ShowDialog();
}
}
else
{
if (rspObject.validators != null)
{
var str = new StringBuilder();
str.AppendLine("An error has been encountered while validating your file. See detailed error messages below:");
foreach (var validError in rspObject.validators)
{
str.AppendLine(validError);
}
MessageBox.Show(str.ToString(), "espUrl error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("An error has been encountered on the server. \n" + rspObject.error, "espUrl error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "espUrl error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public ResponseForm <int> DeleteRole(string ID, string USER_ID)
{
try
{
DynamicParameters param = new DynamicParameters();
param.Add("@ID", ID);
string sql = @"update ROLES_TLS";
sql += " set DELETED=1, MODIFIED_USER_ID=@MODIFIED_USER_ID,DATE_MODIFIED=@DATE_MODIFIED where ID=@ID";
param.Add("@DATE_MODIFIED", DateTime.Now);
param.Add("@MODIFIED_USER_ID", USER_ID);
var role = DapperORM.Count(sql, param);
ResponseForm <int> response = new ResponseForm <int>(role, "ok", 200);
return(response);
}
catch
{
ResponseForm <int> response = new ResponseForm <int>(-1, "fail", 500);
return(response);
}
}
public void TryUpload(Stream stream, string name)
{
using (var client = new HttpClient(baseUrl))
{
var fileContent = new StreamContent(stream);
var content = new MultipartFormDataContent {
{ fileContent, "UploadFile", name }
};
var response = client.Post("upload?AutoResize=true", content);
var serializer = new DataContractJsonSerializer(typeof(FileUploadResponse));
var streamReader = response.Content.ContentReadStream;
response.EnsureSuccessStatusCode();
var rspObject = serializer.ReadObject(streamReader) as FileUploadResponse;
CheckSuccessfulUpload(rspObject);
Clipboard.SetDataObject(rspObject.redirectTo, true);
var form = new ResponseForm(rspObject);
form.ShowDialog();
}
}
public ResponseForm <int> Delete(string ID, string USER_ID)
{
try
{
DynamicParameters param = new DynamicParameters();
param.Add("@ID", new Guid(ID));
string sql = @"update BRANCHS";
sql += " set DELETED=1, MODIFIED_USER_ID=@MODIFIED_USER_ID,DATE_MODIFIED=@DATE_MODIFIED where ID=@ID";
param.Add("@DATE_MODIFIED", DateTime.Now);
param.Add("@MODIFIED_USER_ID", USER_ID);
var branch = DapperORM.Count(sql, param);
ResponseForm <int> response = new ResponseForm <int>(branch, "ok", 200);
return(response);
}
catch (Exception e)
{
ResponseForm <int> response = new ResponseForm <int>(-1, e.Message, 600);
return(response);
}
}
private void ShowResponse()
{
UploadResult result = GetCurrentUploadResult();
if (result != null && !string.IsNullOrEmpty(result.Source))
{
ResponseForm form = new ResponseForm(result.Source);
form.Icon = this.Icon;
form.Show();
}
}
public ResponseForm Delete(string ID)
{
ResponseForm Response = BLL.DeleteItem(ID);
return(Response);
}
public ResponseForm Item([FromBody] Item NewItem, string OldItemID, [FromBody] List <Package> PackageList = null)
{
ResponseForm Response = BLL.UpdateITem(NewItem, OldItemID, PackageList);
return(Response);
}
public ResponseForm Item([FromBody] Item _item, [FromBody] List <Package> PackageList = null)
{
ResponseForm Response = BLL.AddNewItem(_item, PackageList);
return(Response);
}
public ResponseForm Item(string ID)
{
ResponseForm Response = BLL.GetItemByID(ID);
return(Response);
}
