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);
}
}
