/// <summary>
/// Handles the Click event of the btn_Insert control.
/// </summary>
/// <param name="sender">Source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/>Instance containing the event data.</param>
/// <remarks>
/// Sequence Diagram:<br/>
/// <img src="SequenceDiagrams/SD_PrintRoverWeb.Administration.ManageDBUploadUsers.ButtonInsert_Click.jpg"/>
/// </remarks>
protected void ButtonInsert_Click(object sender, EventArgs e)
{
DataTable dtCsvFileData = new DataTable();
dtCsvFileData.Locale = CultureInfo.InvariantCulture;
if (ViewState["FileName"].ToString() == "csv")
{
dtCsvFileData = (DataTable)Session["csvFileData"];
}
if (ViewState["FileName"].ToString() == "xml")
{
dtCsvFileData = (DataTable)Session["XMLFileData"];
}
string rechargeID = string.Empty;
bool isRecharege = false;
string amount = string.Empty;
int recSlno = 0;
DataTable datatableManageCards = new DataTable();
datatableManageCards.Columns.Add("REC_SLNO", typeof(int));
datatableManageCards.Columns.Add("RECHARGE_ID", typeof(string));
datatableManageCards.Columns.Add("IS_RECHARGE", typeof(Boolean));
datatableManageCards.Columns.Add("USER_ID", typeof(string));
datatableManageCards.Columns.Add("AMOUNT", typeof(string));
datatableManageCards.Columns.Add("RECHARGE_DEVICE", typeof(string));
datatableManageCards.Columns.Add("RECHARGE_BY", typeof(string));
datatableManageCards.Columns.Add("REFERENCE_NO", typeof(string));
datatableManageCards.Columns.Add("REC_CDATE", typeof(string));
datatableManageCards.Columns.Add("REC_MDATE", typeof(string));
for (int insRow = 0; insRow < dtCsvFileData.Rows.Count; insRow++)
{
recSlno = 1 + insRow;
rechargeID = dtCsvFileData.Rows[insRow][listCSVColumns.Items[0].Text].ToString();
if (dtCsvFileData.Rows[insRow][listCSVColumns.Items[1].Text].ToString() == null || dtCsvFileData.Rows[insRow][listCSVColumns.Items[1].Text].ToString().ToLower() == "false")
{
isRecharege = false;
}
if (dtCsvFileData.Rows[insRow][listCSVColumns.Items[1].Text].ToString().ToLower() == "true")
{
isRecharege = true;
}
amount = dtCsvFileData.Rows[insRow][listCSVColumns.Items[2].Text].ToString();
//User ID
try
{
if (!string.IsNullOrEmpty(rechargeID) && !string.IsNullOrEmpty(amount))
{
datatableManageCards.Rows.Add(recSlno, rechargeID, isRecharege, "", Protector.EncodeString(amount), "WEB", "admin", "", DateTime.Now.Month + "/" + DateTime.Now.Day + "/" + DateTime.Now.Year, DateTime.Now.Month + "/" + DateTime.Now.Day + "/" + DateTime.Now.Year);
}
}
catch
{
}
}
string str_InsertCSVData = DataManager.Controller.Users.UpdateTopUPCards(datatableManageCards, "T_MY_BALANCE");
if (string.IsNullOrEmpty(str_InsertCSVData))
{
string serverMessage = "Topup cards imported Sucessfully"; //Localization.GetServerMessage("", Session["selectedCulture"] as string, "INSERT_SUCESS");
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jSuccess('" + serverMessage + "');", true);
return;
}
else
{
string serverMessage = "Failed To import Topup cards"; //Localization.GetServerMessage("", Session["selectedCulture"] as string, "INSERT_FAILED");
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jError('" + serverMessage + "');", true);
return;
}
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
string amount = TextBoxAmount.Text;
string userId = HiddenFieldSelectedCostProfile.Value;
string userName = "";
string remarks = TextBoxRemarks.Text;
string rechargeId = TextBoxRecharge.Text; //set textbox value
bool isValid = false;
bool status = false;
if (!string.IsNullOrEmpty(userId))
{
if (!string.IsNullOrEmpty(rechargeId))
{
DbDataReader dbBalance = DataManager.Controller.Users.CheckBalance(rechargeId);
if (dbBalance.HasRows)
{
while (dbBalance.Read())
{
if (dbBalance["IS_RECHARGE"].ToString() == "False")
{
string rechargeID = dbBalance["RECHARGE_ID"].ToString();
amount = dbBalance["AMOUNT"].ToString();
if (rechargeId == rechargeID)
{
isValid = true;
string message = DataManager.Controller.Users.AddBalance(rechargeId, amount, userId, userName);
if (!string.IsNullOrEmpty(message))
{
string serverMessage = "Failed to update balance";
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jError('" + serverMessage + "');", true);
}
else
{
status = true;
string serverMessage = "Update success";
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jSuccess('" + serverMessage + "');", true);
sendConfirmationEmail(rechargeId, userId, amount);
}
string reasult = DataManager.Controller.Users.UpdateRechargeid(rechargeId);
break;
}
}
}
}
if (dbBalance != null && dbBalance.IsClosed == false)
{
dbBalance.Close();
}
if (isValid == false)
{
//ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "ShowMessage(0);", true);
//LabelErrorMessage.Text = "Please enter the valid Top-Up Card"; //Localization.GetServerMessage(Constants.APPLICATION_TYPE_OSA_CLASSIC, deviceCulture, "PLEASE_SELECT_JOB");
}
}
else
{
string message = DataManager.Controller.Users.AddUserAmount(Protector.EncodeString(amount), userId, userName, remarks, rechargeId);
if (!string.IsNullOrEmpty(message))
{
string serverMessage = "Failed to update balance";
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jError('" + serverMessage + "');", true);
}
else
{
status = true;
string serverMessage = "Update success";
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jSuccess('" + serverMessage + "');", true);
}
}
}
else
{
//value cannot be null
string serverMessage = "value cannot be null";
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jError('" + serverMessage + "');", true);
}
GetUserSource();
GetUsers();
GetCostProfiles();
BuildUserAccountSummery();
}
