public override void Save()
{
try
{
if (grdPostCodes.Rows.Where(c => c.Cells[COLS.Check].Value.ToBool() == true).Count() == 0)
{
ENUtils.ShowMessage("Please select PostCodes");
return;
}
StringBuilder sb = new StringBuilder();
var listMain = (from a in grdSelectedPostCodes.Rows.OrderBy(C => C.Index)
select new
{
Id = a.Cells[COLS.Id].Value,
PostCode = a.Cells[COLS.PostCode].Value
}).ToList();
foreach (var item in listMain)
{
sb.Append("insert into PAFDb.dbo.Localization (PostCode,PostCodeId) values ('" + item.PostCode.ToStr() + "'," + item.Id + ");");
}
using (TaxiDataContext db = new TaxiDataContext())
{
db.stp_SavePostCodes(sb.ToStr());
}
this.Close();
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}