protected void lkbUpdate_Click(object sender, EventArgs e)
{
List <Int64> offerIds = new List <Int64>();
//decimal FinalCommision;
List <Transaction_Feed> feeds = new List <Transaction_Feed>();
foreach (GridViewRow row in gvItems.Rows)
{
if (((CheckBox)row.FindControl("chkRow")).Checked)
{
Transaction_Feed item = new Transaction_Feed();
Int64 offerID = Convert.ToInt32(gvItems.DataKeys[row.RowIndex].Value);
item.OmgTransactionID = gvItems.DataKeys[row.RowIndex]["OmgTransactionID"].ToString();
item.OmgMerchantRef = gvItems.DataKeys[row.RowIndex]["omgmerchantref"].ToString();
item.MerchantName = gvItems.DataKeys[row.RowIndex]["MerchantName"].ToString();
item.UserEmail = gvItems.DataKeys[row.RowIndex]["UserEmail"].ToString();
if (!string.IsNullOrEmpty(((TextBox)row.FindControl("txtFinalCommision")).Text))
{
item.FinalCommision = Convert.ToDecimal(((TextBox)row.FindControl("txtFinalCommision")).Text);
}
feeds.Add(item);
offerIds.Add(offerID);
if (!string.IsNullOrEmpty(item.UserEmail))
{
SendEmail(item.UserEmail, item.FinalCommision.ToString(), item.OmgMerchantRef.ToString(), item.MerchantName);
}
}
}
EventHandler Insert = this.InsertCommand;
if (Insert != null)
{
Transaction_FeedInsert = feeds;
//lblMessage.Text = string.Empty;
Insert(this, e);
// TransFromDB();
}
if (offerIds.Count > 0)
{
EventHandler update = this.UpdateCommand;
if (update != null)
{
this.Ids = offerIds;
//lblMessage.Text = string.Empty;
update(this, e);
TransFromDB();
}
}
}
void _view_DeleteCommand(object sender, EventArgs e)
{
try
{
Transaction_Feed c = new Transaction_Feed();
_model.DBOperation(Constants.Action.Delete, c, _view.Ids);
_view.strMessage = "Successfully Deleted!!!";
LoadViewFromModel();
_view.DataBind();
}
catch (Exception ex)
{
_view.strMessage = ex.Message;
}
}
void _view_InsertCommand(object sender, EventArgs e)
{
try
{
//Transaction_Feed item = new Transaction_Feed();
foreach (Transaction_Feed _item in _view.Transaction_FeedInsert)
{
Transaction_Feed item = new Transaction_Feed();
item.ClickTime = _item.ClickTime;
item.TransactionTime = _item.TransactionTime;
item.OmgTransactionID = _item.OmgTransactionID;
item.OmgMerchantRef = _item.OmgMerchantRef;
item.UID = _item.UID;
item.UID2 = _item.UID2;
item.MID = _item.MID;
item.MerchantName = _item.MerchantName;
item.PID = _item.PID;
item.Product = _item.Product;
item.Referrer = _item.Referrer;
item.SR = _item.SR;
item.VR = _item.VR;
item.NVR = _item.NVR;
item.Status = _item.Status;
item.Paid = _item.Paid;
item.Completed = _item.Completed;
item.UKey = _item.UKey;
item.TransactionValue = _item.TransactionValue;
item.VoucherCode = _item.VoucherCode;
item.FinalCommision = _item.FinalCommision;
_model.DBOperation(Constants.Action.Insert, item);
}
_view.strMessage = "Successfully Inserted!!!";
LoadViewFromModel();
_view.DataBind();
}
catch (Exception ex)
{
_view.strMessage = ex.Message;
}
}
private void AssignDataToDbParameter(DataTable dt)
{
//Transaction_Feeds
List <Transaction_Feed> feeds = new List <Transaction_Feed>();
foreach (DataRow row in dt.Rows)
{
Transaction_Feed item = new Transaction_Feed();
item.ClickTime = row["ClickTime"].ToString();
item.TransactionTime = Convert.ToDateTime(row["TransactionTime"].ToString());
item.OmgTransactionID = row["TransactionID"].ToString();
item.OmgMerchantRef = row["MerchantRef"].ToString();
if (dt.Columns.Contains("UID"))
{
item.UID = row["UID"].ToString();
}
//item.UID2 = row["UID2"].ToString();
item.MID = row["MID"].ToString();
//item.MerchantName = row["MerchantName"].ToString();
item.PID = row["PID"].ToString();
item.Product = row["Product"].ToString();
item.Referrer = row["Referrer"].ToString();
item.SR = row["SR"].ToString();
item.VR = row["VR"].ToString();
item.NVR = row["NVR"].ToString();
item.Status = row["Status"].ToString();
item.Paid = row["Paid"].ToString();
if (dt.Columns.Contains("Completed"))
{
item.Completed = row["Completed"].ToString();
}
item.UKey = row["UKey"].ToString();
item.TransactionValue = row["TransactionValue"].ToString();
if (dt.Columns.Contains("VoucherCode"))
{
item.VoucherCode = row["VoucherCode"].ToString();
}
feeds.Add(item);
}
Transaction_FeedInsert = feeds;
}
public void DBOperation(Constants.Action command, Transaction_Feed item = null, List <long> IDs = null)
{
switch (command)
{
case Constants.Action.Insert:
client.InsertTransactionFeed(item);
break;
case Constants.Action.Delete:
client.DeleteTransactionFeed(IDs);
break;
case Constants.Action.Update:
client.UpdateTransactionFeed(IDs);
break;
default:
break;
}
}
protected void lkbUpdateValidate_Click(object sender, EventArgs e)
{
List <Int64> offerIds = new List <Int64>();
//decimal FinalCommision;
List <Transaction_Feed> feeds = new List <Transaction_Feed>();
foreach (GridViewRow row in gvItems.Rows)
{
if (((CheckBox)row.FindControl("chkRow")).Checked)
{
Transaction_Feed item = new Transaction_Feed();
Int64 offerID = Convert.ToInt32(gvItems.DataKeys[row.RowIndex].Value);
offerIds.Add(offerID);
}
}
clsCommonMethods obj = new clsCommonMethods();
obj.UpdateTransactionFeed(offerIds, Convert.ToInt16(Constants.AmountStatus.Validated));
lblMessage.Text = "Validate User amount.";
}
