//-----------------------------------------------
//SaveData
//-----------------------------------------------
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
//--------------------------------------
if (fuFile.HasFile)
{
if (fuFile.PostedFile.ContentType == "text/plain")
{
string fileName = DCServer.MapPath(DCSiteUrls.GetPath_Sms_SMSFiles() + fuFile.FileName);
fuFile.SaveAs(fileName);
//---------------------------------------
string[] mobileNumbersToImport = File.ReadAllLines(fileName);
int count = 0;
//---------------------------------------
int successfullyNumbersCount = 0;
string existsNumbers = "";
int existsNumbersCount = 0;
string failedNumbers = "";
int failednumbersCount = 0;
string notmobileNumbers = "";
int notNumbersCount = 0;
//---------------------------------------------------------------------
//---------------------------------------------------------------------
SMSNumbersEntity smsUser = new SMSNumbersEntity();
//---------------------------------------------------------------------
//props
//---------------------------------------------------------------------
Languages langID = (Languages)SiteSettings.Languages_DefaultLanguageID;
if (SiteSettings.Languages_HasMultiLanguages)
{
langID = (Languages)Convert.ToInt32(ddlLanguages.SelectedValue);
}
//-------------------------------------------
smsUser.LangID = langID;
//-------------------------------------------
smsUser.IsActive = cbIsActive.Checked;
//-------------------------------------------
if (ddlSmsGroups.SelectedValue != "-1")
{
smsUser.GroupID = Convert.ToInt32(ddlSmsGroups.SelectedValue);
}
//---------------------------------------------------------------------
char[] Splitter = { '-' };
string[] record = null;
string name = "";
string number = "";
bool isMobile = false;
//---------------------------------------------------------------------
ExecuteCommandStatus status;
//---------------------------------------------------------------------
foreach (string newRecord in mobileNumbersToImport)
{
name = "";
number = "";
isMobile = false;
try
{
record = newRecord.Split(Splitter);
switch (record.Length)
{
case 1:
number = record[0].Trim();
isMobile = DCValidation.IsMobileNumber(number);
break;
case 2:
number = record[0].Trim();
name = record[1].Trim();
isMobile = DCValidation.IsMobileNumber(number);
break;
default:
break;
}
if (isMobile)
{
smsUser.Numbers = number;
smsUser.Name = name;
status = SMSNumbersFactory.Create(smsUser);
switch (status)
{
case ExecuteCommandStatus.Done:
++successfullyNumbersCount;
break;
case ExecuteCommandStatus.AllreadyExists:
existsNumbers += newRecord + "<br>";
++existsNumbersCount;
break;
case ExecuteCommandStatus.UnknownError:
failedNumbers += newRecord + "<br>";
++failednumbersCount;
break;
default:
failedNumbers += newRecord + "<br>";
++failednumbersCount;
break;
}
}
else
{
notmobileNumbers += newRecord + "<br>";
++notNumbersCount;
}
}
catch (Exception wx)
{
notmobileNumbers += newRecord + "<br>";
++notNumbersCount;
}
}
//---------------------------------------------------------------------------------------------
lblSuccessfulyRecords.Text = string.Format(Resources.SmsAdmin.ImportSuccessfulyCount, successfullyNumbersCount);
lblNotMobileNumbers.Text = string.Format(Resources.SmsAdmin.NotImportNotNumbersCount, notNumbersCount) + " <br />" + notmobileNumbers;
lblExistsMobileNumbers.Text = string.Format(Resources.SmsAdmin.NotImportAlradyExistCount, existsNumbersCount) + " <br />" + existsNumbers;
lblFailedMobileNumbers.Text = string.Format(Resources.SmsAdmin.NotImportFailiarCount, failednumbersCount) + " <br />" + failedNumbers;
//---------------------------------------------------------------------------------------------
}
else
{
lblResult.CssClass = "operation_error";
lblResult.Text = Resources.SmsAdmin.FileNotSupportedFile;
}
}
else
{
lblResult.CssClass = "operation_error";
lblResult.Text = Resources.SmsAdmin.FileNotFound;
}
//--------------------------------------
}
//-----------------------------------------------
//btnSave_Click
//-----------------------------------------------
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
if (FuFile.HasFile)
{
try
{
string FileName = DCServer.MapPath(DCSiteUrls.GetPath_Sms_SMSFiles() + FuFile.FileName);
FuFile.SaveAs(FileName);
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + DCServer.MapPath(DCSiteUrls.GetPath_Sms_SMSFiles() + FuFile.FileName) + ";" + "Extended Properties=Excel 8.0;";
// Create connection object by using the preceding connection string.
OleDbConnection objConn = new OleDbConnection(sConnectionString);
// Open connection with the database.
objConn.Open();
// The code to follow uses a SQL SELECT command to display the data from the worksheet.
// Create new OleDbCommand to return data from worksheet.
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
// Create new OleDbDataAdapter that is used to build a DataSet
// based on the preceding SQL SELECT statement.
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
// Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect;
// Create new DataSet to hold information from the worksheet.
DataSet objDataset1 = new DataSet();
// Fill the DataSet with the information from the worksheet.
objAdapter1.Fill(objDataset1, "XLData");
//---------------------------------------------------------------------
SMSNumbersEntity smsUser = new SMSNumbersEntity();
//---------------------------------------------------------------------
//props
//---------------------------------------------------------------------
Languages langID = (Languages)SiteSettings.Languages_DefaultLanguageID;
if (SiteSettings.Languages_HasMultiLanguages)
{
langID = (Languages)Convert.ToInt32(ddlLanguages.SelectedValue);
}
//-----------------------
smsUser.LangID = langID;
//-----------------------
if (SiteSettings.Sms_HasGroups)
{
smsUser.GroupID = Convert.ToInt32(ddlSmsGroups.SelectedValue);
}
//-----------------------
smsUser.ModuleTypeID = (int)StandardItemsModuleTypes.SMS;
//-----------------------
smsUser.IsActive = cbIsActive.Checked;
//--------------------------------------
int successfullyNumbersCount = 0;
string existsNumbers = "";
int existsNumbersCount = 0;
string failedNumbers = "";
int failednumbersCount = 0;
string notmobileNumbers = "";
int notNumbersCount = 0;
//---------------------------------------------------------------------
string newRecord = "";
string name = "";
string number = "";
bool isMobile = false;
//---------------------------------------------------------------------
ExecuteCommandStatus status;
//---------------------------------------------------------------------
for (int i = 0; i < objDataset1.Tables[0].Rows.Count; i++)
{
name = "";
number = "";
newRecord = "";
isMobile = false;
try
{
number = objDataset1.Tables[0].Rows[i].ItemArray[0].ToString();
name = objDataset1.Tables[0].Rows[i].ItemArray[1].ToString();
if (string.IsNullOrEmpty(name))
{
newRecord = number;
}
else
{
newRecord = number + " - " + name;
}
isMobile = DCValidation.IsMobileNumber(number);
if (isMobile)
{
smsUser.Numbers = number;
smsUser.Name = name;
status = SMSNumbersFactory.Create(smsUser);
switch (status)
{
case ExecuteCommandStatus.Done:
++successfullyNumbersCount;
break;
case ExecuteCommandStatus.AllreadyExists:
existsNumbers += newRecord + "<br>";
++existsNumbersCount;
break;
case ExecuteCommandStatus.UnknownError:
failedNumbers += newRecord + "<br>";
++failednumbersCount;
break;
default:
failedNumbers += newRecord + "<br>";
++failednumbersCount;
break;
}
}
else
{
notmobileNumbers += newRecord + "<br>";
++notNumbersCount;
}
}
catch (Exception ex2)
{
notmobileNumbers += newRecord + "<br>";
++notNumbersCount;
}
}
objConn.Close();
//---------------------------------------------------------------------------------------------
lblSuccessfulyRecords.Text = string.Format(Resources.SmsAdmin.ImportSuccessfulyCount, successfullyNumbersCount);
lblNotMobileNumbers.Text = string.Format(Resources.SmsAdmin.NotImportNotNumbersCount, notNumbersCount) + " <br />" + notmobileNumbers;
lblExistsMobileNumbers.Text = string.Format(Resources.SmsAdmin.NotImportAlradyExistCount, existsNumbersCount) + " <br />" + existsNumbers;
lblFailedMobileNumbers.Text = string.Format(Resources.SmsAdmin.NotImportFailiarCount, failednumbersCount) + " <br />" + failedNumbers;
//---------------------------------------------------------------------------------------------
}
catch (Exception ex)
{
lblResult.CssClass = "operation_error";
lblResult.Text = Resources.SmsAdmin.FileNotSupportedFile;
}
}
else
{
lblResult.CssClass = "operation_error";
lblResult.Text = Resources.SmsAdmin.FileNotFound;
}
}
