public static int Insert(tblCompany company) { dbEcustomEntities _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true)); _db.Connection.Open(); company.CreatedDate = CommonFactory.GetCurrentDate(); company.ModifiedDate = CommonFactory.GetCurrentDate(); _db.AddTotblCompanies(company); try { if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open(); return _db.SaveChanges(); } catch (Exception ex) { return -1; } finally { _db.Connection.Close(); } }