public override void Save()
{
try
{
if (grdPostCodes.RowCount == 0)
{
ENUtils.ShowMessage("Required : Post Code");
return;
}
StringBuilder sb = new StringBuilder();
StringBuilder sb2 = new StringBuilder();
//sb.Append("delete from StreetsData.dbo.Localization;");
//sb.Append("delete from StreetsData.dbo.LocalizationDetails;");
List <string> objList = new List <string>();
string PostCode = string.Join(",", grdPostCodes.Rows.Select(c => c.Cells[COLS.PostCode].Value.ToStr()).ToArray <string>());
string NewPostCode = string.Empty;
foreach (var item in PostCode.Split(','))
{
string Word = string.Empty;
for (int i = 0; i < item.Length; i++)
{
if (item[i].ToStr().IsNumeric() == true)
{
objList.Add(Word);
break;
}
else
{
Word += item[i].ToStr();
}
}
}
//var list = objList.Distinct().ToList();
//foreach (var item in list)
//{
// sb.Append("insert into PAFDb.dbo.Localization (PostCode) values ('" + item.ToStr() + "%" + "');");
//}
var list2 = grdPostCodes.Rows.Select(c => c.Cells[COLS.PostCode].Value).ToList();
foreach (var item in list2)
{
sb2.Append("insert into PAFDb.dbo.LocalizationDetail (PostCode) values ('" + item.ToStr() + "');");
}
using (TaxiDataContext db = new TaxiDataContext())
{
db.stp_SaveLocalaization(sb.ToStr(), sb2.ToStr());
}
General.LoadZoneList();
this.Close();
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}