private void btnSave_Click(object sender, EventArgs e) { try { //if (grdETAKeys.Rows.Count == 0) //{ // ENUtils.ShowMessage("Required : Keys "); // return; //} string key = "etakeys"; using (TaxiDataContext db = new TaxiDataContext()) { db.ExecuteCommand("delete from mapkeys where maptype='" + key + "'"); int cnt = 10; string ApiKey = string.Join("<etakeys>", grdETAKeys.Rows.Select(c => c.Cells["column1"].Value.ToStr().ToUpper()).ToArray <string>()); db.ExecuteCommand("insert into mapkeys (Id,MapType,APIKey) values (" + cnt + ",'" + key + "','" + ApiKey + "')"); //foreach (var item in grdETAKeys.Rows) //{ //column1 //db.ExecuteCommand("insert into mapkeys values("+cnt+",'etakeys from mapkeys where maptype='etakeys'"); //} //string key = db.ExecuteQuery<string>("select APIKey from mapkeys where maptype='etakeys'").FirstOrDefault().ToStr().Trim(); //if (key.ToStr().Trim().Length > 0) //{ // foreach (var item in key.ToStr().Trim().Split(new string[] { "<etakey>" }, StringSplitOptions.RemoveEmptyEntries)) // { // ETAKeys.Add(item); // } //} } ENUtils.ShowMessage("Key Saved successfully"); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void UpdateRecord() { try { string AppType = ddlApplicationType.Text.ToStr(); string Error = ""; int? ApplicationTypeId = null;// ddlApplicationType.SelectedValue.ToInt(); string Link = txtLink.Text.Trim(); string Version = txtVersion.Text.Trim(); if (AppType == "Android Driver App") { ApplicationTypeId = 1; } else if (AppType == "Iphone Driver App") { ApplicationTypeId = 2; } if (ApplicationTypeId == null) { Error = "Required : Application Type"; } if (string.IsNullOrEmpty(Link)) { if (string.IsNullOrEmpty(Error)) { Error = "Required : App Url"; } else { Error += Environment.NewLine + "Required : App Url"; } } if (string.IsNullOrEmpty(Version)) { if (string.IsNullOrEmpty(Error)) { Error = "Required : App Version"; } else { Error += Environment.NewLine + "Required : App Version"; } } if (!string.IsNullOrEmpty(Error)) { ENUtils.ShowMessage(Error); return; } using (TaxiDataContext db = new TaxiDataContext()) { int I = db.ExecuteCommand("update AppsLink set Link='" + Link + "', Version = '" + Version + "' where Id= " + ApplicationTypeId + ""); } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }