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