void AddNewStoredProcedure() { string spname = txtspname.Text.Trim(); StoredProcedureBusiness spData = new StoredProcedureBusiness(); var splist = spData.GetStoredProcedureList(AppTimeConfiguration.MainServer); if (splist.Select(x => x.SPName.ToLower()).Contains(spname.ToLower())) { string procname = splist.Where(x => x.SPName.ToLower() == spname.ToLower()).First().SPName; EntityBusiness edata = new EntityBusiness(); SPModel sp = new SPModel(); sp.SPName = procname; sp.SPDate = dtpScriptDate.Value; sp.CreatedDate = DateTime.Now; long res = edata.AddNewSP(sp); if (res != -1) { LoadStoredProcedures(dtpScriptDate.Value); txtspname.Clear(); } else { MessageBox.Show("Stored Procedures already exists.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Stored Procedures does not exists in current database.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
public long AddNewSP(SPModel sp) { try { return entityData.AddNewSP(sp); } catch (Exception ex) { throw new Exception(ex.Message); } }
public long AddNewSP(SPModel sp) { try { using (DevKitEntities db = new DevKitEntities()) { bool exists = db.StoredProcedures.AsEnumerable().Any(x => x.SPName.ToLower() == sp.SPName.ToLower() && x.SPDate == sp.SPDate); if (exists) { return -1; } StoredProcedure nsp =new StoredProcedure(); nsp.SPName = sp.SPName; nsp.CreatedDate = sp.CreatedDate; nsp.SPDate = sp.SPDate; db.StoredProcedures.Add(nsp); db.SaveChanges(); return nsp.Id; } } catch (Exception ex) { throw new Exception(ex.Message); } }